Essential Studio for ASP.NET Core Release Notes

v18.2.0.44
July 7, 2020

Common

Features

  • Provided the support for .NET Core 3.1 and .NET 5.0 compatibility.

    DocIO

Features

  • #266742 - Provided support to select the column range for bookmarks inside tables in Word documents using FirstColumn and LastColumn APIs.
  • #104484, #110940, #189107, #107422 - Provided support to preserve all the revisions of track changes information in a Word document.
  • #153866, #182754, #241820, #254156, #269877 - Provided support to encrypt and decrypt the Word document.
  • #168152, #179023, #201222, #211848, #214272, #219024, #214272, #248610, #253356, #256673, #275324, #277042 - Provided support for updating table of contents in a Word Document.
  • #102916, #237540, #260149 - Provided support for updating Sequence fields in a Word document.
  • #201860, #201718, #205172, #206374, #208660, #209182, #215558, #245097, #274078, #275710 - Provided support to preserve the mathematical equations (MathML) in the Word to PDF/Image conversion.
  • #272770 - Provided support to detect font from theme for the complex script characters in the Word to PDF/Image conversion.

Bug Fixes

  • #250042 - Paragraph style is now preserved properly while open and save the DOCX format Word document.
  • #267826 - Picture Watermark is now preserved properly while clone and merge the DOC format Word document.
  • #269662 - The NullReferenceException will no longer be thrown while closing the Word document.
  • #267398 - Table is now preserved properly while converting a Word document to PDF
  • #270030 - Bookmark is now preserved properly inside the Text content Control while open and save the DOCX format Word document.
  • #272560, #266791 - List numbers are now preserved properly while open and save the DOCX format Word document.
  • #271175 - List type is now set properly while parsing the HTML file.
  • #271988 - The NullReferenceException will no longer be thrown while opening a DOCX format Word document.
  • #F152998 - BeforeClearGroupFieldEventArgs now returns the proper merge field names while performing Mail merge in a Word document.
  • #271634 - The NullReferenceException will no longer be thrown while saving a DOCX format Word document.
  • #271695, #272438, #272430 - The NullReferenceException will no longer be thrown while performing Mail merge in a Word document.
  • #273310 - Left indent is now preserved properly while converting an HTML file to Word document.
  • #272621 - Table cell width is now preserved properly while converting a Word document to PDF.
  • #273378 - Background image is now preserved properly when converting a Word document to HTML file.
  • #274152 - Content control mapped text is preserved properly while converting a Word document to PDF.
  • #273378, #273856 - Background image is now preserved properly when converting RTF to DOCX format document.
  • #267834 - Table cell background is now preserved properly while Converting a HTML file to Word document.
  • #273858 - Text color is now preserved properly while resaving a Word document with background image.
  • #274432 - Protect Word document from editing is now preserved properly while resaving a DOCX format document.
  • #274414 - The NullReferenceException will no longer be thrown while opening a DOCX format document.
  • #274927 - GridSpan values of cell is now retrieved properly while opening a DOC format Word document.
  • #275320 - Invalid length for a base-64 char array or string exception will no longer be thrown while mapping a picture for picture content control in Word document.
  • #276788 - The InvalidOperationException will be no longer thrown while opening a RTF format document.
  • #276053 - LegalStyleNumbering will be preserved properly while resaving a DOCX format document.
  • #276105 - The OleObject of Link Field is now preserved properly while resaving a DOCX format document.
  • #275893 - The alternate chunk is now updated properly while converting a Word document to PDF.
  • #274393 - The NullReferenceException will no longer be thrown while replacing the bookmark content.
  • #277006 - Repeating section content control is now preserved properly while converting a Word document to PDF.
  • #277830 - Table cell borders are now preserved properly while resaving a RTF format document.
  • #272438, #273336 - The ArgumentOutOfRangeException will no longer be thrown while converting a Word document to PDF.
  • #266244 - Text is now preserved with proper alignment while converting a Word document to PDF.
  • #268875, #271698, #274381 - Hanging issue has been resolved while converting a Word document to PDF.
  • #268875 - Picture is now preserved properly while converting a Word document to PDF.
  • #270030, #271941 - Image is now preserved properly while converting a Word document to PDF.
  • #267958 - Text is now wrapped properly while converting a Word document to PDF.
  • #268928, #273361 - Text is now preserved properly while converting a Word document to PDF.
  • #272436 - Font substitution event OriginalFontName property will not return majorHAnsi while converting a Word document to PDF.
  • #272754 - Textbox is now preserved properly while converting a Word document to PDF.
  • #F152680, #274794, #279294 - Text is now preserved properly while converting a Word document to PDF.
  • #271667, #268266 - The NullReferenceException will no longer be thrown while converting a Word document to PDF.
  • #271333 - Bullet list is now preserved properly while converting a Word document to PDF.
  • #263739, #274914 - Text around the table is now wrapped properly while converting a Word document to PDF.
  • #F137285 - Image is now preserved properly while converting a Word document to PDF.
  • #274045 - Border is now preserved properly while converting a Word document to PDF.
  • #277180 - Arabic text is now preserved properly while converting a Word document to PDF.
  • #F154567 - The FormatException will no longer be thrown while converting a Word document to PDF.
  • #278496 - The footer content is now preserved properly while converting Word document to PDF.
  • #276330 - The Empty page preservation issue has been resolved while converting a Word document to PDF.
  • #274743 - Line alignment is now preserved properly while converting a Word document to PDF.
  • #274379 - The table is now preserved properly while converting a Word document to PDF.

