Essential Studio for Windows Forms Release Notes

v17.1.0.38
March 27, 2019

.NET Core 3.0

Our WinForms controls are supported in .NET Core 3.0 preview from this release. A separate set of libraries is provided for .NET Core 3.0 preview to take advantage of the new features.

Calculate

Bug Fixes

  • #F142085 - The IFERROR formula computes properly when value_if_error argument has empty text.
  • #F142085 - Case insensitive SEARCH formula now computes values correctly.
  • #F142085 - The VLOOKUP formula returns calculated value properly when using it as an embedded formula of IFERROR formula.
  • #224844 - The COUNTA($A:$A) formula returns the count of cells correctly in all the rows of the given range.
  • #225672 - The OffSet formula returns the value in Double type correctly.
  • #226573 - The GreaterThanOrEqual operator returns proper value when comparing the strings.
  • #228362 - The 0/0 returns NaN when ExcelLikeComputation is set to false and RethrowLibraryComputationExceptions is set to true.
  • #227194 – Formula which contains the NamedRanges with special characters is now computed properly.
  • #225800 – The SUM formula returns proper error message (#NAME?) when computing invalid NamedRange.

Chart

Bug fixes

  • #224039 - Now, the logarithmic range is calculated properly when there is only one point in the series.

Common

Features

  • The project template, item template, and toolbox supports have been provided for Visual Studio 2019.

Breaking Changes

  • Syncfusion.Shared.Base assembly is added as a dependent assembly for the following controls:

    • SfDataGrid
    • SfListView
    • SfComboBox
    • SfScrollFrame
    • SfButton
    • SfForm
    • SfNumericTextBox
    • SfCalendar
    • SfDateTimeEdit
    • SfSmithChart
    • SfToolTip

DateTimePickerAdv

Bug fixes

  • #226791 – BackColor is not updated properly for UpDown buttons based on mouse hover state in DateTimePickerAdv has been fixed.

Diagram

Features

  • #156632 - Interaction support for label is added.

Bug fixes

  • #225256 – When zooming the diagram, the ruler’s origin now updates properly.
  • #226268 - Drag and drop of nodes and connectors from the symbol palette to the diagram is now working properly.

DocIO

Features

  • #225752 – Provided support to update unknown type fields in a Word document.
  • #224654 – API has been added to set created date and time for Word document comments.
  • #223907 - API has been added to skip the Complex format is not supported exception while opening an incrementally saved DOC format Word document.

