Essential Studio for WPF Release Notes

v18.1.0.36

March 19, 2020

AutoComplete

Bug fixes

#266217 - AutoComplete SelectedItem is now updated properly based on the entered text

CheckListBox

Features

#257980 - Now CheckedListBoxItem has IsChecked property, you can check or uncheck an item using your ViewModel by binding a property to it.

ColorPickerPalette

Bug fixes

#262694 - Crash no longer happens when ColorPickerPalette is initialized in new thread.

CurrencyTextBox

Bug fixes

#F151486 - Now CurrencyTextBox will reset to zero as pasting the Non numeric text value.

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.

DoubleTextBox

Bug Fixes

#262609 - Negative sign is now updated properly when pasting negative value in DoubleTextBox.

Features

#253478- Value formatting will no more affect value, based on formatting only display text will be updated.

GridControl

Bug Fixes

/#261070 - Grid data is exported properly with cell text orientation to Microsoft Excel.
/#260964 - Frozen rows are selected properly through key navigation from bottom to top direction.

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

#I239562, #I256952 – Provided the support for marquee zoom.
#I261215 - Provided the support to scroll to the horizontal and vertical offsets programmatically.
#I261215 - Provided the support to navigate to the location of the bookmark programmatically.
#I261352 - Provided the support for PageSelected event to obtain selected pages information from organizing pages window.

Bug Fixes

#I256696 - The IsDocumentEdited property is now working properly for page rotation.
#I257485 - The System.ArgumentException will no longer occur when saving the PDF document.
#I257506 – The ErrorOccurred event is now working properly for the particular exception.
#I258019 – Checkbox is now checked and unchecked properly when using the PdfViewerControl in the application.
#I258112 - The ZoomChanged event is now working properly when magnifying the control using mouse wheel.
#I258433 – The contents are now rendered properly with the SfPdf rendering engine.
#I258711 - The System.ArgumentOutOfRangeException will no longer occur after removing a page from the PDF document.
#I258901 - Rotation and deletion of PDF pages are now working properly.
#I258988 – The Scrollbar properties are now working properly in PdfDocumentView.
#I259053 – Author information is now preserved properly when importing and exporting the annotations.
#I264207 – Form fields will now be rendered properly in the particular document.
#I263012 – The System.ArgumentOutOfRangeException will no longer occur when changing the PdfViewerControl visual style.
#I262345 – Text bounds information will now be retrieved properly on the rotated pages.
#I260158 – Print issue will no longer occur on using the SfPdf rendering engine.
#I260613 – The PdfViewerControl will no longer throw null reference exception while using Office 2016 white theme.
#I260203 - The System.ArgumentOutOfRangeException will no longer occur while loading the PDF document in FitPage mode.
The text in the PDF document are now copied properly.

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.

PropertyGrid

Features

Now you can override default navigation to edit value using ShouldPropertyGridTryToHandleKeyDown method.
Provided support to display attached properties of SelectedObject in PropertyGrid.
#F148447 - Provided support to access the property information of a dynamic object when creating CustomEditor.
#I256865 - Provided option to update the value of SelectedObject only after editing is completed.

Behavior Changes:

When double value is edited using built-in DoubleTextBox editor, property of SelectedObject will be changed immediately.

Ribbon

Bug fixes

#259814 - The SplitButton now scrolls properly when inserting items in the DropDownMenuGroup.
#264695 - The RibbonGalleryItem now removes correctly at runtime from RibbonGalleryGroup.
#264694 - The first visible tab is now checked when the code behind another RibbonTab is unchecked.
#263180 - Now, the GalleryItem is specified as the type of button in the Coded UI automation tool.

SfAccordion

Bug fixes

#262058 - SfAccordionItem’s content size is now set properly based on the width defined in the GridColumnDefinition.

SfCircularGauge

Breaking Changes

