Essential Studio for Windows Forms Release Notes (Beta)

v17.2.0.28
June 27, 2019

Calculate

Bug fixes

  • #235569 - IF formula returns correct value for (0/0) when enabling the AllowShortCircuitIFs.
  • #230937 - IF formula returns correct result in an array structure when the cell range contains Sheet Token.
  • #231382, #236708 - Correct results returned while calculating logical operators while compare two cells contain zero and empty.
  • #231382 - Correct results are returned while logical operators compare two cells contains zero.
  • #232043, #236708 - Correct results are returned while operators compare two cells contain zero and format ad Text.
  • #233394 - Fixed the issue in calculating MID formula when start number is first position.
  • #230937 - Fixed the issue in calculating multiple OFFSET formula when compute print area.
  • #233394 - Fixed the issue while calculating WEEKNUM formula when the argument contains DateTime value.
  • #233796 - Returns #REF! while calculating index formula when row number starts with Sheet Token has been fixed.
  • #231382 - SUMIF formula calculates correctly when Range and sum range length differs.
  • #231382 - SUMIF formula is calculated correctly when using incorrect NamedRange.

Chart

Fix

  • #234397 - The issue with setting “None” value to “ChartSymbolShape” has been fixed.

  • #I237224 - The issue in “PointsToolTipFormat” API of the chart control’s series has been fixed.

ColorPickerButton

Features

  • Accessibility support has been provided to ColorPickerButton.

ColorPickerUIAdv

Features

  • Accessibility support has been provided to ColorPickerUIAdv.

ColorUIControl

Features

  • Accessibility support has been provided to ColorUIControl.

ComboBoxAdv

Bug fixes

  • #232125 - Corrected the spell error in API’s description.
  • #236542 - SelectedIndexChanged event will not be triggered when modify the binding source.

Common

Some of our API name has been renamed to improve API standard. It has been described below.