Bug Fixes

  • #221972 - Text is now highlighted properly while converting a Word document to tagged PDF.
  • #223350 - Table cell is now preserved properly while opening an HTML document.
  • #222922 - Image is now preserved properly while converting a Word document to PDF.
  • #222713 - The ArgumentException will no longer be thrown while adding a table.
  • #222608 - Font name is now preserved properly while converting an HTML document to Word document.
  • #222751 - The StackOverFlowException will no longer be thrown while converting a Word document to PDF.
  • #222670 - Inline content control text is now preserved properly while converting a Word document to PDF.
  • #222320 - Hyperlink is now preserved properly in inline content control while converting a Word document to PDF.
  • #222345 - The ArgumentOutOfRangeException will no longer be thrown while updating TOC in RTF format document.
  • #221260 - Line space preservation issue has been resolved While converting a Word document to PDF.
  • #221153 - Inline content control custom XML data is now preserved properly while converting a Word document to PDF.
  • #221725 - The ArgumentOutOfRangeException will no longer be thrown while cloning a Word document.
  • #221611 - The NullReferenceException will no longer be thrown while saving a Word document.
  • #220710 - Table row is now preserved properly while converting a Word document to PDF.
  • #220324 - Checkbox content control state is now preserved properly while cloning a Word document.
  • #221119 - List number is now preserved properly while opening an RTF format document.
  • #218943 - List bullet is now preserved properly while opening an RTF format document.
  • #219092 - Merge field before and after text is now preserved properly while executing mail merge.
  • #F141177 - The metafile images are now replaced by default bitmap images while converting a Word document to PDF in Azure platform.
  • #223340 - The IndexOutOfRangeException will no longer be thrown while converting a Word document to PDF.
  • #222852 - Footer content is now preserved properly while merging multiple RTF documents.
  • #223355 - Tab is now preserved properly while converting a cloned Word document to Image.
  • #222588 - Formula field result is now preserved properly while updating the Word document fields.
  • #224323, #225518, #225883 - The NullReferenceException will no longer be thrown while calling the GetText API.
  • #224412 - Tab is now preserved properly while converting a Word document to PDF.
  • #224287 - Image is now preserved properly while converting a Word document to PDF.
  • #223508 - Word document instance is now disposed properly while converting a Word document to PDF.
  • #225386 - Page field is now preserved properly while converting a Word document to PDF.
  • #225611, #225386 - Table content is now preserved properly while converting a Word document to PDF.
  • #218799 - Pagination issue has been resolved while converting a Word document to PDF.
  • #224351, #224561 - Inline content control’s text is now preserved properly while converting a Word document to PDF.
  • #224062, #226901 - Table border is now preserved properly while converting a Word document as RTF.
  • #226599, #226243, #220279 - Table is now preserved properly while converting a Word document to PDF.
  • #226599, #226243, #225970, #225679, #226352, #223713, #223959, #224412, #221455 - Hanging issue has been resolved while converting a Word document to PDF.
  • #226243 - Frame content is now preserved properly while converting a Word document to PDF.
  • #227112 - The NullReferenceException will no longer be thrown while updating the Word document fields.
  • #224637 - Picture preservation issue has been resolved while converting a Word document to PDF.
  • #225091 - Check box is now preserved properly while converting a Word document to PDF.
  • #225458, #223134 - Table row border is now preserved properly while converting a Word document to PDF.
  • #225091 - Underline is now preserved properly while converting a Word document to PDF.
  • #225176 - Image is now preserved properly while converting the RTF document to HTML.
  • #226725 - Embedded Microsoft Visio (VSDX) object is now preserved properly in DOCX to DOCX conversion.
  • #220362 - Picture watermark is now preserved properly while resaving the RTF document.
  • #225947 - Number format is now preserved properly while performing Mail merge.
  • #225062 - Image is now preserved properly while importing a Word document.
  • #218957, #220198 - The ArgumentException will no longer be thrown while converting a Word document to PDF.
  • #225481 - The NotSupportedException will no longer be thrown while opening an HTML document.
  • #225481 - Image size is now preserved properly while opening an HTML document.
  • #225481 - Table border is now preserved properly while opening an HTML document.
  • #218799 – Text format is now preserved properly while converting a Word document to PDF.
  • #218799, #225679 – Text box is now preserved properly while converting a Word document to PDF.
  • #225386 – Table cell is now preserved properly while converting a Word document to PDF.
  • #221089 – Picture watermark is now preserved properly while converting a Word document to PDF.
  • #227058 – Html contains not well formatted table will no longer be thrown while opening an HTML document with caption tag.
  • #223350 – Vertical merged cells are now preserved properly while opening an HTML document.

DockingManager

Bug fixes

  • #224545 – Restore the saved layout will no longer need multiple invocations of LoadDockState in DockingManager.

Features

  • An option has been provided to change the visibility of dock hints at run time based on mouse hovered window in DockingManager.

FontComboBox

Behavior changes

  • Symbol fonts preview will not be displayed in the dropdown, and its name will be displayed in the Arial font. By enabling ShowSymbolFontPreview, preview will be displayed for symbol fonts in the dropdown.

GridControl

Bug fixes

  • #222663 – The cell value is rendered properly with numeric values in a combo box column.
  • #216098 - Selected value is rendered properly when F4 key is pressed in the dropdown cell.
  • #221692 - Now, NotSupportedException throws with the valid message.

GridGroupingControl