Offset calculation for range, pointers, ticks, labels has been changed from (1 to 0)(E.g. center to edge) to (0 to 1)((E.g. center to edge). Previously offset 1 is positioned on gauge center. Now offset 0 positioned on gauge center.
MajorTickOffset, MinorTickOffset, TickLength, TickStroke, TickStrokeThickness, SmallTickLength, SmallTickStroke and SmallTickStrokeThickness properties has been deprecated. Use MajorTickSettings and MinorTickSettings class properties to customize the ticks.
RangeOffsetproperty has been deprecated. Use Offset property in CircularRange class.
RangePointerOffset property of CircularScale class has been deprecated. Use Offset property in CircularPointer Class.
PointerCapStroke property has been deprecated. Use KnobStroke and KnobFill property to apply stroke and fill for knob.

Features

Provided tail support for needle pointer.
Provided rounded corner support for range pointer start and end position.
Provided annotation support to add a content over on circular gauge.
Provided inner (start, end), outer (start, end) offset support for range to calculate the range arc thickness in relative position.
Provided rim start and end offset support to calculate the rim arc thickness.
Provided range pointer start and end offset support to calculate the arc thickness.
Provided LabelCreated event support to customize the label text.
Provided Offset support for symbol pointer to arrange in relative position.
Provided ticks start and end offset support to calculate the tick length.
Provided support to customize the visibility of ticks, labels, rim, first label and last label of scale.

SfDataGrid

Bug Fixes

#260529 - Filter is now properly applied by clicking on the SelectAll option in the checkbox filter while Column.ImmediateUpdateColumnFilter is enabled.
#264595 - Scrollbar visual theme style is now applied correctly for second DataGrid when applying theme in xaml designer.

SfDatePicker

Features

ComboBox-based design for a better user experience.
Edit date and time like a text box control.
When field editing is completed, focus will automatically switch to the next field.
Keyboard navigation support.

SfDateSelector

Features

Improved user interface and experience.

SfDiagram

Bug Fixes

#256606 - The diagram will now be exported properly on a fixed dimension using the ImageSize and ImageShrunkproperties of ExportSettings.
#261669 - The rendering speed of the arc segment connector has been improved.
#264308 - Annotation length of the connector is now preserved properly when updating the measurement unit of the page settings.
#262788 - Now, the value to the Command property of DiagramMenuItem can be bind in XAML.
#263489 - Exception will no longer be thrown when exporting the diagram as XPS file stream.
#F151719 - The nodes position is now remains unaltered while reloading the datasource.

Features

Provided the support to populate the collection set of symbols into stencil based on symbol’s category.
Provided the support to draw a connection from the Hit Padding region of Ports.
Provided the option to drag the node in single axis either horizontally or vertically.
The DockPort or Annotation’s location and boundaries with respect to the window can now be identified using the BoundingRectangle property of DockPort or AnnotationEditor.
The Custom shape and style can now be applied to group object using its Shape and ShapeStyle Properties.
The Undo/Redo functionality will now work properly for adding or removing Group objects either through a command or a program.

Behavior Changes

All Children of Groups such as nodes, connectors and nested groups that were basically a diagram element, will now be available in respective diagram’s Nodes, Connectors and Groups collection also.

Breaking Changes

The LayoutBase and TreeLayoutBase classes that were under the namespace Syncfusion.UI.Xaml.Diagram.Layout.Base was changed to Syncfusion.UI.Xaml.Diagram.Layout.

SfImageEditor

Features

#148752 - Support to specify file name for the saving image.
Provided CustomView support to add a view on image with different customization such as resize, rotation etc.

SfKanban

Features

We have enhanced the performance when modifying the data dynamically.

SfMaps

Features

#25198 - Support to get maps tile layer bounds.
#256387,#151014 - Support to calculate zoom level based on map Geo-bounds (Northeast, Southwest) or distance (KM/miles) from the Geo-point center value
Provided tooltip support for maps shapes, markers and bubbles.
Method provided to get the Geo point from screen point and wise versa.

SfRichTextBoxAdv

Features

#263370 - Added IsUndoEnabled property in EditorSettings class to enable or disable the undo support for the RichTextBox control.
#263370 - Added CanUndoStyle property in EditorSettings class to enable or disable the undo support for the style in the RichTextBox control.
#263651 - Added shading support for the text inline elements in the RichTextBox control
#F150539 - Added option to change font families in the RichTextBox control.

Bug Fixes

#260204 - Null reference exception will no longer be thrown while drag and drop the image.
#260419 - Undo operation is now working properly for the formatting changes.
#255613 - All the references of a style in the document are now cleared properly while removing a style.
#262694 - Calling thread cannot access this object exception will be no longer thrown while opening document using asynchronous open method.
#F151513 - Document footer is now visible properly while setting new HeaderFooter instance.
#F151168 - Programmatically created bullet lists are now serialized properly in the exported documents.
#F150998 - The white spaces will be no longer added between two spans while importing HTML.
#F151304 - Blinking cursor is now invisible when the focus is moved outside the application window.

SfSchedule

Bug Fixes

/#F151462 - Now the mapped object of an recurrence appointment is returned when dragging or resizing that appointment when binding collection of custom objects in SfSchedule.

SfSpreadsheet

Bug Fixes

/#252000 - System.ArgumentOutOfRangeException will be no longer thrown when clicking on RichTextBox cells.

SfTextBoxExt

Features

The following features have been provided for the SfTextBoxExt control:

Token support has been provided to display the selected items with a customizable token representation.
SelectedValue and ValueMemberPath support has been provided for the users to retrieve the selected value from the suggestion list.
ImageMemberPath support has been provided for the users to set the path for the Image to be displayed in the Text Box control.
NoResultsFoundTemplate support has been provided for the users to display a text indicating there is no search results found.
EnableAutoSize support has been provided for the control to grow in size when the additional tokens are added behind the view.
DropDownIcon support has been provided to set the drop down icon for the Text Box control.

Breaking Changes

SelectedIndex will now be updated based on the DataSource.
SuggestionMode additional properties have been included.
MultiSelectMode set as Delimiter will now work without setting the symbol.

SfTimePicker

Features

ComboBox-based design for a better user experience.
Edit date and time like a text box control.
When field editing is completed, focus will automatically switch to the next field.
Keyboard navigation support.

SfTimeSelector

Features

Improved user interface and experience.

SkinManager

Bug fixes

#261075 - When ApplyStylesOnApplication is enabled, memory consumption reduced when switching to SfSkinManager themes.

TabControlExt

Bug Fixes

#267488 - Tab items will never loaded when right click on active tab in TabControlExt.

Theme Studio

Features

New material light and dark themes have been implemented for both framework and Syncfusion controls.

Breaking changes

Older themes such as Office 2016, Office 2013, Office 2010, Visual Studio, Blend, Metro, Lime and Saffron have been removed from the theme studio alone. But we still ship these theme libraries in our Essential Studio suite.

TreeViewAdv

Bug fixes

#263435 - The NullReferenceException will no longer occur when drag from the ListBox to TreeViewAdv.
#260736 - Now, the TreeViewAdv control is editable properly with template.

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.