Essential Studio for Windows Forms Release Notes

v16.2.0.41
June 19, 2018
Starting with version 16.2 (2018 Vol 2), you need to include a valid license key (either paid or trial key) within your applications. Please refer to this help topic for more information

BannerTextProvider

Bug Fixes

  • #207221 - BannerText will be displayed when we set Multiline to True in Editor controls.

Calculate

Features

  • #142186 - Provided Support to add multiple array references in the LookUp formula.
  • #197518 , #202408 - Provided .NET Core 2.0 support.

Bug Fixes

  • #204442 - The CountIF formula calculates properly while setting the criteria to check the sub-string.
  • #200818 - The AND operation works correctly for the empty string values.
  • #205213 - Calculation of PI works correctly for the formulas which includes divide by zero value.

Chart

Bug fixes

  • #197414 - Swapping of high and low data points can be disabled in range area chart.
  • #198686 - Now the callout label accepts date-time values as label text.
  • #199715 - The trackball tooltip will not be displayed for empty strings.
  • #139600 - Now we can able to add categorical series after the BeginUpdate method has been called.
  • #203291 - Now the DrawThumbnail method will work without parent control.
  • #203094 - Space will not appear in axis when the RangePadding is set to None.
  • #193349 - The tooltip will be removed automatically after 5 seconds of delay on touch.

ColorUIControl

Bug Fixes

  • #207062 - NullReferenceException will not be thrown when the ColorGroup is removed.

ColorPickerUIAdv

Bug Fixes

  • #203554 - ColorPicked event will now be raised properly when visibility of StateButton is set to False.

ComboBoxAdv

Bug Fixes

  • #204645 - Dropdown arrow colors is now maintained even when control lost its focus.

Common

Feature

Provided Office 2016-inspired theme support for following controls:

  • GroupView
  • Radial Slider
  • RadialMenu
  • SpellCheckerAdv
  • EditControl
  • Navigation Drawer
  • ProgressBarAdv
  • XPTaskBar
  • XPToolBar
  • TabSplitter Container
  • TrackBarEx
  • Auto label
  • Toggle Button
  • Super Accelerator
  • Editable List
  • Font ListBox
  • Rating Control

DateTimePickerAdv

Bug Fixes

  • #203540 - NullReferenceException will not be thrown when null value is set to CalendarFont property in the designer file.

Diagram

Features

  • Office 2016 theme support for diagram control is added.

Bug fixes

  • #198075 - When changing the Layer visibility at runtime, node’s visibility not changed is fixed.
  • #198718 - Exception raised when drag and drop the ControlNode from SymbolPalette to Diagram is fixed.
  • #198922 - Exception raised when ungrouping the nested group node is fixed.
  • #71540 - While converting Visio stencil to diagram, ConnectionPoint's visibility is not working properly is fixed.
  • #136645 - Not able to set the diagram model’s name for DocumentExplorer control is fixed.
  • #204372 - Exception raised while right click on the palette’s nodes is fixed.
  • #204297 - Memory Leak issue while saving and loading the diagram with BitmapNode is fixed.

DocIO

Features

  • #197650, #198520, #201686 - Added support to preserve fonts embedded in Word document during DOCX to PDF conversion.
  • #F131792, #F132491 - Added support to preserve editable form fields during Word to PDF conversion.
  • #195530, #203634, #201967 - Added support to open and save Strict Open XML Document (*.docx) format.
  • #102574, #98747, #200288 - Added support for exporting Word Headings to PDF Bookmarks during Word to PDF conversion.
  • #200288 - Added support for generating 508 compliant PDF documents during Word to PDF conversion.
  • #F137353 - Added CharacterFormat property in WPicture class.
  • #204615, #204634, #205098, #F137327 - Added Font stream property in SubstituteFontEventHandler to set alternate font stream for missing fonts in device during Word to PDF/Image conversion.

Breaking Changes

  • #F137353 - The property CharacterFormat was added to the IWPicture interface.