pdf

Features

  • #268014 – Provided support to add cloud annotations in PDF document.
  • #269848 – Provided support to retrieve the exact boundaries of the highlight annotation in a PDF document.
  • #267968 – Added support to get the ColorSpace details for each page in an existing PDF document.
  • #264832 – Added support to remove the document modified date for an existing PDF document.
  • #273977 – Added support to provide options to validate the digital signatures in an existing PDF document.
  • #276918 - Added support to set the language for tagged PDF.
  • #276260 - Added support to validate the signature with the PSS algorithm.
  • #275396 - Added support to draw the text with the same baseline for different fonts.
  • #274224 - Added support to extend the margin when merging the PDF documents.
  • #198534, I258701 – Added support for compressing existing PDF documents.
  • #262320 – Added support for replace image in an existing PDF document.

Bug Fixes

  • #271164 – Exception no longer occurs when saving the document after removing annotations.
  • #261704 – Bookmark will be reflected properly after removing bookmarks.
  • #259394 – Ink annotation will be preserved properly while flattening annotation.
  • #273970 – Modified date will be retrieved properly from the input PDF document.
  • #271463 – Exception no longer occurs when accessing layers from existing PDF document.
  • #274280 – Exception no longer occurs when creating tables concurrently
  • #272832 – Exception no longer occurs when removing layers from existing PDF document.
  • #272411 – Text will be preserved properly in Word to PDF conversion.
  • #272840 – Layer name will be changed properly in existing PDF document.
  • #251733 – Barcode background and quite zones will be preserved properly.
  • #271614 – Image will be preserved properly in Word to PDF conversion.
  • #266186 – Lines will be preserved properly in Word to PDF conversion.
  • #270437 – Form fields will be flattened properly in existing PDF document.
  • #246796 – Fields and special characters preserved properly while import and signing the PDF documents.
  • #269887 – PDF documents will be merged properly in different order.
  • #269711 – PDF document title will be preserved properly with Swedish characters on A1B conversion.
  • #269495 – Form field values will be preserved properly after disabling default appearance.
  • #269472 – ArgumentException no longer occurs when saving the PDF document.
  • #274606 – UriFormatException no longer occurs when converting HTML string to PDF in Linux docker.
  • #272045 – Auto tag will be work properly for PdfPageNumberField, PdfPageCountField, and PdfCompositeField.
  • #269907 – Exception no longer occurs when processing the PdfTemplates in Azure Durable Function.
  • #269961 – PdfGrid with column span and row span will pass the accessibility check on acrobat.
  • #246796 – Special characters will be preserved properly on form flattening.
  • #F152770 – Added support to set the border width to zero for grid cells.
  • PdfLoadedTextBoxField properly will be reflected properly in PDF document.
  • #278918 – The application hanging issue no longer occurs when importing pages from an existing PDF document.
  • #279519 – The text box fields will be removed properly in an existing PDF document.
  • #275636 – The dropdown field value will be preserved properly when flattening it.
  • #273970 – The modified date will be retrieved properly from the input PDF document.
  • #280499, I278376 – Null reference exception will no longer occur when saving a PDF document.
  • #154898 – GDI+ error no longer occurs when adding HTML styled text to the PDF grid.
  • #278376 – Exception no longer occurs when getting an annotation count.
  • #279341 – Bookmarks will be removed properly for a particular PDF document.
  • #278849 – The form fields flatten will be preserved properly in an existing PDF document.
  • #276260 – Signature validation will be working properly when checks twice.
  • #278317 – Bookmarks characters will be preserved properly when saving an existing PDF document.
  • #275413 – Exception no longer occurs when saving a PDF document.
  • #275975, 27597 – Certificate will be retrieved properly in the existing PDF document.
  • #267968 – Exception no longer occurs when retrieving ColorSpace from the existing PDF page.
  • #154858 – Exception no longer occurs when exporting form fields.
  • #277376, 273510 – The preservation issue no longer occurs when flattening form fields.
  • #275975 – The application hanging issue no longer occurs when validating the digital signature.
  • #275940 – Exception no longer occurs in Adobe reader when opening the imported annotation document.
  • #275947 – The NextPage property of the EndPageLayout event will be working properly in the PdfLightTable.
  • #274456 – Text will be preserved properly when setting expansion text to the PDF structure element.
  • #154141 – The preservation issue no longer occurs when drawing PdfGrid using DataSource.
  • #277206 – Images will be rotated properly when converting Word to PDF document.

    Presentation

