Essential Studio for Windows Forms Release Notes

v18.1.0.42
April 1, 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 (-).

Bug Fixes

  • #264704 – Selected item position is now updated properly in Carousel

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.
  • #267987 - Now DropDown button appears fine on ComboboxAdv.

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

  • #264411, #269656 - UTF-8 encoded text is now preserved properly while opening an HTML file.
  • #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.
  • #268356, #268510, #266962 - Hanging issue has been resolved while converting a Word document to PDF.
  • #267775 - Shapes are now properly preserved while converting a Word document to PDF.
  • #266244, #268928 - Text is now preserved properly while converting a Word document to PDF.

DockingManager

Bug Fixes

  • #260339 - The Null reference exception will no longer be thrown in DockingManager
  • #263016 - SetOuterDockAbility method is now works in DockingManager.

EditControl

Bug fixes

  • #256483 - Replace dialog position will no longer be changed while entering a text in the search box and press find next.
  • #267994 - EditControl now works perfectly when copying Outlook 365 email content.
  • #268825 - Now, after setting the DefaultNewLineStyle property value, the application works properly when pressing the curly braces before closing.
  • #261454 - Selected context choice item is now placed properly in EditControl when the dot key is pressed.
  • #266792 - Now the ScrollToCaret method is working properly in EditControl.

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.
  • #267890 - Now, when loading a form with Excel 2013 add-In, mouse hovering works properly for caption images.

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.
  • #264579 - The MultiSelectionComboBox now works fine with items added to SelectedItems.
  • #264579 - Now the MultiselectionComboBox selectedItems is correctly updated when the displayed items are removed.

Bug fixes

  • #F144853, #237605 - The Null reference exception will no longer occur when adding NavigationDrawer’s HeaderImage by designer.
  • #152083 - When dragged to the same side of its popup direction, the NavigationDrawer will pop out properly.

Office2007Form

Bug Fixes

  • #264822 - Now, the height of the caption bar is proper with DPI enabled.

Office2010Form

Bug Fixes

  • #264822 - Now, the height of the caption bar is proper with DPI enabled.

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, #266186 – 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.
  • #266732 - NullReferenceException no longer occurs while accessing forms from existing PDF document .
  • #266550 - Exception no longer occurs while flattening the form in particular PDF document.
  • #266819, I266827 - Performance of add layers functionality is optimized.
  • #264801- PDF document no longer corrupted while flattening the PDF document.
  • #268578 - Content will be preserved properly after redact some content in PDF document.
  • #260585 - The Invalid XML format exception no longer occurs while exporting annotations.
  • #267827 - Conformance will be preserved properly after converting PDF document to PDF A1B document.
  • #267847 - Exception no longer occurs while validating signatures in existing PDF document.
  • #260708 - Contents will be removed properly when applying redaction to the existing PDF document.
  • #251733 - Quite zone will be preserved properly in PDF Barcode.
  • #268285 - NullReferenceException no longer occurs while accessing conformance of existing PDF document.
  • #263366 - Argument out of range exception no longer occurs when converting word to PDF.
  • #264827 - Meta data will be preserved properly when using conformance with security.
  • #269391 - Form fields bounds will be retrieved properly from existing PDF document.
  • #268888 - Exception no longer occurs while creating template from particular PDF 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.
  • #I264825 - The hyperlink navigation is now working properly.
  • #I264934 - The System. NullReferenceException will no longer occur when pressing the hyperlink.
  • #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.
  • #F150844 – The text is now extracted with proper font details.
  • #F150844 – The text is now extracted properly from the PDF document.

PivotGrid

Bug fixes

  • #260103 - Exception will no longer occur when filtering after enable the EnableAsyncLoading.
  • #260608 - Provided the BaseField and BaseItem options to pop-up the details of the pivot computation.

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.
  • #266846 - SmartArt color is now preserved properly while replacing the text of SmartArt.
  • #267126 - PowerPoint document is no longer corrupted while removing an animation applied picture.
  • #264428 - GetActualHeight method will return proper table height with longer paragraphs.
  • 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.

RadialMenu