Bug Fixes

  • #197282 - ArgumentException will be no longer thrown while parsing a particular RTF document.
  • #199294 - The character and paragraph properties inherited from source document default formats are now properly imported to destination document.
  • #197763 - Picture effects are now preserved properly while merging a cloned Word document for multiple times.
  • #196839 - Paragraph with “None” list style type is now preserved properly while parsing a HTML format document.
  • #201256, #201364 - Field code is now serialized properly within “instrText” element while opening and saving DOCX format document.
  • #198450, #198489 - FormatException will be no longer thrown while opening and saving a particular DOCX format document.
  • #198653 - ArgumentOutOfRangeException will be no longer thrown while updating fields in a particular Word document.
  • #200254 - ArgumentOutOfRangeException will be no longer thrown while parsing a particular DOCX format document.
  • #198360 - IndexOutOfRangeException will be no longer thrown while opening and saving a particular Word document.
  • #200327 - Formatting of contents within textbox is now preserved properly while converting a particular Word document as HTML.
  • #199782 - Font preservation issue has been resolved while converting a particular RTF document to Word document.
  • #199747 - No extra characters will be preserved while converting a Word document as RTF.
  • #198068 - Nested body contents are now preserved properly while parsing a particular Word document.
  • #195214 - Paragraph within nested table is now preserved properly while converting a particular Word document as PDF.
  • #195214 - Paragraph with keep with next property is now preserved properly while converting a particular Word document as PDF.
  • #195214 - Vertically merged cells are now preserved properly while converting a particular Word document as PDF.
  • #196520 - Fields with unknown type are now preserved properly while converting a particular Word document as PDF.
  • #196520, #200771 - List numbering preservation issue has been resolved while converting a particular Word document as PDF.
  • #195214 - Table styles are now applied properly while converting a particular Word document as PDF.
  • #199166, #202106 - ArgumentOutOfRangeException will be no longer thrown while updating content control text for Word to PDF conversion.
  • #189615 - Shape flip style is now preserved properly while converting a particular Word document as PDF.
  • #198450 - Frames are now preserved properly while converting a particular Word document as PDF.
  • #199783 - Watermark image is now preserved properly in the converted PDF when wash out property of the watermark is disabled.
  • #198249 - TOC text color is now preserved properly while converting a particular Word document as PDF.
  • #189881 - Text alignment is now preserved properly while converting a particular Word document as PDF.
  • #199056 - Preservation issue due to wrapping text around textbox has been resolved while converting a particular Word document as PDF.
  • #198842 - Footnote preservation issue has been resolved while converting a particular Word document as PDF.
  • #197456 - OutOfMemoryException will be no longer thrown while converting a particular Word document as PDF.
  • #198675 - NullReferenceException will be no longer thrown while converting a particular Word document as PDF.
  • #197524, #202787 - Hanging issue has been resolved while converting a particular Word document as PDF.
  • #196443 - Extra page preservation issue has been resolved while converting a particular Word document as PDF.
  • #200936 - Oval shape preservation issue has been resolved while converting a particular Word document as PDF.
  • #198662 - Image is now preserved properly while merging DOC format documents and saving as DOCX format document.
  • #198007, #195050 - The content control text is now preserved properly while converting a particular Word document as PDF.
  • #195050, #198007 - TOC content is now preserved properly after updating table of content which is inside the content control.
  • #198007, #195050 - Line break is now preserved properly while binding content control text for Word to PDF conversion.
  • #200715 - Ampersand symbol is now imported properly from a particular HTML file.
  • #200861 - The content control text is now preserved properly while converting a particular DOCX format document as RTF.
  • #201472 - File path is now shown properly in hyperlink which is created by using AppendHyperlink method.
  • #201466 - Vertical merged cells are now preserved properly while converting a particular Word document as PDF.
  • #201937, #202761 - ArgumentOutOfRangeException will be no longer thrown while performing Mail merge in a particular Word document.
  • #201812, #202761 - TOC content is now preserved properly while resaving a particular Word document.
  • #200399 - The image position with multiple column issue has been resolved while converting a particular Word document as PDF.
  • #202261 - The gray scale image recoloring is now preserved properly while converting a particular Word document as PDF.
  • #201685 - The horizontal shape position issue has been resolved while converting a particular Word document as PDF.
  • #200702 - Alternative text for OLE Picture is now preserved properly while saving a particular DOCX format document.
  • #200882 - Decimal separator is now preserved properly while exporting a particular HTML file in machines with German culture.
  • #202007 - No longer hangs while performing Word to PDF conversion for a particular Word document in 64-bit environment.
  • #201243 - Text watermark position issue has been resolved while converting a particular Word document as PDF.
  • #202883 - Tab position issue has been resolved while converting a particular Word document as PDF.
  • #201467 - Table missing issue has been resolved while converting a particular Word document as PDF.
  • #204072 - Bidirectional text is now preserved properly while converting a particular RTF document to Word document and vice versa.
  • #201718 - Shape position and size preservation issue has been resolved while converting a particular Word document as PDF.
  • #202700 - No longer hangs while performing Word to PDF conversion for a particular Word document.
  • #201967 - ArgumentOutOfRangeException will be no longer thrown while opening and saving a particular Word DOCX document containing web video element.
  • #201718 - SmileyFace shape preservation issue has been resolved while converting a particular Word document as PDF.
  • #199931 - Macro project signature is now preserved properly in customUI.xml (Ribbon QAT options) for a particular document during DOTM to DOCM conversion.
  • #203526 - NullReferenceException will be no longer thrown while updating document fields in a particular Word document.
  • #201243, #205470 - Text watermark position issue has been resolved while converting a particular Word document as PDF.
  • #204279 - List number is preserved properly while converting a particular Word document as PDF.
  • #199166, #200861, #202966 - Font size is now preserved properly while converting Word document with compatibility option overrideTableStyleFontSizeAndJustification as PDF.
  • #199221 - Table position issue has been resolved while converting a particular Word document as PDF.
  • #190618 - Content and frame position issue has been resolved while converting a particular Word document as PDF.
  • #197686 - IndexOutOfRangeException will be no longer thrown while parsing a particular RTF Word document.
  • #F135803 - Date field with static field code text is now preserved properly while converting a particular Word document as PDF.
  • #199221 - Text splitting issue has been resolved while converting a particular Word document as PDF.

