Essential Studio for ASP.NET Release Notes

v18.1.0.36

March 19, 2020

DocIO

Features

#17555, #123036, #130235, #F117690, #135953, #136014, #136677, #139383, #140946, #143065, #150226, #157199, #162767, #162891, #168515, #168983, #171073, #178572, #179473, #183440, #188778, #189881, #190783, #191732, #182319, #198068, #189881, #202966, #217393, #230817, #238068 - Automatically resizes the table to fit its content in DOCX to PDF conversion.
#260100, #F151648 - Provided support to replaces the fields with its most recent result as normal text in the generated Word document.
#F94716, #199229, #201461, #202031, #F137353, #210718, #231958, #234040, #256120, #256942 - Provided support to get the string that represent the appearance of the list value of the paragraph.

Bug Fixes

#249887, #257815 - The extra paragraph is now removed properly when replacing bookmark content by using the ReplaceBookmarkContent() method.
#257956 - The ArgumentOutOfRangeException will no longer be thrown while cloning picture in the Word document.
#257974 - Picture is now preserved properly when open and save the DOCX Word document.
#257472 - IF field is updated properly while calling updateDocumentFields() method.
#256459 - Frame is now preserved properly when open and save the DOCX Word document.
#255071 - Outline level for built-in heading styles are preserved properly while resaving the Word document.
#F142273 - The NullReferenceException will no longer be thrown while deleting bookmark content by using the DeleteBookmarkContent() method.
#255497 - Group shapes will be preserved properly when open and save the DOCX Word document.
#260062 - The NullReferenceException will no longer be thrown while calling the GetText() method.
#258741 - NumPages field is updated properly when using updateDocumentFields in the Word document.
#258487 - Content control of type repeating section will be preserved properly when converting the Word document to PDF.
#252217, #267241 - Shape is now preserved properly when converting the Word document to PDF.
#257671 - Nested group shapes are now preserved properly when open and save the DOCX format Word document.
#257373 - Table is now preserved properly when converting the Word document to PDF.
#257135 - Track changes are now accepted properly while using the AcceptChanges() method.
#255497 - Text spaces are now preserved properly when open and save the DOCX Word document.
#256481 - The NullReferenceException will no longer be thrown when converting a Word document to PDF.
#F145154 - Bookmark is now preserved properly while removing table column in the Word document.
#F144828 - The NullReferenceException will no longer be thrown while replacing bookmark content by using the ReplaceBookmarkContent() method.
#257975 - Text box is now aligned properly while converting a Word document to PDF.
#256459, #256303 - Improved the stability of Word to tagged PDF conversion.
#199319 - Improved the stability by resolving a possible NullReferenceException occurred in Word to PDF conversion.
#258741 - Page field is updated properly while updating fields from RTF document.
#258247 - Hyperlink is now preserved properly while converting a Word document to PDF.
#256602, #255237 - Text box is now preserved properly while converting a Word document to PDF.
#255040, #F149824 - Picture is now preserved properly while converting a Word document to PDF.
#257983, #256602 - Hanging issue has been resolved while converting a Word document to PDF.
#257373 - Text is now aligned properly while converting a Word document to PDF.
#252217 - Tab is now preserved properly in the generated PDF.
#256836 - Image is now preserved properly while converting a Word document to Image.
#256459 - Frame is now preserved properly while converting a Word document to PDF.
#255462 - Header is now preserved properly while converting a Word document to PDF.
#255071 - The IndexOutOfRangeException will no longer be thrown while converting a Word document to PDF.
#256504, #258239 - The NullReferenceException will no longer be thrown while converting a Word document to PDF.
#264648, #263238 - The NullReferenceException will no longer be thrown while performing mail merge in a Word document.
#263524 - Contents are now preserved properly while converting a Word document to PDF.
#264646 - The ObjectReferenceException will no longer be thrown while cloning a Word document.
#264058 - Hanging issue has been resolved while updating document fields.
#263332, #F150503 - Cell width value is now retrieved properly while opening a DOC format document.
#263217 - Table is now preserved properly while converting a Word document to PDF.
#263179 - Font size is now preserved properly while cloning and adding into a destination Word document.
#263210 - The KeyNotFoundException will no longer thrown while opening a Word document.
#262446 - Table Left Indent value is now preserved properly while opening a DOCX format Word document.
#261531 - Text is now aligned properly while converting a Word document to PDF.
#257135, #263808 - Table is now preserved properly while opening a DOCX format Word document.
#F143774 - Empty paragraphs are now preserved properly while performing vertical cell merge by using ApplyVerticalMerge() method.
#F150653 - Number format is now preserved properly while performing Mail merge process.
#260712 - Cell shading color will be preserved properly when converting DOCX to RTF format document.
#260119 - Table is now preserved properly while resaving the Word document.
#255040 - Image in the document will be preserved properly in Word to PDF conversion.
#127027, #242442 - Paragraph style is now preserved properly while replacing the paragraph text in the Word document.
#212632 - Improved the “KeepWithNext” property-based rendering algorithm in Word to PDF conversion.
#266186 - Provided an API to regenerate the nested metafile images present in the Word document during PDF conversion.
#264589 - Pages are now preserved properly while converting a Word document to PDF.
#263809, #263739, #266244 - Text is now preserved properly while converting a Word document to PDF.
#263739 - Table contents are now properly preserved while converting a Word document to PDF.
#263739 - Endnote is now preserved properly while converting a Word document to PDF.
#263185 - Hanging issue has been resolved while converting a Word document to PDF
#261938 - RTL text is now preserved properly while converting a Word document to PDF.
#261246 - Shapes are now properly preserved while converting a Word document to PDF.
#262446 - Table is now preserved properly while converting a Word document to PDF.
#261332 - Image is now preserved properly while converting a Word document to PDF.
#261034 - Text is now preserved properly while converting a Word document to Image.
#259765 - The NullReferenceException will no longer be thrown while converting a Word document to PDF.
#257373 - Text is now aligned properly while converting a Word document to PDF.
#255237, #264034 - Textbox is now preserved properly while converting a Word document to PDF.
#208452 - Table content is now preserved properly while converting a Word document to PDF.
#258487 - Picture content control is now preserved properly while resaving a DOCX format Word document.
#263808 - Track changes are now preserved properly while converting a Word document to PDF.
PDF