Bug fixes

  • #F142118 – The Excel Like Filter in a ComboBox column now filters records properly with DisplayMember and ValueMember.
  • #225405 – The SelectedRecordsChanging event now triggers only once when the ListBoxSelectionMode.One is set and Cancel property of SelectedRecordsChangedEventArgs is set to true in the SelectedRecordsChanging event when selecting a particular record.
  • #221692 - Now, NotSupportedException throws with the valid message.
  • #225585 - DynamicFilter filters with DBNull value when a column has as set format.
  • #224203,#227254 - Record.GetValue returns the value from the underlying data source when FilterMode is set as DisplayText.
  • #225586 - DynamicFilter no longer shows duplicate values in the filter items list when a column has as set format.
  • #226986 - Filter works properly when LessThanOrEqual operator is used for DateTimeColumn.
  • #228711 – Performance is improved for exporting records from grid to Microsoft Excel.
  • #229366 – Now records of corresponding child table group are loaded in filter popup when filtering the records in corresponding child table.
  • #228935 – The Copy/Fill Series now working properly for decimal values.

MaskedEditBox

Bug Fixes

  • #223775 – Slovenian culture (ar-SA) works properly for separator.

MetroForm

Bug Fixes

  • #224815 – Child form blinks when clicking on parent form based on activate state of child form.

MultiColumnTreeView

Bug Fixes

  • #227657 – Now, the edit mode will not be in freeze when scroll down using mouse.

MultiSelectionComboBox

Bug fixes

  • #226692 – The ArgumentOutOfRangeException is no longer thrown while changing the DataSource at runtime.
  • #224249 – The IndexOutOfRangeException is no longer thrown when invoking UnSelectAll method.

PDF

Features

  • #136187 - Added support to create the ZUGFeRD PDF invoice.
  • #135996, #179159, #124105 - Added support to create the PDF/A-2b and PDF/A-3b conformance level document.
  • #222759, #226015 - Added support to import and export a PDF annotation with FDF and XFDF formats.
  • #223208 - Added support to fill both XFA and acroform fields with sample API.
  • Added support to rotate annotations.
  • #220871 - Added support to retrieve the acroform radio button option values.
  • #141170, #222335, #223048 - Added support to retrieve review status and comments from a PDF annotation.
  • #221779 - Added support to update the layout result.
  • #194410, #198765 - Added support to create an ink annotation with ink list collection.
  • #141253 - Added support to create multiple range of page labels.
  • #223924 - Added support to retrieve certificate details from the existing signed PDF.
  • #223970 - Added support to clear the XFA date time field value.
  • #227357 - Added option value support to import and export the radio button field.

Breaking Changes

  • #223629 – Now, by default, EnableMemoryOptimization is set to false when append the PDF files, so close the existing PDF document after saving the new PDF document.
  • Free text annotation call-out line coordinate points are now changed to top to bottom.
  • Annotations are now rotating based on the page rotation in an existing PDF document.