DockingManager

Bug Fixes

  • #204163 - Programmatic docking of one form to top or bottom side of another dock form, adjust the size of the target form in DockingManager has been fixed.

  • #205155, F137399 - Floating panel will no longer goes back to Microsoft Excel application while selecting other dock child in DockingManager.

  • #204277 - Drag Splitter indicator will be positioned properly in all Screen resolution and DPI scaling.

EditControl

Features

  • #155711 - Improved the intellisense behavior and appearance based on Microsoft Visual Studio Editor.
  • #F133398 - Provided localization support for Formats editor, Language coloring, Key binding and their child dialog boxes.

Bug Fixes

  • #206948 - ArgumentOutofRange exception no longer occurs, when closing ContextChoice popup after deleting all lines loaded in EditControl.

GridControl

Bug fixes

  • #F136912 - The SUMIFS formula is now working properly with more than one constraints.
  • #151270 - Scrollbars are now displayed properly based on the width or height of the GridControl.
  • #203412 - The cursor is now updated properly at compile time in the ScrollControl.

GridGroupingControl

Features

  • #195366 - Provided the DrawDataBarCell event support to customize the DataBarConditionalFormatRule for some specific cells.
  • #195495 - Provided support to change the visible columns at runtime by using the ICustomTypeDescriptor.

Bug fixes

  • #F136374 - Sorting and grouping of records are now working properly when enabling the FilterMode as DisplayText and the SortByDisplayMember property.
  • #181506 - The formula expressions in ExpressionFields with nested functions now return the calculated value properly.

ImageStreamer

Bug Fixes

  • #205390 - Click event not triggered when the ImageStreamer is docked to Fill has been fixed.

MainFrameBarManager

Bug Fixes

  • #203848 – Null reference exception will no longer thrown while disposing XPMenu.

  • #207147 - ArgumentOutofRange exception no longer occurs on changing Active Item.

MessageBoxAdv

Bug Fixes

  • #197745- Details button shown when trying to show text message only in MessageBoxAdv has been fixed.

MonthCalendarAdv

Bug Fixes

  • #206877, 206983 - HorizontalAlignment and VerticalAlignment property will be applied to today and selected date cell properly.