Features

#259629 – Added support for import/export XFA form data in PdfLoadedXfaForm.
#263279 – Added support to find extended features in an existing PDF document.
#263249 – Added support for converting authenticated web sites to PDF through the authenticated proxy server.
Added support for dash and dot line styles for line and line measurement annotations.

Bug Fixes

#266221 – The NullReferenceException no longer occurs while accessing URL form loaded annotation.
#263369 – The NullReferenceException no longer occurs while setting read only to form fields.
#262090 – The NullReferenceException on longer occurs while getting ForeBrush of PdfLoadedTextBoxField.
#263889 – A PDF document is no longer corrupted while adding the PdfHeader and PdfFooter.
#264777 – The NullReferenceException no longer occurs while importing pages from the PdfLoadedDocument.
#263914 – Form fields will be preserved properly while resaving an existing PDF document.
#263649 – Tab “\t” characters will be preserved properly in QRBarcode.
#263741 – Remove attachment will be working properly while saving a document in the same stream.
#263101 – 3D annotation with PRC files will be preserved properly in Bluebeam viewer.
#260708 – The NullReferenceException no longer occurs with redaction.
#263304 – The NullReferenceException no longer occurs while saving the PDF document.
#263091 – Transparent color will be preserved properly while drawing an image to PDF document.
#261878 – ZUGFERD conformance will be validated properly while adding external attachments.
#262087 – Exception no longer occurs while validating a PDF document that contains multiple signatures.
#262622 – Exception no longer occurs while loading a particular PDF document.
#261878 – Conformance verification will be passed for the PDF to PDF A1B converted documents.
#262133 – Exception no longer occurs while getting certificate from the store using Serial ID.
#251733 – PdfCodeUPCBarcode will be preserved properly while drawing it to PDF page.
#261206 – PdfGrid will be preserved properly with multiple nested grids.
#260536 – The NullReferenceException no longer occurs while getting author of PdfLoadedAnnotation.
#260893 – XPS to PDF conversion no longer generates PDF document without images from XPS document.
#257531 – Layers will be removed properly for merged PDF documents.
#257531 – The remove layer functionality performance has been optimized.
#257210, I266186 – Meta file will be preserved properly in Word to PDF conversion.
#260585 – The Invalid XML format exception no longer occurs while exporting annotations.
#256286 – Document no longer corrupted while adding an Image to PDF document.
#261841 – Text will be preserved properly with proper spacing in a PDF document.
#262644 – The NullReferenceException no longer occurs while flattening a PDF document.
#198270 – Text will be preserved properly while converting XPS to PDF.
#257443 – PDF page size will be preserved properly when appending two documents with different page size.
#256504 – Word to PDF conversion will be working properly with particular document.
#257413 – The NullReferenceException no longer occurs while enabling LTV for store certificates.
#257673 – The FileNotFoundException no longer occurs with XmlSerializer on XPS to PDF conversion.
#259787 – PdfAnnotation will be flattened with proper borders.
#259394 – PdfInkAnnotation will be flattened properly.
#256196 – The OutOfMemoryException no longer occurs while saving a large PDF document.
#256196 – Performance of remove layer functionality is optimized now.
#257531 – Layers will be removed properly in PDF documents.
#136014 – Paragraph inside the table cell will be preserved properly in Word to PDF conversion.
#257210, #257811 – Meta file (EMF) will be rendered properly in PdfDocument.
#255677, #257428 – EMF files will be rendered properly in PdfDocument on .NET Core 3.0.
#260424 – The NullReferenceException no longer occurs while saving a PDF document multiple times.
#252711 – Image will be preserved properly while drawing it to PDF document.
#255550 – The EndOfStreamException no longer occurs while drawing image to PDF document.
#260117 – PdfUriAnnotation will be preserved properly with provided string format in PdfGrid.
#251733 – PdfCodeUPCBarcode will be preserved properly with provided dimension.
#258668 – PDF to PDF A1B converted document will be opened properly in PDF readers without any issue.
#257221 – PdfTextBoxField will be preserved properly with AutoFontSize and Multiline options.
#256614 – BackColor will be preserved properly in PDF 2D barcodes.
#255136 – The DateTimeInvalidLocalFormat exception no longer occurs when creating a PDF A document.
#F144285 – PdfSignature appearance will be preserved properly based on the page rotation.
Exception no longer occurs while removing bookmarks from the PDF document.
Import from JSON file will now preserve the values properly.
Exception no longer occurs when saving a document multiple times.
The color properties will be preserved properly in PdfFreeTextAnnotation.
Presentation