Features

  • #F149477, #272939 - Provided support to extract the embedded OLE Object data from the PowerPoint presentation.
  • #274076 - Exposed the OfficeChart API to gets the IOfficeChart instance of IPresentationChart.

Bug Fixes

  • #274637 - The PowerPoint presentation will no longer be corrupted while adding a cloned slide within section.
  • #273501 - Row and column span will be applied properly while saving the PowerPoint presentation.
  • #271751 - Table cell border will be applied properly while saving the PowerPoint presentation.
  • #279171 - The ArgumentException will no longer be thrown while opening the PowerPoint presentation with handout master.
  • #280471 - The FormatException will no longer be thrown while opening the PowerPoint presentation with custom geometry path.
  • #278512 - The IndexOutOfRangeException will no longer be thrown while opening the PowerPoint presentation with corrupted picture.
  • #278516 - The RTL text will be preserved properly while converting a PowerPoint Presentation to Image.

XlsIO

Features

  • #79793, #84408, #52130, #127002, #140449, #165919, #187729, #192039, #211086, #192225, #203009, #221785, #231111, #263880 - Read and write XLSB files is now supported.
  • #171164 -Support has been provided for comments in Excel to PDF conversion.
  • #276170 - The Weight property is exposed to get or set chart border width in decimal.
  • #270830 - The RenderBySheet property is exposed to get or set whether the PDF rendering to be done sheet-by-sheet.
  • Exporting Excel data as JSON is now supported.
  • Conversion of HTML tables to Excel worksheets is now supported.