MultiColumnTreeView

Features

  • #199265 - The Column Width can be fit based on its content.

PDF

Features

  • #199403,197452 - Support for adding annotation to the PDF Layers is added.
  • #93029,175644,190033,190937,194794,199329,198104 - Support for converting existing PDF document to PDF/A-1b document is added.
  • #188500,197742 - Support for flattening the existing signature field.
  • #188916 - Support for adding custom metadata to the PDF document.
  • #134972 – Support for adding document timestamp to the PDF document.
  • #202269 – Support for fill and save hidden item in PdfLoadedXfaDocument.

Bug Fixes

  • #198270 - Text preservation issue no longer occurs while converting XPS document to PDF.
  • #200302 - Improved the performance when importing the pages from the existing PDF document.
  • #200680 - Null reference exception no longer occurs when altering the page label of existing PDF document.
  • #200527 - Null reference exception no longer occurs when loading a PDF document with open and repair.
  • #200438 - Same key has already been added exception no longer occurs when loading particular PDF document.
  • #199711 - Null reference exception no longer occurs when importing named destinations from the PDF document.
  • #198565 - Null reference exception no longer occurs when merging the particular PDF documents.
  • #197635 - An error was encountered while retrieving page content exception no longer occurs when adding watermark to the existing PDF document in Adobe Acrobat Pro DC.
  • #199398 - URI value from PdfLoadedUriAnnotation is now preserving properly when retrieving the PDF document.
  • #199159 - Null reference exception no longer occurs when importing the pages from the particular PDF document.
  • #198936,198057 - Null reference exception no longer occurs when merging the particular PDF documents.
  • #198683 - Performance has been increased when loading particular PDF document.
  • #198249 - The inner EMF image is preserving properly while converting EMF to PDF.
  • #198498 - Opacity is now properly applying to the flattened annotation.
  • #198487 - Null reference exception no longer occurs when loading the particular PDF document.
  • #198391 - Application crashing issue no longer occurs when performing OCR in multi-threading environment.
  • #198281,198759 - Signature is now valid while adding digital signature to the PDF document in different time zones.
  • #197917 - Null reference exception no longer occurs when drawing HTML text in the existing PDF document.
  • #194851 - Improved the performance while closing the PDF document.
  • #196766,198057,196766 - The document size is optimized when importing the page from the particular document.
  • #197506 - The CreateTemplate method is now working properly in multi-threading environment.
  • #197436 - Argument out of range exception no longer occurs when filling XFA document.
  • #197077,198678 - Cannot find the PDF catalog information exception no longer occurs when loading the particular PDF document.
  • #197123 - PDF form fields are now preserving properly when merging the PDF documents.
  • #196643 - Improved the performance when loading the corrupted PDF documents.
  • #196621 - Improved the performance when splitting a large PDF document.
  • #195214 - Shapes are now preserving properly in PDF while converting EMF document to PDF.
  • #194948 - Improved the performance when creating large PDF document with Hebrew text.
  • #194156 - Image is now preserving properly while converting XPS document to PDF.
  • #194018 - ArgumentException is no longer occurs when flattening a PDF document.
  • #199712 - OutOfMemoryException no longer occurs when providing large input text to QR code.
  • #199907 - The PdfLoadedSignatureField is now loading from the existing PDF document.
  • #177819 - Text extraction is now preserving properly from the existing PDF document.
  • #201640 - Images are now compressing properly, when compressing existing PDF document.
  • #201292 - Cannot use the specified stream exception is no longer thrown, while loading the particular PDF document.
  • #196882 - Borders of PdfLoadedTextBoxField are now preserved properly while flattening form fields.
  • #200987 - PDF will no longer be corrupted, when adding the security to the protected document.
  • #201693 - Null reference exception will not occurs while merging particular PDF documents.
  • #201054 - PdfUsedFonts will not duplicate fonts from the particular PDF document.
  • #194851 - Improved performance for saving large PDF document.
  • #201871 - Preflight error will not occur when flattening PDF document.
  • #200949 - Text will be preserved properly while converting Word to PDF with complete font embedding.
  • #199545 - Border color and font is now retrieving properly from PdfLoadedFreeTextAnnotation.
  • #203312 - Text is now preserving properly when appending to the particular PDF document.
  • #199195 - OutOfMemoryException no longer occurs when performing OCR on large PDF document.
  • #201303 - PDF layer is now removing properly from the page.
  • Child PdfGrid borders are now preserved properly.
  • Cell padding is now applied properly to the background image of PdfGridCell.