Features

#248770, #175287 - Added support for header and footers in PowerPoint slides.
#234509, #249450 - Added a support to preserve the picture in PPTX to image and PDF conversion, that is cropped with preset shapes.

Bug Fixes

#257963 - The NullReferenceException will no longer be thrown while cloning a PowerPoint slide with hyperlink.
#264098 - The NullReferenceException will no longer be thrown while opening a PowerPoint document without a chart relation.
#263842 – PowerPoint to PDF conversion will be performed properly in 150% machine resolution.
#266570 – Table cell margins are now preserved properly while resaving the PowerPoint document.
The ArgumentException will no longer be thrown while setting an invalid link or path as hyperlink.
The TransitionEffect.None will be applied properly for the PowerPoint slide.
XlsIO

Features

#168970, #223685, #254445, #263325 - The inline formatting in pivot table cell range is now supported.
#168970, #223685, #254445, #263325 - Support has been provide for the tabular layout and outline layout in pivot table.
#263268 - TrimColumnNames option is provided to ignore the leading and trailing spaces with accounting format in export to data table.
Default font size is now set properly in shapes.

Breaking Changes

#168970, #223685, #254445, #263325 - The IPivotCellFormat interface, PivotCellFormat and PivotCellFormatWrapper classes are added to support inline formatting.
#168970, #223685, #254445, #263325 - The GetCellFormat() method in IPivotCellFormat interface gets the pivot cell format for a given range.
#168970, #223685, #254445, #263325 - The BackColor, PatternColor, FontColor, TopBorderColor, BottomBorderColor, RightBorderColor, LeftBorderColor, and DiagonalBorderColor properties in IPivotCellFormat interface gets or sets the background color, pattern background color, font color, top border color, bottom border color, right border color, left border color, and diagonal border color respectively from predefined colors.
#168970, #223685, #254445, #263325 - The BackColorRGB, PatternColorRGB, FontColorRGB, TopBorderColorRGB, BottomBorderColorRGB, RightBorderColorRGB, LeftBorderColorRGB, and DiagonalBorderColorRGB properties in IPivotCellFormat interface gets or sets the background color, pattern background color, font color, top border color, bottom border color, right border color, left border color, and diagonal border color respectively.
#168970, #223685, #254445, #263325 - The TopBorderStyle, BottomBorderStyle, RightBorderStyle, LeftBorderStyle, and DiagonalBorderStyle properties in IPivotCellFormat interface gets or sets the line style of top, bottom, right, left, and diagonal borders respectively.
#168970, #223685, #254445, #263325 - The Bold property in IPivotCellFormat interface specifies whether a bold text is present.
#168970, #223685, #254445, #263325 - The Italic property in IPivotCellFormat interface specifies whether Italic text is present.
#168970, #223685, #254445, #263325 - The IsStrikeThrough property in IPivotCellFormat interface specifies whether strike through is present.
#168970, #223685, #254445, #263325 - The PatternStyle property in IPivotCellFormat interface gets or sets the fill pattern style.
#168970, #223685, #254445, #263325 - The Underline property in IPivotCellFormat interface gets or sets the underline type for the conditional format.
#168970, #223685, #254445, #263325 - The HorizontalAlignment property is added to the IPivotCellFormat interface to represent the horizontal alignment.
#168970, #223685, #254445, #263325 - The VerticalAlignment property is added to the IPivotCellFormat interface to represent the vertical alignment.
#168970, #223685, #254445, #263325 - The IndentLevel property is added to the IPivotCellFormat interface to represent the indent level.
#168970, #223685, #254445, #263325 - The ReadingOrder property is added to the IPivotCellFormat interface to represent the text direction and the reading order for far east versions.
#168970, #223685, #254445, #263325 - The WrapText property in IPivotCellFormat interface indicates whether the text is wrapped at the right border.
#168970, #223685, #254445, #263325 - The ShrinkToFit property IPivotCellFormat interface indicates whether the contents are shrunk to fit into the cell.
#168970, #223685, #254445, #263325 - The Locked property in IPivotCellFormat interface indicates whether a cell with the XF is locked.
#168970, #223685, #254445, #263325 - The FormulaHidden property in IPivotCellFormat interface indicates whether the formula is hidden.
#168970, #223685, #254445, #263325 - The Rotation property is added to the IPivotCellFormat interface to represent the text rotation angle.
#168970, #223685, #254445, #263325 - The NumberFormatIndex property in IPivotCellFormat interface gets or sets the number format index of the conditional format rule.
#168970, #223685, #254445, #263325 - The NumberFormat property in IPivotCellFormat interface gets or sets the number format of the conditional format rule.
#263268 - The TrimColumnNames enum value is added to the ExcelExportDataOptions to ignore the leading and trailing spaces with accounting format in export to data table.

