Essential Studio for Windows Forms Release Notes

v18.1.0.36
March 19, 2020

AutoComplete

Bug fixes

  • #259850 - Horizontal scrollbars are now properly hidden when the column width value is smaller in the AutoComplete control.

Calculate

Features

  • /#161961, /#1811163, /#258149 - Provided the LINEST formula support in CalcEngine.

Bug Fixes

  • /#263879 - System.StackOverflowException will be no longer thrown when using COUNTIF function with array named ranges.
  • /#259705 – CalcEngine computes the expressions like (.1) , ( .1)” and .1` properly.
  • /#263892 - IFERROR function is computed properly with named ranges.
  • /#259705 - CalcEngine is returns the proper result for the expression like #5 and FIND function with invalid arguments.
  • /#261030 - SUMIF formula is computed properly when criteria contains more than one * character.
  • /#261474 - INTERCEPT function is calculated properly when x and y ranges contains empty cells.
  • /#260584 - COUNTIF formula with embedded formula is calculated properly.
  • /#258525 - CalcEngine returns proper result for the functions with named ranges which starts with negative symbol (-).

ColorPickerUIAdv

Bug fixes

  • #264629 - Recent colors can now added through code in ColorPickerUIAdv.

ComboBoxAdv

Bug fixes

  • #255563 - Now, the ComboBoxAdv control is rendering properly in High DPI.

ContextMenuStripExt

Bug fixes

  • #263933 - The ContextMenuStripEx fore color is now working properly in Office2016 black style.

DateTimePickerAdv

Bug Fixes

  • #263271,263278, 263282- Month name and year selection header will now loaded properly in DateTimePickerAdv.

Diagram

Bug Fixes

  • #260853 – Size Issue with the Print document is now resolved.

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.
  • #F151743 - Resolved the exception while calling the UpdateTableOfContents method in .NET Core 3.0 Linux platform.
  • #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.

EditControl

Bug fixes

  • #256483 - Replace dialog position will no longer be changed while entering a text in the search box and press find next.

GridControl

Features

  • /#257818 - Provided the support to print column headers only on first page alone.

MetroForm

Features

  • #257198 - Support has been provided to retain the caption bar color of the MDI child unchanged when the child is maximized. Now, caption images and caption labels added in the MDI child will be properly retained when the child in maximized.

Bug Fixes

  • #263926 - Now, the CaptionImage.MouseLeave event will be triggered properly when moving the cursor out of form even when the height of caption image and the caption bar of the form are same.

MultiColumnTreeView

Bug fixes

  • #259649 - The GUID values are now correctly updated while selecting nodes in MultiColumnTreeView.

MultiSelectionComboBox

Bug fixes

  • #264579 - The exception will no longer occur when binding array list to MultiSelectionComboBox.

Bug fixes

  • #F144853, #237605 - The Null reference exception will no longer occur when adding NavigationDrawer’s HeaderImage by designer.

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.

PdfViewerControl

Features

  • #I260928 - Provided the support to localize the resource files from different assemblies or namespaces.

Bug Fixes

  • #I256771 - The contents of the PDF document are now rendered properly.
  • #I256786 – The exported images from the particular PDF document are now rendered properly.
  • #I256796 – The vertical scrollbar is now displayed properly when reducing the width of the control.
  • #I256797 - The System.NullReferenceException will no longer occur after disposing the PdfDocumentView.
  • #I257157 – The PDF pages are now printed properly.
  • #I258174 – Memory leak does not occur when extracting text from the PDF document using the PdfViewerControl.
  • #I258131 – The System.ArgumentException will no longer occur when setting the ReferencePath property for Pdfium.
  • #I258131 – The System.DllNotFoundException will no longer occur after renaming the Pdfium folder.
  • #I258131 – The Pdfium assemblies are now extracted properly in the application path.
  • #I258295 – The PDF pages are now rendered properly in lower zoom percentages.
  • #I258295 – The page navigation is now working properly in lower zoom percentages.
  • #I264104 – The ExtractText method will no longer return wrong text.
  • #I264182 – Optimized the page faults when loading a PDF document in the PdfViewerControl.
  • #I260892 – The ExtractText method will no longer return with extra parenthesis in the extracted text.
  • #I260477 – The ErrorOccurred event is now working properly.
  • #I259517 – Memory is now cleared properly after unloading a PDF document from the PdfViewerControl.
  • #I263319 – The rendered contents will no longer overlap in the SfPdf rendering engine.