PdfViewerControl

Features

  • #184772, #186961, #198378 - Optimized memory used for text search operations.
  • #195228 - Support to override toolbar button action in PDF viewer has been added.
  • #200030 - Support for extracting text along with its format has been added.
  • #200673 - Support for getting current and maximum vertical scroll offsets of PDF viewer has been added.
  • #202398, #202875 - Improved the quality of contents while printing with Pdfium rendering engine.
  • #137022 - Exposed API DocumentInformation for getting the document information.

Bug Fixes

  • #184772 - The memory used for FindText operation in the PDF viewer is now optimized.
  • #196736 - The Identity-H fonts will now be rendered properly in PDF viewer.
  • #197624 - The ArgumentException will not be thrown while extracting the text from the provided PDF document.
  • #197787 - The length of the extracted text will be proper when using the ExtractText() method multiple times for same page.
  • #197917, #198462 - The PDF document will be scaled properly while resizing the document faster.
  • #198378 - The memory used for FindText operation in PDF viewer is optimized.
  • #199159 - NullReferenceException will no longer be thrown while importing pages from the particular document.
  • #199359, #203315 - The FindText API is now working properly on searching a text.
  • #200679 - The large object heap size is now reduced while loading the document in PDF viewer.
  • #201587 - The FindText and SearchText APIs are now working properly on searching a text.
  • #204938 - Text search is now working properly for the rotated PDF document.
  • #205862 - Memory used in the Pdfium rendering engine to load and scroll the PDF documents is optimized.
  • #135337 - The particular PDF document is displayed properly in PDF viewer.

PivotGrid

Bug fixes

  • #203013 - Filter items are now maintained properly inside filter pop-up.
  • #200279 - While exporting the PivotGrid control to Excel, total cell visibility is seen according to ShowSubTotals and ShowGrandTotals settings.
  • #199647 - We can now export the PivotGrid, after filtering any value to Excel, in PivotTable mode properly.

Features

  • #192854 - Serializing and de-serializing pivot fields for later use.

Presentation

Features

  • #188453 , #195951, #120538, #150198, #154578, #162596, #165263, #175560, #179509, #190137 - Added support for creating and editing animations in PowerPoint presentation.
  • #195951 - Added support to convert the SmartArt diagrams with shape guide properties.
  • #201054 - Added support to replace a missing font with another substitute font while converting a PowerPoint presentation to image or PDF document.

Breaking Changes

  • The property Timeline was added to the IBaseSlide interface.
  • The property FontSettings was added to the IPresentation interface.

Bug Fixes

  • #201506 - Used memory is now disposed properly after resaving the PowerPoint presentation with charts.
  • #198361 - Images are now preserved properly while performing clone and merge in PowerPoint presentation.
  • #199566 - The URL associated with a hyperlink is now preserved properly while re-saving the PowerPoint presentation.
  • #199259 - Application will no longer hang while re-saving the PowerPoint presentation with SmartArt diagrams.
  • #196810 - PowerPoint presentation is no more corrupted while applying slide formatting options.
  • #199260 - NullReferenceException is no more thrown while converting a Presentation slide to image.

RibbonControlAdv

Features

  • Tab scrolling support when more number of RibbonTab present in Ribbon.
  • Support to scroll the hidden Toolstrip, when added Toolstrip exceeds the RibbonTab.
  • Improved alignments, spacing for all the elements of RibbonTab for Office 2016 theme.
  • Support provided to hide Application icon in Office2016 theme.
  • Ribbon customization and Quick Access Toolbar windows combined into single dialog like in office Ribbons.
  • #196432 - BackStageTab and BackStageButton which has no image can be add to QAT with image using property ShowImage.

