Essential Studio for ASP.NET MVC Release Notes

v17.3.0.9

September 20, 2019

DocIO

Features

#237184 - Provided support to preserve the Ole Equation as Bitmap in Word to PDF conversion.
#105883 , #134917, #170211, #239966, #244366, #F146503 - Provided support to create and apply custom table styles in a Word document.
#94996, #F116887, #137337, #137532, #147886, #159260, #163472, #182382, #183354, #140858, #197030, #199916, #201860, #212424, #232214, #234693 - Provided support to shape and Text box rotation in DOCX , Word to PDF and Word to image conversion.

Bug Fixes

#241691 - The ArgumentOutOfRangeException will no longer be thrown while opening a DOC format Word document.
#240393 - Line numbers are now preserved properly when resaving the Word document.
#242018 - Text encoding issue has been resolved while opening a RTF format Word document.
#241885 - Line spacing is now preserved properly while converting a Word document into HTML.
#F143774 - Paragraphs are now preserved properly while performing horizontal cell merge in a Word document.
#241475 - Nested IF field result is now preserved properly while converting a Word document as a Text file.
#237339 - ActualFormatType is now considered as DOCX when creating a new Word document from scratch.
#239792 - Character format is applied properly in Inline content control while opening Word document.
#239895 - The NullReferenceException will no longer be thrown when updating the fields in the Word document.
#239579 - Text border is preserved properly when converting HTML to Word document.
#238722 - Character format is applied properly while updating document fields.
#F143772 - Nested bookmark is now preserved properly while opening a DOC format Word document.
#225399, #220198, #209881, #209466, #204167 - RTL text alignment and indent issues has been resolved while converting a Word document to PDF.
#242278, #241397, #240195, #240030, #239658, #238960, #238709, #238528, #237804, #245011, #217699 - Hanging issue has been resolved while converting a Word document to PDF.
#243412 - Tab leader is now preserved properly while converting a Word document to PDF.
#239746, #238528 - Text is now preserved properly while converting a Word document to PDF.
#226594 - Underline is now preserved properly while converting a Word document to PDF in fast rendering.
#242601 - Font is now preserved properly while converting a Word document to PDF.
#242252 - TOC text color is now drawn properly while converting a Word document to PDF.
#239895, #240393, #226352 - Paragraph is now preserved properly while converting a Word document to PDF.
#230817, #240393 - Shape is now preserved properly while converting a Word document to PDF.
#240393 - Spacing issue has been resolved while converting a Word document to PDF.
#238528 - Blank page preservation issue has been resolved while converting a Word document to PDF.
#238528 - Table is now preserved properly while converting a Word document to PDF.
#240393, #239828 - The IndexOutOfRangeException will no longer be thrown while converting the Word document to PDF.
#239439 - Vertical text fill color is now drawn properly while converting a Word document to PDF.
#237804 - Tab is now preserved properly while converting a Word document to PDF.
#239439 - Text box is now preserved properly while converting a Word document to PDF.
#238072 - Horizontally merged table cell border is now preserved properly while converting a Word document to PDF.
#244161 - Table is now preserved properly while converting a Word document to PDF.
#242252 - Macro button field result is now preserved properly while converting a Word document to PDF.
#244161 – The NullReferenceException will no longer be thrown while converting a Word document to Image.
#243494 - Bookmarks are now preserved properly while converting a Word document to PDF.
#245094 - The paragraph style name is now preserved properly in the StyleName property while parsing RTF format document.
#240020 - Images and tables are now preserved properly in HTML export when the system scaling value is other than 100%.
#237184, #131175 - Child shape line weight is now preserved properly while converting a Word document to PDF.
#237184 - Rounded rectangle shape is now preserved properly while converting a Word document to PDF.
#245656 - The ArgumentOutOfRangeException will no longer be thrown while opening a DOC format Word document.
#245313 - Text is now preserved properly while converting a Word document into PDF.
#239089, #246062 - The ArgumentOutOfRangeException will no longer be thrown while replacing bookmark content in Word document.
#244946 - Font name is now updated properly while applying character format to the text range in Word document.
#244919 - The IndexOutOfBoundsException will no longer be thrown while updating document fields.
#244241 - Argument is not image byte array exception will no longer be thrown while updating alternate chunk.
#243623 - Bold is now preserved properly while converting HTML into a Word document.
#243595 - Negative values are now preserved properly while performing mail merge in a Word document.
#241184 - Image is preserved properly in content control when open and save the word document.
#F145109, #246061 - Bookmark contents are now replaced properly with the ReplaceBookmarkContent API.
#238451 - Underline is preserved in RTF to HTML conversion.
#F145124 - Hanging will no longer occur while deleting a bookmark contents.
List value is now updated properly when converting a Word document to HTML.