Bug Fixes

#250513, #261295 - Performance of opening the XLS file with comments is improved.
#255791 - CJK characters are now rendered properly in Excel to PDF conversion.
#257403 - Cells in the Excel output are properly formatted when importing plain old CLR object with nullable fields.
#255064 - Performance is improved for refreshing the query table.
#256142 - Shapes are positioned properly after hiding the rows.
#250406 - Exception will no longer be thrown on parsing the named range.
#250406 - Exception will no longer be thrown on parsing the chart series text.
#245527 - Accounting format is now set properly for the cell when number is set to 0.0.
#257296 - Creating a chart with double values in German culture no longer gives corrupted output.
#257771 - Conditional formatting formula is now set properly for XLSX versions.
#257476 - Exception is no longer raised while opening an Excel document with large number of rows and columns.
#257356 - Exception is no longer thrown while copying the worksheet using the AddCopy() method with ParseOnDemand option.
#258536 - Formatting in output file is now proper while copying all the worksheets to another workbook using the AddCopy() method.
#258419 - Page break is now correct when page setup has FitToPage in Excel to PDF conversion.
#255317 - RTF alignment is now proper in text boxes.
#249446 - Page content is no longer cropped while converting an Excel document into PDF with custom scaling.
#259825 - Table style options are now preserved properly while resaving the Excel document.
#258600 – XlsIO generated HTML files are now showing properly in Microsoft Edge browser.
#252205 - Column width is now preserved properly in Excel to PDF conversion.
#258534 – Excel file will no longer hang on parsing the conditional formats.
#258419 - Borders are now preserved properly in Excel to PDF conversion when different line styles are applied in the same cell.
#258722 - The issue with Font size that is getting changed while copying the worksheet is fixed.
#255781 - Excel file is no longer corrupted when resaving the document with extension list.
#257358 - Issue with applying the tabular row layout to pivot fields layout is fixed.
#260561 - Refer to range no longer throws exception after getting the display text.
#258419 - Custom scaling is now proper in Excel to PDF conversion.
#259026 - Excel files containing the pivot table gives proper values in the converted PDF.
#261861 - Login failed exception is no longer thrown on refreshing the list object.
#263640 - Additional characters are no longer trimmed on setting the cell text with more than 32767 characters.
#263354 - Chart legend entries are no longer aligned to the left of the legend element in chart to image conversion.
#263198 - Italian text in the input pivot table is no longer changed to English during Excel to PDF conversion.
#262501 - Exception is no longer thrown while copying the worksheet using the AddCopy() method.
#261038 - Formats are no longer removed when inserting a row above the formatted cell.
#263254 - Chart series cache will now be serialized only when IsChartCacheEnabled is true.
#263438 - Sheet views are now preserved properly while saving the Excel document.
#264163 - Fonts in comment shape is now preserved properly while copying a range from one worksheet to the other.
#264154 - Name index is now properly referred in array formula while copying the worksheet to another workbook using the AddCopy() method.
#249466 - Page content is no longer cropped on converting the Excel document into PDF with custom scaling.
#F149527 - Conditional format is now preserved properly in the newly added worksheet when saving the workbook twice.
#F149617 - Vertical page break for Arial font is now correct in Excel to PDF conversion.
Issue with incorrect cell value in Excel to PDF conversion is fixed.
Starting page number is now correct in Excel to PDF conversion.
Split text starting position is now correct in Excel to PDF conversion.
AutoShape border is rendered properly in Excel to PDF conversion.
Shape text is now proper in Excel to PDF conversion.
Conditional format icon for discontinuous ranges is now proper in Excel to PDF conversion.
White font color for cells is now applied properly in Excel to PDF conversion.
Text box fill and border colors are now preserved properly while resaving the Excel document.
Range intersection works properly for the entire row and column.
Conditional format icon is now proper for negative cell values in Excel to PDF conversion.
CF number format is properly applied in Excel to PDF conversion.
Strike through is properly applied for header in Excel to PDF conversion.
Excel file having conditional format with negative priority is now properly converted to PDF.
Shrink to fit is now working for numbers in Excel to PDF conversion.
Exception is no longer thrown while accessing a range that contains multiple cell references.
The CopyTo() method is now working properly for the range that contains merged cells.
Resaving the zip no longer throws exception.
The DateTime format is now working fine in Excel to PDF conversion.
Number format is now working fine for Sinhala Unicode.
Arabic Unicode texts are now rendered properly with number formats in Excel to PDF conversion.
Image background color is now rendered properly in Excel to PDF conversion.
Exception will no longer be thrown while refreshing the external connection table.
When the cell contains accounting number format, icon set is no longer overlapped on cell value in Excel to PDF conversion.

Essential Studio for ASP.NET Release Notes

DocIO

Features

Bug Fixes

PDF

Features

Bug Fixes

Presentation

Features

Bug Fixes

XlsIO

Features

Breaking Changes

Bug Fixes