Breaking Changes

  • The properties BackStageButtonForeColor and BackStageTabForeColor are marked as deprecated. A new property BackStageItemForeColor is added to replace these deprecated properties.
  • The properties BackStageButtonSelectionColor and BackStageTabSelectionColor are marked as deprecated. A new property BackStageItemSelectionColor is added to replace these deprecated properties.
  • The properties BackStageButtonHoverColor and BackStageTabHoverColor are marked as deprecated. A new property BackStageItemHoverColor is added to replace these deprecated properties.
  • The property ToolStripBorderColor is marked as deprecated. Please use ToolStripSpliterColor property to set Border color for ToolStripEx.

Bug Fixes

  • #202917 - NullReferenceException will not be thrown in IsFormOpened() method of the control.
  • #204261 - NullReferenceException will not be thrown when RibbonForm is not used.
  • #206450 - NullReferenceException will not be thrown when removing ToolStripPanelItem from StatusStripEx.
  • #206067 - Changed the default color of the ToolStripItemForeColor for Colorful scheme in Office2016 style by comparing with Microsoft Office.

SfButton

Features

  • Provided support for Office 2016 theme.

SfCalendar

Features

  • Provided tooltip support for SfCalendar.

  • Provided cell customization support for all views in SfCalendar.

  • Provided Office 2016-inspired theme support for SfCalendar.

SfComboBox Preview

The combo box is a text box component that allows users to type a value or choose an option from a list of predefined options. It has several out of the box features, such as data binding, filtering, UI customization, accessibility, and more.

Key Features

  • Data binding - Support to bind IEnumerable type data sources.
  • Auto complete - Supports different modes of auto complete actions.
  • Multi selection - Support to select multiple values from drop-down list.
  • Select all items - Supports choosing all items in a multi select combo box.
  • Watermark - Helps to prompt user by providing additional hints about the data that should be entered into the text box.
  • Tooltip - Support to show the tooltip when selecting more values in the multi select combo box.
  • Styling - Supports customizing styles and appearance.
  • Pop-up resizing - Supports resizing the drop-down container using a resize gripper placed at the bottom of pop-up control.
  • Accessibility - Supports various accessibility features to make applications available to wide variety of users.
  • Theme - Supports built-in Office 2016 theme.

SfDataGrid

The SfDataGrid has been released in its final version.

Features

  • Provided support for Master Details View.
  • #201623 - Provided support for ComboBox column type.
  • #201311 - Provided support for busy indicator for long data operations such as data loading, sorting, grouping, and filtering.
  • #136513 - Provided support for font orientation in the cell.
  • Provided support for ComboBox filter row editor.
  • Provided support for MultiSelect ComboBox filter row editor.
  • Provided support for Office 2016 theme.

Breaking Changes

  • Syncfusion.SfListView.WinForms assembly is added as dependent for SfDataGrid control as we have implemented the ComboBox column type, ComboBox filterRow row editor, MultiSelect ComboBox filter row editor and replace the SfListView with Microsoft ListView in GridFilterControl.

Bug fixes

  • #203870 - Sorting is now applied properly for the IQueryable type collection.
  • #206176 - SelectedIndex property is now updated properly when set it programmatically.
  • #F138057 - System.Overflow exception is no longer thrown while searching the text in a very long string.
  • #F137960 - Null reference exception is no longer thrown while setting DisplayText for the row header by using the DrawCell event.

SfDateTimeEdit

Features

  • Provided Office 2016-inspired theme support for SfDateTimeEdit.

SfListView Preview

The list view control allows users to select an item or multiple items from a list-like interface. The data can be sorted, grouped, and filtered.

Key Features

  • Data binding - Supports to bind IEnumerable type data sources.
  • Data operations such as sorting, grouping, and filtering with the fast data processing.
  • Selection - Support to select an item with different selection modes..
  • CheckBox with selection - Support to choose the multiple items from the list with the different check box selection modes. It supports selecting all the list view items in list and also based on groups.
  • Item height - Height for the group header and Item can be customizable. Supports to fit all items based on content.
  • Styling - Supports for customizing styles and appearance of the items in list.
  • Theme - Supports built-in Office 2016 theme.
  • Accessibility - Supports various accessibility features to make applications available to a wide variety of users.