Maps

Bug Fixes

#239986 - ‘In Bing maps, the issue with rendering marker in custom geolocation and navigating to that position’ has been fixed.

pdf

Features

#216603 - Added support for enhanced electronics signature ETSI CAdES.
#218411, 223453, F141588 - Added support for validating digital signatures in existing PDF document.
#187514, 182262, 153360, 103910 - Added support for finding the corrupted PDF document.
#233393 - Added support for setting LeaderOffset, EndLineStyle, and BeginLineStyle in PdfLineMeasureAnnotation.
#232955 - Added support for processing PDF, which contains encryption only for attachments in PDF.
#236552 - Added support for finding the header row using event handler.

Breaking Changes

Line ending styles default value has been changed to None from Square.

Bug Fixes

#245618 - The ArgumentOutOfRangeException will no longer occur when saving the existing PDF document.
#245433 - Characters with super script will be preserved properly when rendering with Thai font.
#246397 - Document save performance with the SaveProgress event has been improved.
#237184 - Preservation and hanging issue will no longer occur when converting Word to PDF.
#244577 - PdfDocumentLinkAnnotation destination will be updated properly with provided X and Y position.
#244143 - Adjacent character removal in text redaction has been resolved.
#244220 - Logo image will be preserved properly in EMF to PDF conversion.
#242068 - Meta file will be rendered properly in EMF to PDF conversion.
#241580 - Tiling brush will be rendered properly in XPS to PDF conversion.
#243529 - Barcode will no longer have any extra blank space when rendering.
#246019 - Hanging issue will no longer occur when converting a Word document to PDF.
#244245 - Text and Icon values of PdfLoadedPopupAnnotation will be retrieved properly.
#240456 – The NullReferenceException will no longer be thrown when merging the particular documents.
#241481 – Free text annotation will no longer return invalid text.
#242049 – PdfAnnotation will be cleared properly while removing the annotations.
#238304 – Font name will be retrieved properly from the PdfLoadedAnnotation.
#239222, #239219 – Radio button page will be null if it is not added in the page.
#238725 – Inserting long text in PdfLightTable cell works properly.
#238603 – 3D annotations will be rendered properly with different Pdf3DRendermode.
#238517 – PdfFreeTextAnnotation color will be preserved properly.
#242310 – Signature information will be rendered properly when applying security.
#244368 – Radio button will be added to the existing PDF documents.
#242644 – Symbols will be encoded properly in Code 39 Extended and Code 93 Extended barcodes.
#242717 – PdfLayoutResult will return proper bounds when enabling auto tag.
#243273 – Radio button field will be flattened properly in all PDF pages.
#242335 – Text will be rendered properly when filling and flattening text with right alignment.
#241159 – Code 32 barcode is now preserved properly for the input text containing zero.
#238715 – Text will be rendered properly when converting a particular Word document to PDF.
#241580 – Tilling brush will be rendered in proper location on XPS to PDF conversion.
#241002 – The PDF document will no longer be corrupted when converting EMF to PDF.
#238709 – System out of memory exception will no longer be thrown when converting a Word document to PDF.
#F144285 - Signature bounds will be retrieved properly from the existing PDF document.
#F145476 – Content inside the child grid will be wrapped properly.
#F145826 – Barcode will be generated properly with PdfCode93Barcode.
Added appearance stream for different style radio buttons.
Text size will be calculated based on the text box field height if it does not have font or size.
Underline will no longer be added for trailing white spaces when drawing text.
Fore color will be retrieved properly from the text box field.
PdfSignatureField name will be preserved properly.
Font size of the form field will be calculated based on the field size.