PivotGrid

Bug fixes

  • #260103 - Exception will no longer occur when filtering after enable the EnableAsyncLoading.

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.

RibbonControlAdv

Bug fixes

  • #262040 - The ToolStripButton and ToolStripSplitButton now renders correctly in RibbonControlAdv when you enable the AutoLayoutToolStrip.
  • #263359, #267231 - The KeyNotFoundException will no longer occur by moving the mouse cursor over the main ribbon after the child Ribbon is closed.
  • #267262 - When the ToolStripEx’s layout property is set to VerticalStackWithOverflow, then the DropDownButton will render properly in High DPI.

SfComboBox

Bug fixes

  • #258279 - Drop-down items text is now rendering correctly when using the images in drop-down list.
  • #259030 - SfComboBox items are not cleared now after clicking the items for three times.
  • #257329 - Token items will now render a text in right to left mode correctly.
  • #258747 - Token items now cleared properly when clearing the selected items from SfCombobox.
  • #261465 - The drop-down button now displayed properly in High DPI.
  • #F151171 - The Localization support for drop-down buttons has been provided.

SfDataGrid

Features

  • #253681, #258664 - Support has been provided to unbound check box selector column to select or deselect the datagrid’s rows.
  • Support has been provided to calculate the summary (table, caption, and group summary) for the selected records.
  • #258268 - Support has been provided to show a title summary and also column summary at the same time (table, caption, and group summaries).
  • #F140261 - Support has been provided to customize the group expander icon in caption summary row. Now, expander cell is rendered in separate renderer.

Bug Fixes

  • #F150910 - Now, when MappingName and PropertyName of the column are case-insensitive, data will not be populated.
  • #F150961 - Cell that matches the searched text is now scrolled to view properly when pressing more time on the FindNext button.
  • #264358 - Serialization exception will no longer be thrown when the CellButtons with Images are serialized in GridButtonColumn.
  • #262418 - Grid paints properly when scrolling upwards using mouse wheel with using QueryRowHeight.
  • #F150853 - ArgumentOutOfRangeException will no longer be thrown when preview row and table summary row are added.
  • #263243 - Hovering color is now applied correctly after clicking on the header cell and retain the hovering.
  • #262634 - Focus maintained properly in grid after selecting an item from the combobox drop-down and pressing Enter key in GridComboBoxColumn.
  • #262634 - Table summary is now updated properly when a value of corresponding columns from unbound column’s expression is changed.
  • #267057 - Now, when placing current cell on the last row of the DetailsView, DataGrid won’t auto-scroll.

SfForm

Bug Fixes

  • Now, when the form is maximized on extended monitor, the form size is proper.
  • #264715 - Theme files are now properly created for form when exporting theme from ThemeStudio application.

SfListView

Bug fixes

  • #263664 - Null reference exception will no longer occur in SfListView when tooltip is enabled for header or footer

Features

  • #253826, 247726 - Support has been provided to scroll and bring an item into view using ScrollInView method.

SfNumericTextBox

Bug fixes

  • #266502 - Value will be now updated properly when comma is set as NumberDecimalSeperator in SfNumericTextBox.

SfSmithChart

Features

  • #253962 - Provided support for customizing legend border, legend item spacing and legend visibility.
  • Added begin and end update method to stop and resume the control’s rendering.

SpellCheckerAdv

Features

  • #256055 - Support has been provided to indicate the SpellCheck is completed in SpellCheckerAdv.

Bug Fixes

  • #256055 - After completed the SpellCheck the Multiple beeps will no more be raised.
  • Dialog will now show text having line break (“\r\n”) escape character.

TreeViewAdv

Bug fixes

  • #260559 - Node image position now properly arranged in TreeViewAdv at 150 scaling.

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.