SfNumericTextBox

Features

  • Provided Office 2016-inspired theme support for SfNumericTextBox.

SfScrollFrame

Features

  • Provided support for Office 2016 theme.

SfSkinManager Preview

The SfSkinManager is a component used to apply and manage themes for the controls or components derived from the IThemeProvider interface. It provides support to apply uniform theme for all the child controls derived from IThemeProvider in the application.

Key Features

  • Provides support to apply same theme for all the child controls in the application.
  • Provides support to apply theme only for a specific child control in the application.

SfSmithChart

Features

  • Provided Office 2016 theme support for smith chart control.

SfToolTip

Features

  • Provided support for Office 2016 theme.

Spreadsheet

Features

  • #193297 - Provided support to import the CheckBox form control from Excel.

Tree Navigator

Bug Fixes

  • #204513 - Padding will now be applied correctly for the control.

Features

  • #204550 - Keyboard support for navigation has been provided.

TreeViewAdv

Bug Fixes

  • #203008 - TreeViewAdv will not scroll automatically while checking the check box of the TreeNodeAdv.

XlsIO

Features

  • #155355, #179457, #204279 - Provided support for chart color and size properties referencing from style IDs in Chart to Image and PDF conversions.
  • #116822, #117394, #119390, #119962, #129968, #133270, #140132, #140126, #165470, #196116 - Provided support for AutoShapes in Excel to PDF conversion.
  • #201193 - Provided support to retain formula references while removing and reattaching worksheets.
  • #196744 - Provided support for “Repeat All Item Labels” option in pivot table.
  • #193297 - Provided support for GroupShapes.
  • #186369 - Provided support to skip blank cells on range copy.
  • Provided support for Resize and Offset operations in IRange.
  • Provided support for extension lists that are supported by Microsoft Excel.

Breaking Changes

  • #155355, #179457, #204279 - Style property is added in IChart interface.
  • #201193 - UpdateSheetFormulaReference is added in IApplication interface to ensure whether to remove worksheet reference in formulas on removing and reattaching the worksheet.
  • #196744 - RepeatLabels property is added in IPivotField interface.
  • #196744 - RepeatAllLabels(bool) method is added in IPivotTableOptions interface.
  • #193297 - Group(IShapes), UnGroup(IGroupShape), UnGroup(IGroupShape, bool) methods are added in IShapes interface.
  • #186369 - CopyTo(IRange, ExcelCopyRangeOptions, bool) method is added in IRange interface to skip blank cells while copying.
  • #198134 - FullFileName property is added in IWorkbook interface.
  • #198663 , #198664 - IRange and IWorkbook interfaces are implemented with IEnumerable.
  • Resize() and Offset() methods are added in IRange interface.
  • ShowLeaderLines and LeaderLines properties are added in IChartSerie interface.
  • IIconConditionValue interface with properties IconSet and Index is added.