Bug Fixes

  • #223966 - The XFA form fields are now retrieving properly by field name.
  • #224603 - The null reference exception will no longer occur when merging certain PDF documents.
  • #141148 - Tool tip is now preserving properly for PdfSignatureField.
  • #224531 - The null reference exception will no longer occur while saving the merged PDF document.
  • #223013 - The radio button field state is now importing properly from XFDF document.
  • #222779 - Attachment is now opening properly from the merged PDF document.
  • #222425 - The check box form field is now filling properly in PdfLoadedXfaDocument.
  • #222024, #224795 - The null reference exception will no longer occur when saving the PDF document.
  • #221122 - PDF security is now preserving properly when saving the PDF document twice.
  • #217591 - Font is now preserving properly in the flattened PDF document.
  • #221424 - The Brush property of the PdfPen is now initialized through the constructor.
  • #222811 - Line is now rendering properly when converting EMF to PDF document.
  • #222296 - Text is now preserving properly when converting EMF to PDF document.
  • #199783 - Content in EMF is now preserving properly when converted to PDF multiple times.
  • #222410 - EMF is now preserving properly when converting to PDF document.
  • #222516, 224611 - RTL text is now preserving properly when converting a word document to PDF.
  • #221808, #223751 - The “An error exists on this page” exception will no longer occur when converting a word document to PDF.
  • #223650 - The EMF images are now preserving properly when converting presentation to PDF.
  • #222811 - The EMF image is now scaling properly when converting EMF to PDF.
  • #222327 - Hebrew text is now preserving properly when converting XPS to PDF.
  • #219569 - The “Arithmetic overflow exception” will no longer occur while signing the PDF document.
  • #222059 - All hidden layers are now printing properly when saving and loading the PDF document.
  • #221328 - Performance has been improved when saving the uncorrupted PDF document.

  • #227081 – Row span is now applying properly in PdfGrid header.
  • #224992, #225719 – Argument out of range exception will no longer occurs when importing pages from a PDF document.
  • #224584 – PDF document will no longer be corrupted when redacting the PDF document.
  • #227605 – Border width is now retrieving properly from the free text annotation.
  • #227261 – Text is now selectable after processing OCR for the PDF document.
  • #226916 – Documents will no longer be corrupted when creating PDF template from imported PDF document.
  • #226124 - PDF lexer issues are now thrown with PdfException.
  • #227048 - Form fields are now preserving properly while resaving the existing XFA document.
  • #226167 – PDF documents will no longer be corrupted after modifying the PDF document information.
  • #226393 – Form fields are now filling properly when importing XFDF document to fill XFA document.
  • #221393, #221376 – Memory leaks will no longer occurs when converting Word document to PDF.
  • #225910 – The “PathException” will no longer occurs while retrieving custom metadata from an existing PDF document.
  • #222811 – Content is now preserving properly when converting EMF to PDF document.
  • #225853 – Display date format is now preserving properly while filling the PdfLoadedXfaDateTimeField.
  • #225896 – “ArgumentOutOfRangeException” will no longer occurs while importing the PDF document.
  • #222797, #225325 – Vertical alignment of the Thai language text is now preserving properly.
  • #223629 – Performance of the PDF append method is now improved.
  • #224852 – XFA form flatten is now preserving properly in Danish culture.
  • #224583 – Font size is now preserving properly in combo box field.
  • #224603 – Null reference exception will no longer occurs while merging certain PDF documents.
  • #223346 – Images are now preserving properly while encrypting the PDF document.
  • #224531 – Null reference exception will no longer occurs while saving the PDF document.
  • #224269 – Free text annotation’s properties are now retrieving properly.
  • #222297 – Color preservation issues will no longer occur while converting EMF to PDF document.
  • #221805 – Fonts are now embedding properly in conformance enabled PDF document.
  • #141148 – Tool tip is now changing as expected for PdfSignatureField.
  • #219569 – Arithmetic overflow exception will no longer occurs while signing the PDF document.
  • #185722 – PDF document content is now preserving properly after merging the PDF files.
  • #224887 – Added PDF signatures are now valid.
  • #221808, #205098 – Text is now preserving properly while converting Word document to PDF.
  • #225055 – The bounds are now retrieving properly from PdfLoadedTextBoxField.
  • #225055 – RTL text is now preserving properly in PDF form fields.

PdfViewerControl

Bug Fixes

  • #200404, #222505 – AccessViolationException will no longer be thrown when extracting images from the PDF document.
  • #211760 - Images are now extracted properly from the PDF document.
  • #220460, #228148, #228708 – UnauthorizedAccessException will no longer be thrown when loading the PDF documents using the Pdfium rendering engine.
  • #220553 - Text is now extracted properly from the rotated PDF pages.
  • #220725 – Application hanging issue will no longer occur when extracting images from the PDF document.
  • #222407, #227378 - Text is now extracted properly from the PDF document.
  • #223187 – Application hanging issue will no longer occur when compressing the PDF document.
  • #224285 – PDF document will no longer be corrupted after compressing the document.
  • #224584 – Images are now extracted properly from the PDF document.
  • #227505 - TextSelectionCompletedEventArgs now returns the selected text properly.
  • #227863 – The FindText method now finds the text properly from the PDF document.

Features

  • #113788, #114139, #112413, #148562, #163359, #151160, #223943, #223949, #141598 – Added support to magnify PDF documents using CTRL key and mouse wheel where the mouse cursor is pointed to.
  • #223623 – Added support to generate Pdfium assemblies in the custom location instead of default location.
  • #224590, #141808 - Exposed the DocumentUnloaded event to notify the users when the PDF document is unloaded from PDF viewer.
  • Added support for advanced themes in PDF viewer.

PivotGrid

Bug fixes

  • #226038 - Items inside the PivotTable Field List are cleared correctly when resetting the data source.