</td> </td> </table> ## DateTimePickerAdv ### Bug fixes * \#236217 - The value of today is now set properly in the DateTimePickerAdv control. * \#237272 - Now, the date is validated after editing has been completed in DateTimePickerAdv. ## Diagram ### Features * \#231688 - Support has been provided to show the Ruler label measurement unit and zooming value of Diagram. ### Bug fixes * \#142513 - The issue with performance that occurs when drag a group of nodes has been resolved. * \#230093 - The exception thrown when deserializing nodes alone from the diagram is now working properly. * \#231028 - The `InheritContainerMeasureUnits` property of the Ruler and Node now works properly. ## DocIO ### Features {:#DocIO-features} * \#227695, \#144419, \#129497, \#F136030, \#118915 – Added group shapes support in DOCX to PDF conversion. * \#227388 - New event has been added to customize clearing each unmerged merge fields during Mail merge. * \#208057 - Added support for warnings to show unmatched merge fields and groups during Mail merge. * \#209444 - API has been added to access the new instance (WPicture or WTextRange) to be replaced in Mail merge event arguments. * \#208534 - API has been added to update the Word document fields while converting a Word document to PDF. * \#222516 - RTL text rendering algorithm has been improved in Word to PDF conversion. ### Bug Fixes {:#DocIO-bug-fixes} * \#233421 - Empty paragraph preservation issue has been resolved while replacing text with table. * \#232599 - The **ArgumentOutOfRangeException** will no longer be thrown while opening an RTF format document. * \#231722 - HTML end tag is now preserved properly while converting a Word document to HTML format document. * \#231594 - Dropdown form field is now preserved properly while converting an HTML to RTF format document.     * \#225752,\#230460,\#230460 - Line space preservation issue has been resolved when updating the Word document fields. * \#F142931 - The DocProperty value is now preserved properly while converting a Word document as PDF.     * \#219214,\#228161 - Merge field is now properly updated while executing Nested Mail merge. * \#233913 - Right to left text is now preserved properly in DOCX to DOCX conversion. * \#232775 - Header and Footer contents are now preserved properly in XML to DOCX format conversion. * \#232718 - The Content control text is now preserved properly in DOCX to Text format conversion. * \#F143772 - Nested bookmark is now preserved properly while opening a DOC format Word document. * \#F143774 - Table cell contents are now preserved properly while applying horizontal merge to the table. * \#232505 - Font is now preserved properly while converting a Word document to PDF. * \#232502 - Content is now preserved properly while converting an RTF to HTML format conversion. * \#232265 - Spacing issue has been resolved while converting an HTML to DOCX format document. * \#231592 - TOC content is now preserved properly while updating table of content in Word document. * \#231721 - The **NullReferenceException** will no longer be thrown while converting a Word document to PDF. * \#226490 - Corruption issue has been resolved while saving the DOCX format Word document. * \#F143006 - Text is now preserved properly while replacing the bookmark content in DOC format document. * \#228442 - Table alignment is now cloned properly while cloning the Word document. * \#228370 - Table styles are now preserved properly while converting an HTML to DOCX format document. * \#226490 - Corruption issue has been resolved while saving the DOC format Word document. * \#230678, \#228611 - The **NullReferenceException** will no longer be thrown while converting a Word document to PDF. * \#229685 - Table border is now preserved properly while converting a Word document to PDF. * \#229738 - Text is now preserved properly while converting a Word document to PDF. * \#231056 - Border is now preserved properly while converting a Word document to PDF. * \#231712 – The **NullReferenceException** will be no longer thrown while updating fields in the Word document. * \#231056 - Text overlapping issue has been resolved while converting a Word document to PDF. * \#F142888, \#229094 - Table cell borders are now preserved properly while converting a Word document to PDF. * \#228272 - Table border is now preserved properly while converting an RTF format document to PDF. * \#227754 - Multiple TOC page numbers are updated properly while calling the UpdateTableOfContents method. * \#231550 - Performance has been improved while converting a Word document to PDF. * \#231426 - Hanging issue has been resolved while converting a Word document to PDF. * \#229685 - Font is now embedded properly while converting a Word document to PDF. * \#229891 - Hanging issue has been resolved while converting a Word document to PDF. * \#228974 - Ref field result is now preserved properly while updating the Word document fields. * \#228974 - Unknown field result is now preserved properly while updating the Word document fields. * \#228968 - Hanging issue has been resolved while updating the Word document fields. * \#231751 - Space is now preserved properly while converting a Word document to PDF. * \#227429 - Border is now preserved properly while converting a Word document to PDF. * \#228386 - Text with capital style is now preserved properly while converting a Word document to PDF. * \#228319 - Page border is now preserved properly while converting a Word document to PDF. * \#212671, \#212772, \#220859, \#230072, \#232381 - List style name is now updated properly while opening and saving a Word document. * \#228049- Image position is now preserved properly while saving an RTF format Word document. * \#231842- Content control text formatting is now preserved properly while parsing DOCX document. * \#234841 - Watermark is now preserved properly while opening a DOC format Word document. * \#235667 - Data inside the table is now preserved properly while updating alternate chunks in a Word document. * \#231056 – IF field text is now preserved properly while converting a Word document to PDF. * \#231677 - Image is now preserved properly while saving a Word document. * \#228049 - Table left indent value is now preserved properly while opening an RTF document. * \#234817 - Text color is now preserved properly while resaving a Word document. * \#234270 - Content control text is now preserved properly while converting a Word document to PDF. * \#234335 - Table preservation issue has been resolved while opening and saving a Word document. * \#228049 - Header and Footer distance is now preserved properly while saving an RTF format Word document. * \#231431 - The **System.OverFlowException** will no longer be thrown while saving a DOCX format Word document. * \#234971 - Table cells are now preserved properly while converting a Word document to Image. * \#234698 - The **ArgumentOutOfRangeException** will no longer be thrown while converting a Word document to PDF. * \#234693 - Hanging issue has been resolved while converting a Word document to PDF. * \#233642 - The **NullReferenceException** will no longer be thrown while converting an RTF to PDF. * \#231056 - Spacing issue has been resolved while converting a Word document to PDF * \#230817 - Table cell is now preserved properly while converting a Word document to PDF. * \#232331 - Shape is now preserved properly while converting a Word document to PDF. * \#234841 - Tab is now preserved properly while converting a Word document to PDF. * \#234972 - Table is now preserved properly while converting a Word document to PDF. * \#234972 - Pagination issue has been resolved while converting a Word document to PDF. * \#234841 - Table is now preserved properly while converting a Word document to PDF. * \#233810 - Text is now aligned properly while converting a Word document to PDF. * \#233810 - Picture is now preserved properly while converting a Word document to PDF. * \#232331 - Text is now preserved properly while converting a Word document to PDF. * \#232770 - The **NullReferenceException** will no longer be thrown while converting a Word document to PDF. * \#229546 - Text is now preserved properly while converting a Word document to PDF. * \#231056 - Spacing issue has been resolved while converting a Word document to PDF. * \#234409 - Frame content is now preserved properly while converting a Word document to PDF. * \#236156 - Pagination issue has been resolved while converting a Word document to PDF. * \#236611 - Footnote is now preserved properly while converting a Word document to PDF. * \#236070 - Parentheses are now preserved properly while converting a Word document to PDF. * \#236156 - Hanging issue has been resolved while converting a Word document to PDF. * \#235770 - Checkbox symbol is now preserved properly while converting a Word document to PDF. * \#233383 - Memory usage is now optimized while converting a Word document to PDF with Chinese text. * \#234978 - Table is now preserved properly while converting a Word document to Image. ## DockingManager ### Bug fixes * \#232130 - Managed theme is now applied properly in DockingManager. * \#234171 – Child layout is now updated properly when using user control as host control in DockingManager. * \#230793 - Re-docking of child windows from float to tabbed state is now updated properly in DockingManager when EnableDocumentMode is set to true. ### Features * Tabs in the DockingManager can be closed by clicking mouse middle button, using `CloseTabOnMiddleClick` property. * Tab groups can be created interactively in DockingManager. When docking, the dock hints will be visible. * The performance of tab switching improves when DockingManager contains several document windows. * The performance of DockingManager improves when adding document windows at run time. ## EditControl ### Bug Fixes * \#233919 – SyntaxEditor syntax is highlighting properly in C# language. ## Visual Studio Extensions ### Features * Syncfusion Project template allows to create a .NET Core 3.0 application. ## GridGroupingControl ### Bug fixes {:#gridgroupingcontrol-bug-fixes} * \#233520 - Column widths are now updated when fit the column width in ZoomGroupingGrid. * \#234206 - GetYAmountCount returns FilteredRecords count without null exception. ## MultiColumnTreeView ### Breaking Changes * `TickThickness` property in `TreeNodeAdvStyle` has been changed to the `CheckBoxTickThickness`. ### Bug fixes * \#234751 - When hiding the parent node in runtime, expanded child nodes will not be duplicated. ## MultiSelectionComboBox ### Bug fixes {:#multiselectioncombobox-bug-fixes} * \#235809 - Correct item is selected when using delimiter mode. * \#234819 – The auto complete behavior in MultiSelectionComboBox works for text from different culture. ## NavigationDrawer ### Features * \#144853 - A new click event handler `ItemClicked` was added to detect the `DrawerMenuItem` click . ## NavigationView ### Features * The border support has been provided with border thickness option for Office2019Colorful theme in NavigationView. ## PDF ### Features {:#pdf-features} * \#230886 – Added support for trailer ID in both new and existing PDF documents. * Added support for adding PDF annotation comments and reviews. * \#225704 – Added support for creating PDF 2.0 documents. * \#141255, \#226165 – Added save progress support for an existing PDF document. * \#235204 – Added PDF light table column width proportional sizing support. ### Bug Fixes {:#pdf-bug-fixes} * \#231273 - Free text and polygon annotation are now preserving properly while flattening the PDF document. * \#231625 - Review status is now preserving properly while exporting or importing the annotations. * \#231273 - Object null reference exception no longer occurs while flattening the PDF documents. * \#231795, \#231668, \#231273, \#233045 - Review status and layer are now preserving properly while importing annotations from the XFDF file. * \#226015 - Grouped annotations are now preserving properly while importing or exporting the annotations. * \#232559 - PDF form fields are now cloned properly. * \#233194 – Text is now preserving properly while filling form fields. * \#232920 – Text is now preserving properly while filling the XFA form fields. * \#232477, \#232754 - Application will no longer crash while importing pages from the PDF document. * \#228012, \#231381 - Form fields are now preserving properly when loading a PDF document in different instances. * \#226230 - Form fields will never be missing while importing pages from a PDF document. * \#232496 - File size will no longer increase while continuously saving a PDF document. * \#233102 – Invalid cast exception will no longer occur while flattening the combo box fields. * \#233004 – Form fields size is now preserving properly while flattening form fields. * \#231901, \#228043 - Annotations are now flattened properly in a PDF document. * \#231965, \#231964 - Now, you will get proper exception messages while creating the QR barcodes with incorrect values. * \#230688 - Document will no longer corrupt while saving the encrypted PDF document. * \#230368 – Font names are getting properly while using the PdfUsedFont instance. * \#230023 - Output document will no longer corrupt while loading the PDF documents. * \#229260 - The redaction position is now proper while applying redaction in an existing PDF document. * \#229270 - Alternate text for images will no longer be removed while saving a PDF document. * \#228375 - Annotations are now preserved properly while flatting them. * \#228619 - Null reference exception will no longer occur while saving the PDF documents with annotation and redaction. * \#228486 - Key not found exception will no longer occur while loading PDF document. * \#227803 - Document information is now removed properly while passing empty string. * \#232754 - Exception will no longer occur while importing pages from existing PDF document. * \#228072 - Preservation issue will no longer occur while converting a Word document to PDF. * \#226539 - Ligature characters are now preserved properly while converting XPS to PDF. * \#227803 - PDF document will no longer corrupt while applying redaction. * \#228202, \#228667 - Output document will no longer corrupt while merging the PDF documents. * \#228635, \#226614 - Exception will no longer occurs while obtaining destination from annotation. * \#231550 - Performance has been improved while converting a Word document to PDF. * \#229685 - Font substitution issue will no longer occur while converting a Word document to PDF. * \#231801 - Exception will no longer occur while opening 256-bit protected document in Nuance PDF. * \#228341 - Code 128, code 32, and code 93 extended barcodes are now rendered properly. * \#228336 - Null reference exception will no longer occur while merging the PDF documents. * \#224584 – Parameter is not valid exception will no longer occur while performing redaction on the OCR'ed documents. * \#227845 - Acroform fields tab index is now retrieved properly. * \#229922, \#234322 – Color is now preserving properly while using PDF linear gradient brush with vertical mode. * \#229746 – Null reference exception will no longer occur while loading the XFA PDF document. * \#234625 – Text redaction is now applied properly in OCR’ed PDF documents. * \#237633 – Exception will no longer occur while signing PDF with timestamp server. * \#237481 – Output document will never corrupt when open/save it using open and repair. * \#237481 – Output document will never corrupt while changing the document permissions. * \#236388 – Exception will no longer occur when deleting corrupted PDF file. * \#236168 – Named destination will be added properly. * \#235880 – Special characters are now preserved properly while applying redaction. * \#235880 – Memory consumption is now optimized when converting Word to PDF. * \#234809, \#144285, \#235480, \#237790, \#237790 – Position is now proper while adding signature field to the existing PDF file. * \#234458 – PdfLoadedPage client size is now retrieved properly. * \#233768 – Layers are now preserved properly when flattening annotations. * \#228341 – Code 93 and Code 93 extended barcode are not generated properly. * \#232609 – Bullets are now preserved while converting Word to PDF. * \#230599 – Preservation issue will no longer occur while drawing EMF to PDF. * \#235715 – Preservation issue will no longer occur while drawing PDF grid. * Combo box field values are now exported properly. * Line arrows are now preserved properly while converting EMF to PDF. ## PdfViewerControl ### Features {:#pdfviewercontrol-features} * \#106643, \#112413, \#114139, \#135013, \#140663, \#F113788, \#148562, \#F113788, \#151160, \#163331, \#186360, \#205045 - Support to pan the PDF document using mouse and touch interactions has been provided. * \#225313 - Exposed `MinimumZoomPercentage` API to set the minimum zoom percentage for `PdfViewerControl`. * \#230089 - Exposed `ShowPrintStatusDialog` API to show or hide the print status dialog when printing the PDF document silently. * \#230770 – Exposed API `IsTextSearchEnabled` to enable or disable the text search functionality. * \#230770 – Exposed API `IsTextSelectionEnabled` to enable or disable the text selection functionality. * \#232835 – Exposed `DocumentLoading` event to indicate the loading progress of PDF document. ### Bug Fixes {:#pdfviewercontrol-bug-fixes} * \#224584 - Extracting images from the particular PDF document is now working properly. * \#225313 - Magnification of PDF pages are now working properly when resizing the application. * \#227589 - Time taken for extracting text from the particular PDF document is now optimized. * \#229466 - `OutOfMemoryException` will no longer be thrown when loading the large PDF document. * \#229522 - Table of contents navigation is now working properly for the particular PDF document. * \#230418, \#230356 - Now, the `FindText` method finds the text properly in the particular PDF document. * \#231093 - Time taken for saving the particular PDF document is now optimized. * \#231134 - Text search is now working properly for the particular PDF document. * \#226800 – Magnification of PDF Viewer is now working properly in lower zoom percentages. * \#235222 – Memory leak issue with `PdfDocumentView` is now resolved. * \#236177 – Images from the particular PDF document are now exported properly. ## PivotGridControl ### Bug fixes {:#pivotgridcontrol-bug-fixes} * \#231914 - The Pivot Grid control will refresh properly when items are added to the report dynamically via check option in schema designer. * \#231882 - The Pivot Grid control will be exported properly when summary type is set as `SUM`. ## PopupMenu ### Bug fixes {:#popupmenu-bug-fixes} * \#F143909 - MenuGrid height value is returned correctly. ## Presentation ### Features {:#presentation-features} * \#236376 - Support has been added to PowerPoint write protection. ### Bug Fixes {:#Presentation-bug-fixes} * \#212572, \#229361 - The group-shapes will now be rendered properly if vertical or horizontal flips applied along with rotations. * \#229361 - Table cell background is now properly applied for vertically merged cells in PowerPoint to PDF conversion. * \#232725 - The NullReferenceException will no longer be thrown while converting PowerPoint to PDF. * \#231624 - OLE objects will now be converted properly in PowerPoint to PDF conversion. * \#230386 - The StackOverflowException will no longer be thrown while accessing paragraph font color. * \#230575 - Formatting will be preserved properly after cloning and merging a PowerPoint slide with destination theme. * \#230666 - The Metafile image rendering is now skipped properly in Azure environment by avoiding the OutOfMemoryException. * \#233799 - The NullReferenceException will no longer be thrown while cloning an OLE Object in master slide. * \#231053 - Chart data label color will not be changed while cloning a PowerPoint slide with chart. * \#233982 - The NullReferenceException will no longer be thrown while parsing customized master slide. * \#236894 - Hanging issue has been resolved while parsing a PowerPoint with sound transition. * \#236892 - The IndexOutOfRangeException will no longer be thrown while converting PowerPoint to Image. * \#232687 - Value axis title will now be aligned properly while converting PowerPoint to PDF. ## RadialGauge ### Features * Quarter circle and fill type frame support has been provided for RadialGauge. * The `DrawLabel` event has been provided to customize the label in RadialGauge. ## RadialSlider ### Features * High DPI support has been provided for RadialSlider. ## RibbonControlAdv ### Features * \#230986, \#231065 - Support has been provided for `ToolStripEx` items to customize the distinct images for distinct size modes. * \#225195 - Provided option to handle the RibbonDisplayOption programmatically. ### Breaking Changes #### We have organized the class structure of style implementation, please find the details below. * `ToolStripEx` - style properties can now be accessed directly from its property `ToolStripEx.ThemeStyle` instead of `RibbonControlAdv.ThemeStyle.ToolStripEx` . * `RibbonDisplayOption` - style properties can now be accessed using property `RibbonControlAdv.ThemeStyle.DisplayOptionStyle.BackColor` instead of `Ribbon.ThemeStyle.DisplayOptionBackColor`. * We have provided Icon Font support for `RibbonControlAdv`,so we have removed the image properties like `MaximizeSystemButtonImage`, `RestoreSystemButtonImage`, `CloseSystemButtonImage`, `InactiveMinimizeSystemButtonImage`, `InactiveMaximizeSystemButtonImage`, `InactiveRestoreSystemButtonImage`, `InactiveCloseSystemButtonImage`, `RibbonDisplayOptionImage`, `InactiveRibbonDisplayOptionImage`, `AutoHideImage`, `ShowTabsImage`, `ShowTabsAndCommandsImage`, `AutoHideCheckedImage`, `ShowTabsCheckedImage`, `ShowTabsAndCommandsCheckedImage`, `TouchModeItemImage`, `MouseModeItemImage`, `TouchModeItemCheckedImage`, `MouseModeItemCheckedImage`, `SystemModeImage`, `UpImage`, `PinImage`, `MinimizeSystemButtonImage`, `MaximizeSystemButtonImage`, `RestoreSystemButtonImage`, `CloseSystemButtonImage`, `InactiveMinimizeSystemButtonImage`, `InactiveMaximizeSystemButtonImage`, `InactiveRestoreSystemButtonImage`, `InactiveCloseSystemButtonImage` and `BackStageNavigationImage` . ### Bug fixes * \#235458 - Fixed serialization and deserialization when merging `RibbonTabs` and `ToolStripEx` using `RibbonPanelMergeContainer`. * \#235482 - `SetVisualTheme` will now work properly for `RibbonControlAdv` in `SkinManager`. * \#143829 - `InvalidOperationException` will no longer be thrown when opening the designer in run time. ## SfButton ### Bug fixes * \#232825 - Text will be displayed properly in other languages. ## SfComboBox ### Bug fixes {:#sfcombobox-bug-fixes} * \#229227 - DropDownList height is now getting updated while adding the item in binding source. ## SfDataGrid ### Bug Fixes {:#sfdatagrid-bug-fixes} * \#231506 - The `KeyNotFoundException` will no longer be thrown when grouping the columns continuously. * \#233460 - Null values can be edited in the `GridDateTimeColumn` when DataGrid's underlying datasource is `DataTable`. * \#210851 - The cross thread exception will no longer be thrown when the underlying collection is updated in `BeginInvoke`. * \#234020 - Horizontal scrollbar will not be shown when resizing the grid with the `AutoSizeColumnMode` as `Fill`. * \#235930 - Caption summary row is rendered properly with the hidden columns and row header. * \#236407 - The `RowState` property of DataRow will not be modified when end the editing without changing any value in a row. * \#236785 - The `Instance is readonly` exception will no longer be thrown when pressing the negative (-) key in the numeric cell. * \#236401 - The `ArgumentOutOfRangeException` will no longer be thrown when adding rows to details view grid when expanded. * \#236401 - Grid is rendered properly when deleting rows when details view rows are expanded. * \#237327 - The `InvalidCastException` will no longer be thrown when grouping the column with `DBNull` value. * \#237624 - Edit cursor is shown properly for the clipped cell when entering to the edit mode. * \#237327 - The null reference exception will no longer thrown when grouping in `DataTable` collection when current row goes out of visible area. ## SfForm ### Bug Fixes {:#sfform-bug-fixes} * \#237218 - The cross thread exception will no longer be thrown when closing a form continuously when form is opened as dialog. ## SfListView ### Features * Support has been provided to retrieve row index at any point in SfListView. ## SfTabbedForm ### Features {:#sftabbedform-features} * Support has been provided for showing `ContextMenu` on tabs. * Support has been provided for tab navigation with an intuitive primitive button. * Support has been provided for dragging tabs from one position to another position. * Support has been provided for the right-to-left (RTL) arrangement for users working in the right-to-left languages such as Hebrew, Arabic, and Persian. ## SpellChecker ### Bug fixes * An option has been provided to add words in custom dictionary file in SpellChecker. ## SplitContainerAdv ### Features * An option has been provided to change the border thickness of SplitContainerAdv. ## Spreadsheet ### Bug fixes {:#spreadsheet-bug-fixes} * \#233893 - Target invocation exception while loading the ".xlsm" file has been fixed. ## SuperToolTip ### Features * \#229568 - Provided option to hide `SuperToolTip` for item in `RibbonControlAdv`. ## TabbedMDIManager ### Bug fixes * \#234339, #234890 – Child layout is now updated properly when using user control as tab child. ## TabControlAdv ### Features * A support has been provided to close the tab on click using the mouse wheel button in TabControlAdv. ### Breaking Changes * `ShowCloseButtonBackColor` property in `TabControlAdvVisualStyle` has been removed. We can use `ShowCloseButtonHighLightBackColor` property from `TabControlAdv` instead. ## TabSplitterContainer ### Features * An accessibility support has been provided for TabSplitterContainer. * An option has been provided to change the border thickness of TabSplitterContainer. ## ThemeStudio ### Features * Provided built-in Microsoft Windows 10 OS like high contrast theme. * Provided Office2019 colorful and high contrast themes for the following new controls. 1. Spreadsheet 2. Pivot Grid 3. MainFrameBarManager 4. CommandBar 5. Popup Menu 6. DomainUpDownExt 7. NumericUpDownExt 8. GradientPanel 9. GradientPanelExt 10. GradientLabel 11. Rating ### Bug fixes * \#237247 - Popup notification will be displayed when Theme assemblies are not saved in the machine. ## TreeViewAdv ### Breaking Changes * `TickThickness` property in `TreeNodeAdvStyle` has been changed to the `CheckBoxTickThickness`. ### Features * \#225655 - Performance improvement when loading the large number of nodes. ## XlsIO ### Features {:#xlsio-features} * \#227983 - Exception, "Text length cannot be more than 32767" can be ignored using the `ExcludeAdditionalCharacters` flag. * \#230550, \#230543 - The QueryTable parameters have been implemented. ### Breaking Changes {:#xlsio-breaking-changes} * \#227983 - `ExcludeAdditionalCharacters` has been added in `IApplication` class to ignore exception and exclude characters more than 32767 (maximum allowed characters) in a cell text. * \#230550, \#230543 - `IParameters` interface is added to represent the parameter collection of query table. * \#230550, \#230543 - `Add()` method is added in `IParameters` interface to add parameter to the query table. * \#230550, \#230543 - `ExcelParameterDataType` enum is added to represent the parameter data types. * \#230550, \#230543 - `ExcelParameterType` enum is added to represent the parameter types. * \#230550, \#230543 - `IParameter` interface is added to represent the parameter of query table. * \#230550, \#230543 - `DataType` property is added in `IParameter` interface to represent the SQL data type. * \#230550, \#230543 - `Type` property is added in `IParameter` interface to represent the parameter type. * \#230550, \#230543 - `PromptString` property is added in `IParameter` interface to represent the prompt string. * \#230550, \#230543 - `Value` property is added in `IParameter` interface to represent the parameter value. * \#230550, \#230543 - `CellReference` property is added in `IParameter` interface to represent the parameter cell reference. * \#230550, \#230543 - `Name` property is added in `IParameter` interface to represent the parameter name. * \#230550, \#230543 - `RefreshOnChange` property is added in `IParameter` interface to indicate whether the query table will be refreshed when the parameter is changed. * \#230550, \#230543 - `Prompt` property is added in `IParameter` interface that occurs when refreshing the table after setting the parameter type to prompt. * \#230550, \#230543 - `SetParam()` method is added in `IParameter` interface to set value to the parameter. * \#230550, \#230543 - `Parameters` property is added in `QueryTableImpl` class to represent the parameters of query table. * \#234003 - `IgnoreSheetNameException` property is added in both `IApplication` interface and `ApplicationImpl` class, which gets or sets a boolean value to ignore duplicate worksheet name exception by adding a suffix at the end. * \#222226 - `HighLowLines` property in `IChartFormat` class gets high-low lines of stock and line charts. * \#222226 - `DropLines` property in `IChartFormat` class gets drop lines of stock, line and area charts. * \#222226 - `DropLineStyle` property in `IChartFormat` class gets or sets drop lines or high-low lines or series lines. * \#222226 - `HasDropLines` property in `IChartFormat` class gets or sets a boolean value denoting the drop lines of stock, line, or area charts. * \#222226 - `HasHighLowLines` property in `IChartFormat` class gets or sets a boolean value denoting the high-low lines of stock or line charts. * \#222226 - `HasSeriesLines` property in `IChartFormat` class gets or sets a boolean value denoting the series lines of pie of pie or bar of pie charts. * \#F143384 - `GetDirectPrecedents()` method is implemented in `IRange` class to get the direct precedent cells, which are referred by a formula in another cell. * \#F143384 - `GetDirectDependents()` method is implemented in `IRange` class to get the direct dependent cells, which refer to other cells. ### Bug Fixes {:#xlsio-bug-fixes} * \#F144022, \#224520 - Conditional formatting formula with sheet reference is now proper. * \#227766, \#231068 - Chart legend is now rendered properly while changing the chart type. * \#232040, \#232682 - Cell background color is now rendered properly on converting XML to XLSX format. * \#229121 - Picture name is now updated properly after removing a picture and inserting a new picture. * \#226753 - Exception is no longer thrown while opening an Excel file with formula in Dutch culture. * \#230294 - Picture created with camera tool is now properly changed with the `INDIRECT()` formula. * \#230697 - After accessing the used range, relative range indexer is now working properly. * \#231469 - Application no longer hangs while opening an Excel file with picture that has unsupported elements. * \#226860 - Performance will not degrade on exporting a range to a data table multiple times. * \#229117 - Named range index is now updated properly while copying ranges from two different workbooks. * \#228853 - Footer value in source worksheet no longer changes while modifying footer in cloned worksheet. * \#228560 - Null reference exception is no longer thrown while cloning the workbook. * \#224793 - Extra pages are no longer added with `FitAllColumnsOnOnePage` layout setting in Excel to PDF conversion. * \#231271 - Timestamp is preserved in zip file. * \#227209 - Argument out of range exception is no longer thrown while applying the template marker with `UnKnownVariableAction.ReplaceBlank`. * \#232727 - Argument exception is no longer thrown while opening an Excel file with `IgnoreErrors`. * \#228711 - Performance will not degrade on exporting data from Grid to Excel. * \#226133 - ArgumentOutOfRangeException is no longer thrown while accessing a range from cloned workbook. * \#225831 - NullReferenceException is no longer thrown while converting worksheet to PDF. * \#229460 - Exception is no longer thrown while converting Excel to PDF with hyperlink. * \#231882 - Performance will not degrade on exporting pivot grid to Excel. * \#233186 - Exception is no longer thrown while coping unmanaged memory from source to destination in .NET Core. * \#232040 - Cell Styles are now preserved properly after resaving the output file with Microsoft Excel. * \#232473 - Macro name is now set properly in shapes. * \#227998 - Pivot table with tabular layout no longer increases the page count in Excel to PDF conversion. * \#230759 - Conditional formatting with discontinuous range is now preserved properly in Excel to PDF conversion. * \#229528 - Exception is no longer thrown while opening a resaved Excel document with `ExcelIgnoreError` option. * \#232105 - Radar chart is now rendered properly while converting to image. * \#227410 - Pivot table field item is now preserved properly while resaving the Excel file with the `IsRefreshOnLoad` property. * \#235570 - Exception is no longer thrown when setting date time value in general format without having date separators. * \#233740 - Exception is no longer thrown on converting Excel to PDF with Doughnut chart. * \#228415 - Ole object formula bar is now shown properly on resaving the Excel document with Ole object. * \#236136 - Exception is no longer thrown while setting `PivotFieldDataFormat` as `PercentageOfParent` in pivot table. * \#225098 - The position of form controls (CheckBox, ComboBox, OptionButton) is now updated properly on inserting row or column. * \#234572 - Data validation is now properly preserved while resaving the Excel document. * \#234003 - Exception is no longer thrown while setting existing name to the worksheet. * \#233740 - Issue with "Textbox in chart is missing while resaving the Excel document" has been fixed. * \#235011 - Exception is no longer thrown while opening the Excel document with negative anchor row and column. * \#229691, \#225609, \#229497 - Cropping issue with Legend having manual size in chart to image conversion has been fixed. * \#225927 - Chart series with date time axis preservation issue in chart to image conversion has been fixed. * \#234789 - Multiple filter is now working properly in pivot table while setting `IsMultiFieldFilter` to TRUE. * \#234003 - Exception is no longer thrown while setting a name that is already in the existing sheet names collection. * \#222226 - `HighLowLines`, `DropLines`, `DropLineStyle`, `HasDropLines`, `HasHighLowLines` and `HasSeriesLines` APIs are exposed. * \#231382 - Spreadsheet XML is now stable. * \#231382 - Named range is now stable. * \#F141716 - Exception is no longer thrown while opening the Excel file when a namespace is not defined. * \#F142864 - Exception is no longer thrown while accessing the `IRange.Value` property in multi-threading. * \#F143467 - Argument null exception is no longer thrown while converting Excel to PDF. * \#F143384 - Direct dependency in `IRange` is now working properly. * Issue with "Waterfall chart individual data label color is not changing" has been fixed.
Control