Bug fixes

  • #200525 - Corruption issue while removing last row in a table is fixed.
  • #200090 - Space preservation issue while resaving a binary (XLS) file to xml format (XLSX) is fixed.
  • #198853 - Incremental formula is set properly for formulas with sheet reference.
  • #198385 - Legend color is not set when applied for entire legend collection is fixed.
  • #198849 - Column styles will be moved properly while inserting column in a worksheet.
  • #198858 - File with macros can be saved successfully without any corruption.
  • #198898 - Excel file with external formula reference in data validation can be opened without any exception.
  • #198785 - Find values within range accepts ExcelFindType.Values without any exception.
  • #198289 - Performance issue while opening Excel file with data validation applied on large range is resolved.
  • #198385 - Issue with chart axis font color for binary file is fixed.
  • #158298 - Month and day columns in pivot table can be sorted properly.
  • #197892 - Text gets cropped on CSV to PDF conversion is fixed.
  • #195255 - Performance issue while closing the workbook is fixed.
  • #197896 - Filter icon visibility issue in merged column header is fixed.
  • #197903 - Number formats are preserved correctly without any addition of extra slashes.
  • #198277 - Exception raised while opening the Excel file with date cell type is resolved.
  • #197711 - Exception thrown while saving an XML file having default parent style index to XLSX format is resolved.
  • #135796 - Issue with border of text box shape in worksheet to image conversion is fixed.
  • #197433 - Issue with row height value when changing the system resolution is resolved.
  • #197691 - Issues with Doughnut chart explosion and category values in the data labels in chart to image conversion are fixed.
  • #197106 - Calculated field can be added to more than one pivot table without any file corruption.
  • #196836 - Object reference exception when worksheet has custom property set to null is resolved.
  • #196955 - Chart font color settings are applied properly in chart elements.
  • #158298 - Issue with pivot table field sorting when sort field items are less than the field item count is fixed.
  • #196737 - Worksheet header image can be replaced properly without any variation in image size.
  • #196116 - Image is rendered properly in Excel to PDF conversion when ExportQualityImage property of converter settings is set true.
  • #196502 - Exception while opening an Excel file with empty fill tag is resolved.
  • #191260 , #196173 - Used range is properly updated while layouting a pivot table.
  • #196117 - Issue with hyperlink added to a cell after adding shape hyperlink is fixed.
  • #195137 , #196893 - Column text contains DateTime formatted values instead of Date values is fixed.
  • #198849 - Cell data validation is removed properly while copying empty cells.
  • #F135796 - ArgumentOutOfRangeException in PresentationCore during chart to image conversion in different cultures is fixed.
  • #F136967 - Issue while parsing numeric cell value in Brazil culture is fixed.
  • #200508 - Pivot field sorting is incorrect while sorting month name is fixed.
  • #203029 - Issue with nullable properties not getting exported in Business Objects is fixed.
  • #201868 - ArgumentException raised while retrieving UsedRange for binary file is fixed.
  • #201968 - Issue while setting formula with IF function is fixed.
  • #200818 - File gets corrupted while setting numeric value for named ranges is resolved.
  • #201967 - Issue with percentage values in chart is fixed.
  • #201618, #202220 - NullReferenceException while converting the worksheet to image with particular number format is resolved.
  • #201685 - Exception with the large category axis labels in chart to image conversion is fixed.
  • #201131 - Formula value is incorrect while parsing the workbook is fixed.
  • #201140 - Performance issue while opening Excel file with charts is fixed.
  • #200629 - Need to skip the exception for null values in template marker.
  • #199992, #202778, #202886 - Issue with invalid formula in OfficeChart is fixed.
  • #201506 - Memory leak issue in OfficeChart is resolved.
  • #204215 - Empty chart with date time category axis can be converted to image without any argument exception.
  • #203971 - Issue with OLE object type of Acrobat document is fixed.
  • #203970 - Picture associated with OLE object is rendered properly in Excel to PDF conversion.
  • #203402 - RTF text is rendered properly in Worksheet to Image conversion for the framework 4.0.
  • #203204 - Exception thrown while setting negative values to shape properties is resolved.
  • #202589 - Issue with Picture property of OLE object is fixed.
  • Corruption issue is resolved while copying tables with same name by AddCopy().
  • Performance issue while copying entire column to another range is resolved.
  • Conditional formats are removed from destination range while copying is fixed.
  • Worksheet unused columns are not collapsed in Google Sheets.
  • Exception is no longer thrown while copying tables to existing table ranges.
  • Issue with visibility of zero or negative size values for bubble chart data points in chart to image conversion is fixed.
  • The data points are set with possible ways of display blank as option in chart to image conversion.
  • Exception while opening Excel file with DDE link formula is resolved.
  • Fixed various issues in CopyTo() and AddCopy() of tables, formulae, ranges, shapes and worksheets.
  • AutoShapes are not re-positioned properly after moving to same or different worksheet using CopyTo() is fixed.
  • Issue with incorrect table formula value is fixed.
  • Chart line colors are not varied and are returned properly.
  • Issue with left and top positions for Checkbox is returned is fixed.
  • Chart category axis value is proper while creating a chart with data values containing formula.
  • Null reference exception thrown while setting “BASE” formula is resolved.
  • Worksheet data is exported to data table with proper column name.
  • Exception thrown while opening a workbook having unused formats with ParseWorksheetsOnDemand is resolved.
  • Exception thrown while converting a chart with date axis to image is resolved.