Breaking Changes

  • #79793, #84408, #52130, #127002, #140449, #165919, #187729, #192039, #211086, #192225, #203009, #221785, #231111, #263880 - SaveAsXLSB is added as an enumeration value in ExcelSaveType to save the workbook into XLSB format.
  • #276170 - The Weight property in IChartBorder interface gets or sets the border line weight as number.
  • #278057 - The IsFormula property in IChartDataLabels interface and IChartTextArea interface gets or sets a value indicating whether this instance is a formula.
  • #270830 - The RenderBySheet property in ExcelToPdfConverterSettings class gets or sets a boolean value to indicate whether the PDF rendering to be done sheet-by-sheet or not.
  • #273273 - The Calculate() method of IWorksheet interface is now available in Portable to calculate all the formulas in a worksheet.
  • The ImportHtmlTable(String,Int32,Int32) method in IWorksheet interface and WorksheetImpl class imports HTML table of a HTML file into worksheet from the specified row and column.
  • The ImportHtmlTable(Stream,Int32,Int32) method in IWorksheet interface and WorksheetImpl class imports HTML table of a file stream into worksheet from the specified row and column.
  • The SaveAsJson(String) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file.
  • The SaveAsJson(String,Boolean) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file as schema.
  • The SaveAsJson(String,IRange) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file.
  • The SaveAsJson(String,IRange,Boolean) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file as schema.
  • The SaveAsJson(String,IWorksheet) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file.
  • The SaveAsJson(String,IWorksheet,Boolean) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file as schema.
  • The SaveAsJson(Stream) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file stream.
  • The SaveAsJson(Stream,Boolean) method in IWorkbook interface and WorkbookImpl class saves the workbook to a JSON file stream as schema.
  • The SaveAsJson(Stream,IRange) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file stream.
  • The SaveAsJson(Stream,IRange,Boolean) method in IWorkbook interface and WorkbookImpl class saves the worksheet to a JSON file stream as schema.
  • The SaveAsJson(Stream,IWorksheet) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file stream.
  • The SaveAsJson(Stream,IWorksheet,Boolean) method in IWorkbook interface and WorkbookImpl class saves the range to a JSON file stream as schema.

Bug Fixes

  • #269069, #269181 - Named range index is now updated properly in ArrayFormula while copying two different worksheets.
  • #271034, #276058 - The ImportDataTable() method with preserve type is now working properly for decimal values in German culture.
  • #269362 - Exception will no longer be thrown on applying fill color to group shapes with chart.
  • #273596 - Exception is no longer thrown while opening Excel files with invalid named range.
  • #272551 - Excel file is no longer corrupted on re-saving the document with pivot table.
  • #264179 - Table location and cell values are now updated properly when refreshing a table.
  • #273303 - Exception is no longer thrown while applying borders to specific cells.
  • #267912 - Text in Textbox is now rendered properly in Excel-to-PDF conversion.
  • #267767 - Exception is no longer thrown while parsing Excel documents with chart.
  • #270176 - Exception is no longer thrown while setting invalid HTML string to a cell.
  • #264179 - Tables and its formatting are preserved in proper location after refreshing tables in Microsoft Excel.
  • #272331 - AutoFilter is now applied properly if the row above the filter range is merged.
  • #274309 - Exception is no longer thrown in Excel-to-HTML conversion with entire row merged.
  • #274125 - Timeout exception is no longer thrown while refreshing Excel tables.
  • #269448 - Sorting grand total column in pivot table is now correct.
  • #271999 - Performance is improved on rendering RTF text in Excel-to-PDF conversion.
  • #273303 - Exception is no longer thrown while applying border to specific cells.
  • #276286 - Number Format is no longer missed in whole column while re-saving an Excel file.
  • #274992 - Conditional formatting with relative formula is now applied properly in Excel-to-PDF conversion.
  • #275640 - Import from nested collections with class object is now working proper.
  • #278057 - Exception is no longer thrown while setting conditional formula in non-English cultures.
  • #275498 - Cell text is now proper in PDF when setting formula value using XlsIO.
  • #278259 - Setting a font to individual data label font is now proper.
  • #278644 - Data validation in alternative content is no longer missed in the output document while re-saving.
  • #278469 - Data table formula is now preserved on re-saving an Excel document.
  • #278601 - Column width is now working properly for Unicode text while applying autofit columns in Portable.
  • #F152563 - Performance is improved when data validation is applied to more number of rows and columns.
  • #F153527 - Exception is no longer thrown while creating ListObjects in Excel file that is already saved using XlsIO.
  • #F154230 - Chart title and data label text can now be set with a formula.
  • Issue with pivot table in-line formatting is fixed.
  • Textbox and autoshape fill color is now preserved properly while applying fill color to group shape.