Old API

New API

SpellCheckerAdv

CaptionButtonHoverForeColor

HoverCaptionButtonForeColor

SelectedBackColor

SelectionBackColor

SelectedForeColor

SelectionForeColor

SplitContainerAdv

SplitterHoverBackColor

HoverSplitterBackColor

SplitterHoverForeColor

HoverSplitterForeColor

SplitterHoverBorderColor

HoverSplitterBorderColor

TrackBarEx

ButtonHoverForeColor

HoverButtonForeColor

ButtonPressedForeColor

PressedButtonForeColor

ButtonHoverBackColor

HoverButtonBackColor

ButtonPressedBackColor

PressedButtonBackColor

SliderHoverColor

HoverSliderColor

SliderPressedColor

PressedSliderColor

TabControlAdv

IconHoverForeColor

HoverIconForeColor

ActiveHoverForeColor

HoverActiveForeColor

InactiveHoverForeColor

HoverInactiveForeColor

ActiveHoverBorderColor

HoverActiveBorderColor

ActiveCloseButtonHoverForeColor

HoverActiveCloseButtonForeColor

InactiveCloseButtonHoverForeColor

HoverInactiveCloseButtonForeColor

CloseButtonPressedForeColor

PressedCloseButtonForeColor

CloseButtonPressedBackColor