Bug fixes

  • #267896 - The radial menu items which correspond to Wedge count are now properly aligned.

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.
  • #268478 - When adding TrackBarEx to ToolStripTabItem and applying SuperToolTip correctly to other ToolStripItem.

SfButton

Bug fixes

  • #270003 - SfButton’s hover color now works properly in when application has two SfButton controls.
  • #F152377 - Now the text is render properly in SfButton without clipping the last character.

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.
  • #266381,#266384 - Now, the Enter key can be handled properly even when the AddNewRow is in editing. -
  • #F152031 - ArgumentOutOfRangeException will no longer be thrown when adding stacked headers via designer.
  • #F152242 - IndexOutOfRangeException will no longer be thrown when selected row is deleted and new row is added through AddNewRow.
  • SearchController.FindPrevious method now works properly even when AllowFocus is disabled for the search column.

SfDataPager

Bug Fixes

  • #269262 - Office 2016 themes are now properly applied.

SfDateTimeEdit

Bug Fixes

  • #267721 - Left and Right arrow will now update properly when the Application VisualStyleState is NoneEnabled in SfDateTimeEdit.
  • #266266 - DropDown property is now works Properly when it’s value is false in SfDateTimeEdit.

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
    Null reference exception will no longer occur in SfListView when we try to select an item that is not present in list items.

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.
  • #267807 – SfNumericTextBox will now allow to type a negative sign when the value is zero

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.
  • Localization support is given for the spell checker dialog.

TreeViewAdv

Bug fixes

  • #260559 - Node image position now properly arranged in TreeViewAdv at 150 scaling.
  • #254703, #266418 - MultiSelection’s select and unselect functionalities using the shift key are now working fine.

XlsIO

Features

  • #168970, #223685, #254445, #263325 - The in-line formatting in pivot table cell range is now supported.
  • #168970, #223685, #254445, #263325 - Support has been provided for tabular layout and outline layout in pivot table.
  • #263268 - TrimColumnNames option is provided to ignore 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 in-line 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 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 text is wrapped at the right border.
  • #168970, #223685, #254445, #263325 - The ShrinkToFit property IPivotCellFormat interface indicates whether contents are shrunk to fit into the cell.
  • #168970, #223685, #254445, #263325 - The Locked property in IPivotCellFormat interface indicates whether a cell with XF is locked.
  • #168970, #223685, #254445, #263325 - The FormulaHidden property in IPivotCellFormat interface indicates whether 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 conditional format rule.
  • #168970, #223685, #254445, #263325 - The NumberFormat property in IPivotCellFormat interface gets or sets the number format of conditional format rule.
  • #263268 - The TrimColumnNames enumeration value is added to the ExcelExportDataOptions to ignore 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 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 worksheet using the AddCopy() method with ParseOnDemand option.
  • #258536 - Formatting in output file is now proper while copying all 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 re-saving 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 worksheet is fixed.
  • #255781 - Excel file is no longer corrupted when re-saving the document with extension list.
  • #257358 - Issue with applying 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 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 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 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 worksheet to another workbook using the AddCopy() method.
  • #249466 - Page content is no longer cropped on converting Excel document into PDF with custom scaling.
  • #261897 - Memory consumption issue while loading and saving the workbook with large number of data is now resolved.
  • #262745 - Exception is no longer thrown while refreshing the table with updated data source.
  • #263879 - StackOverFlow exception will no longer be thrown while accessing the calculate value with array formula.
  • #264179 - Refreshing a table now properly inserts the header row based on ShowHeaderRow property.
  • #263438 - Sheet views are now preserved properly while saving Excel document.
  • #262548 - Conditional formatting is now applied properly in Excel to PDF conversion.
  • #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.
  • #F150841 - Exception is no longer thrown in Excel to PDF conversion of pivot table with Row fields.
  • 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 re-saving Excel document.
  • Range intersection works properly for 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.
  • Re-saving 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 external connection table.
  • When a cell contains accounting number format, icon set is no longer overlapped on the cell value in Excel to PDF conversion.
  • Formatting of cell ranges are now copied into clipboard using CopyToClipboard() method.
  • SmileyFace shape is now rendered properly in Excel to PDF conversion.
  • Pivot table style is now preserved properly while re-saving Excel document.