PdfViewer

Bug Fixes

#240707 - PDF Viewer form filling is now working properly in mobile devices.
#240051 - Now, the combo Box font size is maintained properly during magnification.
#238989 - Now, the signatureAdd Event is triggered after drawing the hand-written signature in the page.
#239222 - Now, the extra radio button field is not rendered in the PDF page.
#244474 - The abortPrint() method will now remove the loading indicator in beforePrint event.
#242448 - Now, the PDF Viewer renders a page correctly in higher zoom values.

Presentation

Features

#F145218 - Provided support to insert the slide with PasteOptions in PowerPoint document.
#238015 - Added the Font stream property in SubstituteFontEventArgs to set alternate font stream for missing fonts in device during Presentation to PDF/Image conversion.

Bug Fixes

#F145117 - Font size will be applied properly for second paragraph of table cell.
#243282 - Images are now preserved properly while performing clone and merge in PowerPoint presentation.
#237602 - Border will be preserved properly while saving the PowerPoint presentation.
#237602 - The NullReferenceException will no longer be thrown while opening the PowerPoint presentation.

Spreadsheet

Features

Provided export support for custom format (“m/d/yyyy h:mm:ss tt”).
Provided custom format(“(#,##0);#,##0”) support.

XlsIO

Features

#238012 - Warning capture is implemented in Excel to PDF conversion.
#238012 - Unsupported font is now substituted by a font stream in Excel to PDF conversion.
#238385 - Exporting Excel data to nested class is now supported.
#F144806 - Boolean to include column headers is now provided as an overload to the ImportDataTable() method with ImportOnSave option.
Bindable attribute is implemented to skip a property on importing data from a collection.
Importing data from nested collection to Excel is now supported.

Breaking Changes

#238012 - IWarning interface is added to represent the warning details of unsupported and substituted elements.
#238012 - ShowWarning() method is added in IWarning class to show warning in the workbook.
#238012 - Cancel property in IWarning class gets or sets a boolean value to cancel the current process.
#238012 - Warning property is added in ExcelToPdfConverterSettings class to get warning detail in Excel to PDF conversion.
#238012 - WarningInfo class is added to represent the warning details with type and description.
#238012 - Description property is implemented in WarningInfo class to get description of the warning.
#238012 - Type property is implemented in WarningInfo class to get the type of the warning.
#238012 - WarningType enum is added to specify the type for the specific warning.
#238012 - AlternateFontStream property in SubstituteFontEventArgs class gets or sets the alternate font stream.
#238385 - ExportData<T>() method is added in IWorksheet, WorksheetImpl, ExternWorksheetImpl and WorksheetGroup classes to export worksheet data into the collection of CLR objects.
#F144806 - ImportDataTable() method is added as an overload in WorksheetImpl, WorksheetGroup and ExternWorksheetImpl classes with a boolean to include column headers.
BindableAttribute() constructor in BindableAttribute class initializes a new instance that indicates whether a property is bindable.
Bindable property in BindableAttribute class specifies the bindable attribute for a property.
ImportData() method is added in IWorksheet, WorksheetImpl, ExternWorksheetImpl and WorksheetGroup classes to import data from class objects to a worksheet.
ExcelNestedDataLayoutOptions enum in enums class specifies how to fill the group field values while importing nested collection CLR objects.
ExcelNestedDataGroupOptions enum in enums class specifies whether the grouping is added with Collapse or Expand while importing nested collection CLR objects.
ExcelImportDataOptions class is added in IWorksheet class to specify import data options.
FirstRow property in ExcelImportDataOptions class specifies first row from where the data should be imported.
FirstColumn property in ExcelImportDataOptions class specifies first column from where the data should be imported.
IncludeHeader property in ExcelImportDataOptions class specifies whether class properties names must be imported or not.
IncludeHeaderParent property in ExcelImportDataOptions class specifies whether parent class properties names must be imported or not.
NestedDataLayoutOptions property in ExcelImportDataOptions class specifies how to fill the group field values while importing nested collection objects.
NestedDataGroupOptions property in ExcelImportDataOptions class specifies whether the grouping is added with Collapse or Expand while importing nested collection objects.
CollapseLevel property in ExcelImportDataOptions class specifies the group collapse level.

Bug Fixes

#230042, #231663 - Number and date time values are now rendered properly in Excel to PDF conversion.
#237114, #237576 - Line shapes are now rendered properly when converting Excel to PDF.
#244941, #245083 - Custom properties are now preserved properly on resaving the Excel document.
#240083 - Number alignment is now proper in Excel to PDF conversion.
#235971 - Chart series type is now preserved properly while saving the workbook with combination chart.
#240200 - Pivot table background color is now preserved properly while resaving the Excel document.
#240677 - Pivot chart is now preserved properly while resaving the Excel document.
#240083 - Chart data points will no longer be missed when converting Excel to PDF.
#239969 - Argument exception will no longer be thrown on opening the Excel file containing external workbook.
#230937 - Excel document is now converted properly while using the OFFSET function.
#236370 - DateTime value is now returned correctly in UK culture.
#238322 - Pivot table row header is now preserved properly when converting Excel to PDF.
#236131 - PivotTable will no longer be crashed on refreshing the resaved Excel file.
#239384 - Performance delay will no longer occur while resaving the Excel document.
#237809 - Conditional format formula for specific text is now updated properly while copying cells.
#236873 - DisplayText is now returned correctly when accessing the date time using formula with DDDD number format.
#238626 - Creating table with invalid table name will throw an exception.
#236136 - PercentOfParent option is now set correctly while creating a pivot table.
#237114 - AutoShape text is now rendered properly when converting Excel to PDF.
#239217 - Cell text with lesser than and greater than symbols are now preserved properly when converting the worksheet to HTML.
#236197 - Time value is now set correctly for 1904 enabled workbook.
#241751 - Checkboxes are now checked properly after resaving the Excel document.
#238322 - Grand totals of rows and columns are now preserved properly in Excel to PDF conversion.
#241336 - Excel document containing conditional formats will no longer be corrupted on inserting a row.
#237235 - Legend is now preserved properly on setting custom data label.
#240083 - Chart data point will no longer be missed when converting Excel to PDF.
#242245 - Performance has been improved while opening the SpreadsheetXML file.
#241403 - Vertical text alignment now works properly in Excel to PDF conversion.
#242613 - Japanese characters are now preserved properly in Excel to PDF conversion.
#242913 - Font name and font size will no longer be changed while opening the Excel document.
#244193 - Exception will no longer be thrown on converting the Excel document with date time to PDF.
#239659 - Checkbox when removed is now preserved properly.
#226622 - Cell value is now updated properly while coping a range from source to destination.
#239384 - Performance is improved while converting Excel document into PDF with conditional formatting.
#244535 - Filter applied columns are now auto-fitted properly.
#243110 - Code name is now preserved properly for XLSX files.
#242235 - Alternative text for chart shape is now preserved properly on resaving the Excel document.
#245833 - Worksheet with autoshapes is now cloned properly.
#243737 - Conditional format styles are now copied properly while applying marker with jump arguments.
#240083 - Conditional format formula is now calculated correctly in Excel to PDF conversion.
#244284 - Table formatting issues will no longer occur on resaving the Excel file.
#F144906 - Active worksheet is now unselected when multiple worksheets are selected in the Excel file.
#F145816 - Exception will no longer be thrown on saving the workbook after invoking the IApplication.IsSupported() method.
#F146576 - Cell with indentation will no longer be missed in worksheet to image conversion.
Exception will no longer be thrown when getting intersect range from invalid named ranges.
Saving the input document as xlsx file after saving it as xml document will no longer be corrupted.
CalcEngine will no longer be reinitialized after performing Excel to PDF conversion.
Legend text color is now preserved properly on saving the Excel document.
Chart is now preserved properly on copying the worksheet using the AddCopy() method.
Output Excel file will no longer be corrupted when an empty pivot table is updated with data and saved using XlsIO.
Exception will no longer be thrown while using named range for page setup in XlsIO.
Formula is now correct on resaving the Excel document containing formula with external workbook reference.
Exception will no longer be thrown while converting the Excel document to PDF after resave.