PressedCloseButtonBackColor

TabSplitterContainer

ButtonHoverBackColor

HoverButtonBackColor

IconHoverForeColor

HoverIconForeColor

SelectedButtonBackColor

ButtonSelectionBackColor

DockingManager

ItemHoverForeColor

HoverItemForeColor

ActiveCaptionButtonHoverBackColor

HoverActiveCaptionButtonBackColor

ActiveCaptionButtonPressedBackColor

PressedActiveCaptionButtonBackColor

CaptionButtonHoverBackColor

HoverCaptionButtonBackColor

ActiveCaptionButtonPressedForeColor

PressedActiveCaptionButtonForeColor

ActiveCaptionButtonHoverForeColor

HoverActiveCaptionButtonForeColor

CaptionButtonHoverForeColor

HoverCaptionButtonForeColor

ActiveCaptionButtonHoverBorderColor

HoverActiveCaptionButtonBorderColor

ActiveCaptionButtonPressedBorderColor

PressedActiveCaptionButtonBorderColor

CaptionButtonHoverBorderColor

HoverCaptionButtonBorderColor

SelectionMarkerColor

MarkerSelectionColor

TabbedMDIManager

ActiveCloseButtonHoverForeColor

HoverActiveCloseButtonForeColor

CloseButtonPressedForeColor

PressedCloseButtonForeColor

CloseButtonPressedBackColor

PressedCloseButtonBackColor

InactiveCloseButtonHoverForeColor

HoverInactiveCloseButtonForeColor

ActiveHoverBorderColor

HoverActiveBorderColor

ActiveHoverForeColor

HoverActiveForeColor

InactiveHoverForeColor

HoverInactiveForeColor

TextBoxExt

FocusBorderColor

FocusedBorderColor

IntegerTextBox

FocusBorderColor

FocusedBorderColor

DoubleTextBox

FocusBorderColor

FocusedBorderColor

PercentTextBox

FocusBorderColor

FocusedBorderColor

CurrencyTextBox

FocusBorderColor

FocusedBorderColor

SyntaxEditor

ListBoxSelectedBackColor

ListBoxSelectionBackColor

ListBoxSelectedForeColor

ListBoxSelectionForeColor