Presentation

Features

  • #227243 - Support has been added to add the OLE Object into PowerPoint slide as link.

Bug Fixes

  • #224226 - Application will no more hang while adding an image to a PowerPoint slide.
  • #F141608 - Background color is now properly preserved while exporting a PowerPoint slide to EMF with 100% transparency.
  • #225390 - PowerPoint file will no longer get corrupted while resaving multiple times with charts.
  • #222440 - Notes in a PowerPoint slide can now be cloned and added to another slide.
  • #222693 - Hyperlinks in a PowerPoint slide are now embedded into the converted PDF document.
  • #226350 - Scaled images will now render properly in PowerPoint to PDF conversion.
  • #228231 - Application will no more hang while opening the PowerPoint document with empty field tag.

RadialGauge

Features

  • Support has been provided to hide inner ticks and change arc thickness of RadialGauge.

RangeSlider

Features

  • DrawLabel event has been provided to draw the custom label in RangeSlider.
  • Support has been provided to show or hide the ticks and labels in RangeSlider.

RibbonControlAdv

Bug Fixes

  • #225101 – The crash will not occur when selecting an item from MoreCommands.

  • #225101 - ToolStripDropDownButton is displayed properly when using inside ToolStripPanelItem.

  • #224108, 225649, 226357 – Visual Studio will no longer freeze when closing RibbonForm.

  • #222617 – The NullReferenceException will no longer occur when running the application in VS2017.

  • #222307 – When dragging the RibbonForm in high scaling, it will drag smoothly without any delay.

ScheduleControl

Features

  • #222460 - Added support to customize the appointment foreground color.

Bug fixes

  • #F142108 – The appointments are placed at proper time when dragging and dropping the appointments in DayView and WorkWeekView when DivisionsPerHour value is greater than 8.
  • #222707 – The FormatException is not thrown when February-29 day is shown in the month view, and CultureInfo.CurrentCulture has a non-leap year.
  • #222423 – The appropriate action information is returned in the ItemChanging event on clicking an appointment.

SfButton

Bug Fixes

  • #224336, #231347 – Text in the button will not be cropped and will be rendered properly.

SfCalendar

Features

  • An event has been provided to notify when clicking week number or week days cell in SfCalendar.

SfComboBox

Bug fixes

  • #223732 – The ArgumentOutofRangeException is no longer thrown when pressing down the arrow key in AutoCompleteMode.SuggestAppend mode.
  • #224596 – The editor text is now not selected when entering an invalid character in the AutoCompleteMode.SuggestAppend mode.
  • #223089 – The ArgumentException is not thrown when binding the source with the same fields.
  • #226799,#223089 - Dropdown items are populated when binding DataSource that has more than one DataTable.
  • #229227 - The popup container size is updated properly when changing the datasource dynamically.

SfDataGrid

Features

  • #216975, F140374 – Support has been provided for progress bar column type.
  • #F139539 - Support has been provided for preview rows to view the additional information for every row.
  • #224067 – Support has been provided to get DetailsViewDataGrid from the record index and relational column.

Bug Fixes

  • #225767 – Error icon renders properly whenever applying validation for a cell.
  • #227647 – Group caption renders properly when the first column hidden by resizing.
  • #223885 – ArgumentException is no longer thrown when any character is typed on the search text box of ColumnChooser.
  • #225827, #229372 - DataGrid will not lose focus when Tab key is pressed on a combo box column cell in edit mode.
  • #227399 - Ungrouping is now performed in a valid order when ShowBusyIndicator is enabled and multiple columns are grouped.
  • Shift + Click extended selection behavior is working when selecting rows from the first row. The event is triggered when selecting rows above the previously selected row.
  • #223885 - ArgumentOutOfRangeException is no longer thrown randomly when grouping/ungrouping the columns after clearing groups.
  • #F142457 - The DetailsViewPadding property is working properly when padding is set to 0 for all sides.

SfDateTimeEdit

Bug fixes

  • #226519 – The Parent form Key down event is not triggered properly when pressing number keys in SfDateTimeEdit has been fixed.
  • #229160 – The DateTime value was not updated properly when setting the value in the ValueChanged event of SfDateTimeEdit has been fixed.

SfForm

Bug Fixes

  • #225493 – MDI child form will not overlay the parent form when maximizing.
  • #226547 - Form size does not change when opening the form in designer repeatedly.

SfListView

Bug Fixes

  • #226903 – Now, the tooltip will be displayed when HotTracking is set to true.

  • #226784 – The NullReferenceException will no longer be thrown when clicking empty list in Multi Extended mode.

SfNumericTextBox

Bug fixes

  • #229413 - Now, the DisabledForeColor property works properly in SfNumericTextBox.

SfTabbedForm Preview

Tabbed form is used to display tabbed user interface. Users can add any number of tabs and each tab can contain any number of controls.

Key features

  • Easy to navigate through the tabs.
  • Image can be added to the tabs for intuitive user interface.
  • Close the tabs using close button in tab header.
  • Customize the appearance of the tabs.
  • Smooth scrolling behavior even when tabs overflow onto the tab panel.

SfToolTip

Breaking Changes

  • Namespace of the SfToolTip component has been changed to Syncfusion.Windows.Forms. Henceforth, you will need to include the namespace, Syncfusion.Windows.Forms instead of Syncfusion.WinForms.Controls.

SplitContainerAdv

Breaking changes

  • The ThemeChanged event of SplitContainerAdv is modified as ThemeEnabledChanged from this release. ThemeEnabledEventHandler is used to notify the theme changing once ThemesEnabled is set as true in the SplitContainerAdv.

Spreadsheet

Bug Fixes

  • #F141717 – The NullReferenceException is no longer thrown when applying formatting for cells.
  • #F141595 – The NullReferenceException is no longer thrown when importing an Excel file with images in frozen rows.
  • #F142238 - The NullReferenceException is no longer thrown when the menu item is removed from the default context menu.
  • #F142085 - The SUMIFS formula returns proper value when the referred cell value is set to empty string.
  • #F142815 – The ArgumentException is no longer thrown when updating the values dynamically.
  • #F142785 – Copy and paste the values from one Spreadsheet to another Spreadsheet is now working properly.

SyntaxEditor

Bug fixes

  • #227769 – The null reference exception will no longer be thrown when finding the text in SyntaxEditor.
  • #227962 – The MouseClick event is not triggered properly in SyntaxEditor has been fixed.

TabbedMDIManager

Bug fixes

  • #199245 – Selected tab will no longer be changed on resizing the docked window in Docking Manager.

TabControlAdv

Features

  • Support has been provided to show the built-in context menu with Close option in TabControlAdv.

Theme Studio Preview

Introducing Theme Studio, an appearance-oriented tool to customize and prepare new themes based on existing themes. This Syncfusion control’s color codes can be modified dynamically, exported, and referred to in your project with ease.

  • Comes with built-in, Office 2019 Colorful-like theme.
  • Color brushes can change colors for Syncfusion controls.
  • Export option allows you to download modified themes for one or more controls as an assembly.

TrackBarEx

Bug fixes

  • #226596 – TrackBarEx size is not updated properly at run time when setting vertical orientation has been fixed.

TreeNavigator

Bug Fixes

  • #223436 – TreeMenuItem content is positioned properly in 150 scaling.

TreeViewAdv

Bug Fixes

  • #226967 – Now, the nodes will not be duplicated when using virtualization.

  • #225880 – Now, the nodes will be updated properly when enabling virtualization.

  • #223588 – The node selection works properly in multi-selection mode.

  • #223588 – The NullReferenceException will no longer be thrown when trying to edit the node.

  • #223434 – Now, the width of root line is displayed properly in high scaling.

  • #223321 – The issue “ScrollBar appears for the TreeViewAdv when loading in auto hidden window” has been fixed.

  • #209277, 224846, 226159 – The GDI leak in TreeViewAdv when using LoadOnDemand has been fixed.

  • #222405 – TreeViewAdv loads at correct position when using inside PopUpContainer.

  • #209207 – Now, the node goes to edit state on three clicks.

XlsIO

Features

  • #F99670, #185459, #194756, #197860 - Added support for custom table styles in Excel.
  • #128585, #132019, #224861 - Provided support to format unique and duplicate values in conditional formatting.
  • #199594, #199992, #206375, #206374, #209766, #F139259, #218497, #225207 - Provided support for chart to image/PDF conversion in .NET Standard.
  • #222797 - Added support for complex script rendering in Excel to PDF conversion.
  • Provided support for PDF conformance level in Excel to PDF conversion.
  • Added support for Excel 2019 version in XlsIO.

Breaking Changes

  • #F99670, #185459, #194756, #197860 - The TableStyles property is added in IWorkbook interface to get the table styles collection for adding custom table styles.
  • #128585, #132019, #224861 - The Unique and Duplicate types are included in ExcelCFType enumeration to highlight the cells with unique and duplicate values using conditional formatting feature.
  • #199594, #199992, #206375, #206374, #209766, #F139259, #218497, #225207 - Added ExportChartImageOptions property and ConvertToPDF() and ConvertToImage() methods in IXlsIORenderer class and SaveAsImage() method in IChart interface.
  • #222797 - AutoDetectComplexScript has been added in ExcelToPdfConverterSettings class to support complex script rendering in Excel to PDF conversion.
  • Enumeration PdfConformanceLevel is added in ExcelToPdfConverterSettings class to set conformance level in PDF document that is converted from Excel.
  • Type Xlsx is added in ExcelVersion enumeration to represent Excel version 2019 and above.

Bug Fixes

  • #224892 - Unlocked cells are unlocked while moving range from protected worksheet to another worksheet.
  • #226242 - Display text return improper value in French culture issue is resolved.
  • #225272 - Exception is no longer thrown while converting CSV document to PDF with NULL character.
  • #222397, #222732 - Table with query is now preserved properly on invoking Table.Refresh().
  • #223856, #224976 - File will no longer be corrupted while copying a range with multiple list objects.
  • #226454 - The IndexOutOfRange exception will no longer be thrown while converting Excel document into PDF with header and footer.
  • #224770 - Exception will no longer be thrown while exporting worksheet data into data table.
  • #223667 - Exception will no longer be thrown if chart’s data range column is deleted.
  • #225065 - Currency number format is now properly detected in XlsIO generated Excel file.
  • #224023 - Exception thrown while opening an XlsIO re-saved document with group shape has been resolved.
  • #223946 - Conditional format is now preserved properly while saving the workbook multiple times.
  • #223839 - Infinite recursive loop on modifying and saving Excel document with improper chart series indices has been resolved.
  • #224024 - Not implemented exception thrown while opening an Excel document with external formula range in check box has been fixed.
  • #223448 - Pivot table field settings are now preserved properly on resaving the Excel file.
  • #223167 - Custom time format [h]:mm:ss is now detected automatically.
  • #223376 - Exception occurs while saving the Excel document with OLE object has been resolved.
  • #223226 - The NullReferenceException thrown when converting an Excel file to HTML has been fixed.
  • #223041 - Data validation formula is now preserved properly while saving the Excel document as XML.
  • #221229 - Issue with pivot field values due to improper pivot field data format has been resolved.
  • #214445 - Table.Refresh() is now working properly with ODBC connection.
  • #223918 - Conditional format is now preserved properly on converting Excel document to PDF.
  • #223859 - Hyperlink is now set properly in Excel to PDF conversion.
  • #221079 - Exception thrown if print-title row height is higher in Excel to PDF conversion has been fixed.
  • #221693 - The Parameter invalid exception thrown while converting Excel document to PDF has been fixed.
  • #222797 - Incorrect Thai font in Excel to PDF conversion has been fixed.
  • #222156 - Improper number detection with invariant culture has been fixed.
  • #F142414 - Show all item is not enable issue is fixed while resaving the file with pivot table.
  • #F141101 - Issue with incorrect parsing of comments has been resolved.
  • Worksheet LastRow will be properly working when inserting rows beyond used range.
  • Issue with incorrect conditional formatting operator type in resaved Excel document has been fixed.
  • Setting a table column header name will no longer corrupt the Excel document.
  • DataBar color is now applied properly for negative values.
  • External formula is now applied properly in .NET Standard.
  • Shapes rendering issue for curved shapes in Presentation to Image conversion has been fixed.