Essential Studio for WPF Release Notes

v17.3.0.9
September 20, 2019

AutoComplete

Bug fixes

  • #238191 - Suggestion box works properly when custom style is used in item template.

CalendarEdit

Bug fixes

  • #244892 - Blackout dates are cleared properly during runtime.
  • #218765,#221087,#239287 - SfSkinManager style is applied properly for CalendarEdit control while setting the style in the XAML.
  • #248229 - Blackout dates are not selected when select the dates by mouse dragging.

ComboBoxAdv

Features

  • Performance of the initial loading and scrolling of combobox dropdown have been improved.

CurrencyTextBox

Bug fixes

  • #243146 - values are updated and validated with proper decimal digits.

DateTimeEdit

Feature

  • A Support has been provided to show customized calender and clock control.

Behavior changes

  • Only editable field can be selected in DateTimeEdit when mask mode is enabled.
  • When editing in mask mode, field focus will be automatically navigated when value of the selected filed in filled.
  • When editing in mask mode, field focus will be automatically navigated when space or next filed character is given.
  • When editing in mask mode, DateTimeEdit value will be validated and corrected immediately.

DocIO

Features

  • #237184 - Provided support to preserve the Ole Equation as Bitmap in Word to PDF conversion.
  • #105883 , #134917, #170211, #239966, #244366, #F146503 - Provided support to create and apply custom table styles in a Word document.
  • #94996, #F116887, #137337, #137532, #147886, #159260, #163472, #182382, #183354, #140858, #197030, #199916, #201860, #212424, #232214, #234693 - Provided support to shape and Text box rotation in DOCX , Word to PDF and Word to image conversion.

Bug Fixes

  • #241691 - The ArgumentOutOfRangeException will no longer be thrown while opening a DOC format Word document.
  • #240393 - Line numbers are now preserved properly when resaving the Word document.
  • #242018 - Text encoding issue has been resolved while opening a RTF format Word document.
  • #241885 - Line spacing is now preserved properly while converting a Word document into HTML.
  • #F143774 - Paragraphs are now preserved properly while performing horizontal cell merge in a Word document.
  • #241475 - Nested IF field result is now preserved properly while converting a Word document as a Text file.
  • #237339 - ActualFormatType is now considered as DOCX when creating a new Word document from scratch.
  • #239792 - Character format is applied properly in Inline content control while opening Word document.
  • #239895 - The NullReferenceException will no longer be thrown when updating the fields in the Word document.
  • #239579 - Text border is preserved properly when converting HTML to Word document.
  • #238722 - Character format is applied properly while updating document fields.
  • #F143772 - Nested bookmark is now preserved properly while opening a DOC format Word document.
  • #225399, #220198, #209881, #209466, #204167 - RTL text alignment and indent issues has been resolved while converting a Word document to PDF.
  • #242278, #241397, #240195, #240030, #239658, #238960, #238709, #238528, #237804, #245011, #217699 - Hanging issue has been resolved while converting a Word document to PDF.
  • #243412 - Tab leader is now preserved properly while converting a Word document to PDF.
  • #239746, #238528 - Text is now preserved properly while converting a Word document to PDF.
  • #226594 - Underline is now preserved properly while converting a Word document to PDF in fast rendering.
  • #242601 - Font is now preserved properly while converting a Word document to PDF.
  • #242252 - TOC text color is now drawn properly while converting a Word document to PDF.
  • #239895, #240393, #226352 - Paragraph is now preserved properly while converting a Word document to PDF.
  • #230817, #240393 - Shape is now preserved properly while converting a Word document to PDF.
  • #240393 - Spacing issue has been resolved while converting a Word document to PDF.
  • #238528 - Blank page preservation issue has been resolved while converting a Word document to PDF.
  • #238528 - Table is now preserved properly while converting a Word document to PDF.
  • #240393, #239828 - The IndexOutOfRangeException will no longer be thrown while converting the Word document to PDF.
  • #239439 - Vertical text fill color is now drawn properly while converting a Word document to PDF.
  • #237804 - Tab is now preserved properly while converting a Word document to PDF.
  • #239439 - Text box is now preserved properly while converting a Word document to PDF.
  • #238072 - Horizontally merged table cell border is now preserved properly while converting a Word document to PDF.
  • #244161 - Table is now preserved properly while converting a Word document to PDF.
  • #242252 - Macro button field result is now preserved properly while converting a Word document to PDF.
  • #244161 – The NullReferenceException will no longer be thrown while converting a Word document to Image.
  • #243494 - Bookmarks are now preserved properly while converting a Word document to PDF.
  • #245094 - The paragraph style name is now preserved properly in the StyleName property while parsing RTF format document.
  • #240020 - Images and tables are now preserved properly in HTML export when the system scaling value is other than 100%.
  • #237184, #131175 - Child shape line weight is now preserved properly while converting a Word document to PDF.
  • #237184 - Rounded rectangle shape is now preserved properly while converting a Word document to PDF.
  • #245656 - The ArgumentOutOfRangeException will no longer be thrown while opening a DOC format Word document.
  • #245313 - Text is now preserved properly while converting a Word document into PDF.
  • #239089, #246062 - The ArgumentOutOfRangeException will no longer be thrown while replacing bookmark content in Word document.
  • #244946 - Font name is now updated properly while applying character format to the text range in Word document.
  • #244919 - The IndexOutOfBoundsException will no longer be thrown while updating document fields.
  • #244241 - Argument is not image byte array exception will no longer be thrown while updating alternate chunk.
  • #243623 - Bold is now preserved properly while converting HTML into a Word document.
  • #243595 - Negative values are now preserved properly while performing mail merge in a Word document.
  • #241184 - Image is preserved properly in content control when open and save the word document.
  • #F145109, #246061 - Bookmark contents are now replaced properly with the ReplaceBookmarkContent API.
  • #238451 - Underline is preserved in RTF to HTML conversion.
  • #F145124 - Hanging will no longer occur while deleting a bookmark contents.
  • List value is now updated properly when converting a Word document to HTML.

DockingManager

Bug fixes

  • #138365 - Provided support to change the size of side panel in DockingManager.
  • #245854 - In AutoHidden windows,resizing the window is restricted by DesiredMinWidthInDockMode,DesiredMaxWidthInDockMode,DesiredMaxHeightInDockMode and DesiredMinHeightInDockMode properties.

Behaviour Changes

  • #173289 - Now we can move the docking window to document state, when CanDocument as true while CanDock as false.
  • #123711 - A floating window can be maximized or set to dock state when header is double-clicked.
  • Document tabs can be reordered or floated simultaneously, when the property IsVS2010DraggingEnabled is true.
  • Auto hidden panels can now be moved to dock, float, or document state using the context menu.
  • The UI of an individual child header can be customized.
  • The size of a side panel can now be customized.

DoubleTextBox

Bug fixes

  • #246671 - Values are updated properly when negative sign is included and MaxDecimalDigits value is set.
  • #240772,#242556 - Binding value is updated properly based on NumberOfDecimalDigit of DoubleTextBox.

EditControl

Bug fixes

  • #240604 - EditControl cursor location is updated properly while using SelectLines method.

GridControl

Bug Fixes

  • #244487 – The ArgumentOutOfRangeException will no longer be thrown when clearing the rows and ComboBox cell that has focus.

pdf

Features

  • #216603 - Added support for enhanced electronics signature ETSI CAdES.
  • #218411, 223453, F141588 - Added support for validating digital signatures in existing PDF document.
  • #187514, 182262, 153360, 103910 - Added support for finding the corrupted PDF document.
  • #233393 - Added support for setting LeaderOffset, EndLineStyle, and BeginLineStyle in PdfLineMeasureAnnotation.
  • #232955 - Added support for processing PDF, which contains encryption only for attachments in PDF.
  • #236552 - Added support for finding the header row using event handler.

Breaking Changes

  • Line ending styles default value has been changed to None from Square.

Bug Fixes

  • #245618 - The ArgumentOutOfRangeException will no longer occur when saving the existing PDF document.
  • #245433 - Characters with super script will be preserved properly when rendering with Thai font.
  • #246397 - Document save performance with the SaveProgress event has been improved.
  • #237184 - Preservation and hanging issue will no longer occur when converting Word to PDF.
  • #244577 - PdfDocumentLinkAnnotation destination will be updated properly with provided X and Y position.
  • #244143 - Adjacent character removal in text redaction has been resolved.
  • #244220 - Logo image will be preserved properly in EMF to PDF conversion.
  • #242068 - Meta file will be rendered properly in EMF to PDF conversion.
  • #241580 - Tiling brush will be rendered properly in XPS to PDF conversion.
  • #243529 - Barcode will no longer have any extra blank space when rendering.
  • #246019 - Hanging issue will no longer occur when converting a Word document to PDF.
  • #244245 - Text and Icon values of PdfLoadedPopupAnnotation will be retrieved properly.
  • #240456 – The NullReferenceException will no longer be thrown when merging the particular documents.
  • #241481 – Free text annotation will no longer return invalid text.
  • #242049 – PdfAnnotation will be cleared properly while removing the annotations.
  • #238304 – Font name will be retrieved properly from the PdfLoadedAnnotation.
  • #239222, #239219 – Radio button page will be null if it is not added in the page.
  • #238725 – Inserting long text in PdfLightTable cell works properly.
  • #238603 – 3D annotations will be rendered properly with different Pdf3DRendermode.
  • #238517 – PdfFreeTextAnnotation color will be preserved properly.
  • #242310 – Signature information will be rendered properly when applying security.
  • #244368 – Radio button will be added to the existing PDF documents.
  • #242644 – Symbols will be encoded properly in Code 39 Extended and Code 93 Extended barcodes.
  • #242717 – PdfLayoutResult will return proper bounds when enabling auto tag.
  • #243273 – Radio button field will be flattened properly in all PDF pages.
  • #242335 – Text will be rendered properly when filling and flattening text with right alignment.
  • #241159 – Code 32 barcode is now preserved properly for the input text containing zero.
  • #238715 – Text will be rendered properly when converting a particular Word document to PDF.
  • #241580 – Tilling brush will be rendered in proper location on XPS to PDF conversion.
  • #241002 – The PDF document will no longer be corrupted when converting EMF to PDF.
  • #238709 – System out of memory exception will no longer be thrown when converting a Word document to PDF.
  • #F144285 - Signature bounds will be retrieved properly from the existing PDF document.
  • #F145476 – Content inside the child grid will be wrapped properly.
  • #F145826 – Barcode will be generated properly with PdfCode93Barcode.
  • Added appearance stream for different style radio buttons.
  • Text size will be calculated based on the text box field height if it does not have font or size.
  • Underline will no longer be added for trailing white spaces when drawing text.
  • Fore color will be retrieved properly from the text box field.
  • PdfSignatureField name will be preserved properly.
  • Font size of the form field will be calculated based on the field size.

PdfViewerControl

Features

  • #92000, #238304, #239619 – Support for sticky notes annotation has been provided.
  • #170470, #189529, #238304, #239619 – Support for polygon shape has been provided.
  • #238304, #239619 – Support for polyline shape has been provided.
  • #238304, #239619 – Support for arrow shape has been provided.
  • #166491, #242222 – Support for saving a document with the same name and in the same path has been provided.
  • #238645 – Exposed the ItemSource API in PdfDocumentView to bind PDF documents from XAML.
  • #239509 – Exposed the MarkRegions method to mark the redaction regions from code.
  • #239042 - Support has been provided to show or hide the form data icon from the left pane using FormSettings.
  • #238304 - Support has been provided to load the custom stamp from external objects.
  • #236632 - Support has been provided for finding text in a specific page using the PdfLoadedDocument.

Bug Fixes

  • #233751 – The PDF document is now unloaded when setting null to the ItemSource property.
  • #239670 – Rotated text box fields are now rendered properly.
  • #241118 – System.AccessViolationException is no longer thrown when loading a PDF document multiple times.
  • #239042 – Visibility of the left pane is now handled properly.
  • #242223 – The PDF documents are now displayed properly in Windows Applications Packaging projects using the PdfViewerControl.
  • #242365 – The PDF documents will no longer take more time to load in the control.
  • #241395 – Scrolling through the pages is now working properly.
  • #241395 – Fit to page magnification is now working properly.
  • #240160 – Text is now extracted properly from the PDF document using the PdfLoadedDocument.
  • #241161 – Text bounds are now obtained properly from the FindText method of the PdfLoadedDocument.
  • # 243979 – Line shape is now selected properly.
  • #F146459 – Initial loading time of PDF Viewer is now optimized when the GoToPage API is called.

PivotGridControl

Bug fixes

  • #238322 - The DateTime values are returned properly from PivotEngine.

Presentation

Features

  • #F145218 - Provided support to insert the slide with PasteOptions in PowerPoint document.
  • #238015 - Added the Font stream property in SubstituteFontEventArgs to set alternate font stream for missing fonts in device during Presentation to PDF/Image conversion.

Bug Fixes

  • #F145117 - Font size will be applied properly for second paragraph of table cell.
  • #243282 - Images are now preserved properly while performing clone and merge in PowerPoint presentation.
  • #237602 - Border will be preserved properly while saving the PowerPoint presentation.
  • #237602 - The NullReferenceException will no longer be thrown while opening the PowerPoint presentation.

ProgressBar Preview

The progressbar control provides a customizable visual to indicate the progress of a task.

Key features

  • Visualizes the progress in different shapes, such as rectangle and circle.
  • Determinate shows a specific amount of progress and indeterminate shows redundant animations of progress.
  • Customize ranges with different colors inside the progress bar.
  • Visualizes the progress in segments.
  • Displays the custom content at the center of the circular progress bar.
  • Customizes the angle of the circular progress bar.

PropertyGrid

Features

  • #92983, #155062, #128688, #185490, #200037, #98920, #100790, #105852, #107380, #85786, #104429, #222160 – Support has been provided to order the property item of the PropertyGrid, based on the value specified in the DisplayAttribute, when SortDirection is null.
  • #176993 – Now you can specify CustomEditor using EditorAttribute on selected object.
  • #157499, #98921 – CategoryViewItems can be collapse or expand programmatically using CollapseCategory and ExpandCategory methods of PropertyGrid.
  • #229840 – Keyboard navigation support has been provided to perform navigation between PropertyItems of PropertyGrid.

Breaking Changes

  • Type of the SortDirection property has been changed as Nullable type, to support custom ordering of property items in PropertyGrid.

Ribbon

Features

  • #123106 - Support has been provided to re arrange the Gallery items based on the available size on resizing the window.
  • #216916 - Implemented selection changing event in Ribbon tab.
  • #225834 - Support has been provided to add external items that do not present in Ribbon in quick panel.

Bug Fixes

  • #243629 - The Null reference exception will no longer be thrown, when the visibility of the title bar is collapsed.

SfDataGrid

Breaking Changes

  • The property type of NewObject property in AddNewRowInitiating event, RowData property in CurrentCellValidating, CurrentCellValidated, RowValidating, RowValidated and CurrentCellRequestNavigate events, Record property in CurrentCellValueChanged event will be retrieved as System.Data.DataRow instead of System.Data.DataRowView for built-in AddNewRow when binding DataTable if the AddNewRow is initialized.

Features

  • #242625 - Support has been provided to retrieve cell value, row count, and column count using helper methods in QTP.
  • Support has been provided to check box selector column to select the rows with unbound check box column.

Bug Fixes

  • #242355 - The RowDragAndDropController.Drop event is now triggering properly when drop the record in empty data grid from different control.
  • #F146420 - The ArgumentOutOfRangeException will no longer be thrown while dropping the record that is not present in the source collection.
  • #244980 - Custom size is now shown properly in PrintPreview dialog when setting the PrintPage size programmatically.
  • #245113 - The OldValue is now updated properly in CurrentCellValidating event when navigation is handled while editing the same value.
  • #241080 - Current cell moves properly from the right to left while pressing the Tab key with the FlowDirection as RightToLeft.

SfDiagram

Bug Fixes

  • #241345 - Existing group elements will be cleared automatically when Diagram.Groups is assigned with new GroupCollection.
  • #241316 - Connection will be created properly using the connector’s SourceNodeID and TargetNodeID properties for the nodes inside the group.
  • #241867 - The NullReferenceException will no longer be thrown while dragging a tab control, which holds the SfDiagram control along with the Overview control.
  • #242152 - The NullReferenceException will no longer be thrown in the Multiple-Parent layout while adding new item with no parents and no children to the datasource.
  • #242184 - On executing the FitToPage command, diagram content will now be placed at the center of the viewport if size of the content is less than the viewport.
  • #244954 - Invalid operation Exception will no longer be thrown when applying custom style to SfDiagram.FirstSelectionIndicatorStyle.
  • #244718 - Objects from the Stencil will be added properly to the diagram area when the diagram dependent assemblies are loaded dynamically.
  • #244883 - Symbols will be loaded properly in the Stencil while changing the theme.
  • #245596 - The NullReferenceException will no longer be thrown while executing Zoom command.
  • #244559 - The NullReferenceException will no longer be thrown while adding back the same NodeViewModel after removing it.
  • #245327 - The NullReferenceException will no longer be thrown while enabling back the gridlines after disabling it.
  • #245328 - SnapConstraints.SnapToLines will now work for rotated nodes if the node’s edges are in parallel to the gridlines.
  • #245722 - Selection will no longer be cleared while right-clicking over the resizer thumbs.
  • #238039 - Interaction will be smoother on reconnecting connector back to the NodeViewModel.

Features

  • #231046 - Added support to choose between list of installed printers in the Print Preview window.
  • #226329 - Added support to notify the Print Preview window closing action using the PrintStatus.Cancelled in OnPrintingEvent.
  • Added support to perform advanced printing options to print a custom range of pages. Also, provided support to define number of copies and option to print the copies collated.

Behavior Changes

  • Selection will no longer be cleared while right-clicking over the resizer thumbs.
  • Print preview window will no longer have separate Quick Print button to perform quick printing, which is now possible with Print button itself.

SfGantt

Bug fixes

  • #239856 – Node has been added properly when adding inline item to Empty Resource Collection dynamically.

SfImageEditor Preview

SfImageEditor is a very handy tool that is used to edit an image by annotating a text and built-in shapes. It allows you to crop, rotate, and flip an image. It has a built-in toolbar, which helps perform editing operations.

Key Features

  • Built-in toolbar
  • Flip
  • Crop
  • Rotate
  • Support to add shapes like rectangle, circle, and arrow.
  • Annotating a text.
  • Support to save edited images.
  • Zooming and panning.
  • Undo, redo
  • Reset

SfMaskedEditBox

Bug fixes

  • #146471 - Values are added after setting null value to the Value property.
  • #145485,#240309 - SfMaskEdit Text is cleared properly while resetting the Text.

Feature

  • #240944 - Improved optional mask behavior in SfMaskedEdit.
  • #137287 - Feature on adding the Cut, Copy, Paste Event handlers to the SfMaskedEdi.

SfRichTextBoxAdv

Features

  • #243464 - Added OptimizeRtfFileSize property in ExportSettings class to reduce the resultant file size while saving the document as RTF.
  • #239227 - Provided support to preserve the empty cell mark paragraph after nested table with zero height (hidden), like Microsoft Word.

Bug Fixes

  • #241353 - Table cell shading is now rendered properly.
  • #243443 - Remove hyperlink option now works properly after opening HTML file with hyperlink.
  • #241663 - Right border of a vertical merged cell is now rendered properly.
  • #237410 - Null reference exception will no longer be thrown on disposing SfRichTextBoxAdv control after printing the document without adding the control to UI.
  • #237401 - Text inside table cell with shading is now visible while printing.
  • #239574 - Exception will no longer be thrown while performing select all (Ctrl + A) and delete contents using backspace key.
  • #244036 - No extra spaces added before the hyperlink display text while opening HTML file with hyperlink.
  • #239881 - Exception will no longer be thrown when height of table in header footer is greater than page height.
  • #241989 - Exception will no longer be thrown on disposing the previous document while opening document.
  • #238842 - The viewer is now properly interactive without scrolling to selected content while zooming.
  • #233913, #236783, #239205 - Merged cells in a table is now displayed with proper width.
  • #F144842 - Superscript text are now properly positioned at the top of a line.
  • #240669, #237042, #239300, #239879 - The nested tables with row properties header row, at least height type, allow break across pages are now rendered properly.
  • #238489 - The cell contents of nested table are now rendered properly based on its vertical alignment.
  • #245094, #246281 - Font family and font size of the text is now preserved properly after performing copy and paste operation.
  • #246146 - Field structure is preserved properly while deleting the hyperlink text.
  • #246169 - Exception will no longer be thrown while copying text (Ctrl + C) after exporting the document as HTML.

SfSchedule

Features

  • /#244420, /#241823 - Provided the ReminderFormActionChanged event support to handle the appointment with following actions.

    • Dismiss
    • DismissAll
    • Snooze
  • Provided the RecurrenceExceptionDates support to delete any occurrence appointment which is exception from the recurrence pattern appointment by adding exception dates to the recurring appointment.

Bug fixes

  • #F146684 - Control works properly after the Schedule type is set to Month.

SfTextBoxExt

Features

  • The TextHighlightMode support has been provided to highlight the matching characters in a suggestion list to pick an item with more clarity.
  • The IgnoreDiacritic support has been provided for populating items from a language with letters containing diacritics and searching for them with English characters from an en-US keyboard.

SfTreeGrid

Features

  • #233109 - Support has been provided to sort the indexer column.

SyntaxEditor

Features

  • #162604, #162523 - Support has been provided to insert text at the required place in SyntaxEditor.
  • #240672 - The tab indentation support has been provided in SyntaxEditor.

Bug fixes

  • #F146193 - The outlining blocks will be updated properly while inserting the text programmatically.
  • #244781 - Now, the nested IntelliSense works properly in SyntaxEditor.
  • #240604 - The cursor location will be updated properly while using the SelectLines method.

TabControlExt

Behavior changes

  • When a tab items is removed, selected index will retain the same instead of resetting it to zero.

ThemeStudio

Bug Fixes

  • #244269 – Themes will be applied properly for SfDiagram’s QuickCommand and DiagramThumb in Theme Studio.
  • #243329 - Blend theme is applied properly for MS controls like Label, Text block and Window when exported.

Toolbox-Configuration

Features

Added the controls into Visual Studio Toolbox using the Syncfusion NuGet packages.

SfTreeMap

Bug fixes

  • #245352 - Memory size is not increased when using Treemap with large data.

TreeViewAdv

Bug fixes

  • #243836 - Now, the TreeViewAdv scroll bar is updated properly while scrolling.

XlsIO

Features

  • #238012 - Warning capture is implemented in Excel to PDF conversion.
  • #238012 - Unsupported font is now substituted by a font stream in Excel to PDF conversion.
  • #238385 - Exporting Excel data to nested class is now supported.
  • #F144806 - Boolean to include column headers is now provided as an overload to the ImportDataTable() method with ImportOnSave option.
  • Bindable attribute is implemented to skip a property on importing data from a collection.
  • Importing data from nested collection to Excel is now supported.

Breaking Changes

  • #238012 - IWarning interface is added to represent the warning details of unsupported and substituted elements.
  • #238012 - ShowWarning() method is added in IWarning class to show warning in the workbook.
  • #238012 - Cancel property in IWarning class gets or sets a boolean value to cancel the current process.
  • #238012 - Warning property is added in ExcelToPdfConverterSettings class to get warning detail in Excel to PDF conversion.
  • #238012 - WarningInfo class is added to represent the warning details with type and description.
  • #238012 - Description property is implemented in WarningInfo class to get description of the warning.
  • #238012 - Type property is implemented in WarningInfo class to get the type of the warning.
  • #238012 - WarningType enum is added to specify the type for the specific warning.
  • #238012 - AlternateFontStream property in SubstituteFontEventArgs class gets or sets the alternate font stream.
  • #238385 - ExportData<T>() method is added in IWorksheet, WorksheetImpl, ExternWorksheetImpl and WorksheetGroup classes to export worksheet data into the collection of CLR objects.
  • #F144806 - ImportDataTable() method is added as an overload in WorksheetImpl, WorksheetGroup and ExternWorksheetImpl classes with a boolean to include column headers.
  • BindableAttribute() constructor in BindableAttribute class initializes a new instance that indicates whether a property is bindable.
  • Bindable property in BindableAttribute class specifies the bindable attribute for a property.
  • ImportData() method is added in IWorksheet, WorksheetImpl, ExternWorksheetImpl and WorksheetGroup classes to import data from class objects to a worksheet.
  • ExcelNestedDataLayoutOptions enum in enums class specifies how to fill the group field values while importing nested collection CLR objects.
  • ExcelNestedDataGroupOptions enum in enums class specifies whether the grouping is added with Collapse or Expand while importing nested collection CLR objects.
  • ExcelImportDataOptions class is added in IWorksheet class to specify import data options.
  • FirstRow property in ExcelImportDataOptions class specifies first row from where the data should be imported.
  • FirstColumn property in ExcelImportDataOptions class specifies first column from where the data should be imported.
  • IncludeHeader property in ExcelImportDataOptions class specifies whether class properties names must be imported or not.
  • IncludeHeaderParent property in ExcelImportDataOptions class specifies whether parent class properties names must be imported or not.
  • NestedDataLayoutOptions property in ExcelImportDataOptions class specifies how to fill the group field values while importing nested collection objects.
  • NestedDataGroupOptions property in ExcelImportDataOptions class specifies whether the grouping is added with Collapse or Expand while importing nested collection objects.
  • CollapseLevel property in ExcelImportDataOptions class specifies the group collapse level.

Bug Fixes

  • #230042, #231663 - Number and date time values are now rendered properly in Excel to PDF conversion.
  • #237114, #237576 - Line shapes are now rendered properly when converting Excel to PDF.
  • #244941, #245083 - Custom properties are now preserved properly on resaving the Excel document.
  • #240083 - Number alignment is now proper in Excel to PDF conversion.
  • #235971 - Chart series type is now preserved properly while saving the workbook with combination chart.
  • #240200 - Pivot table background color is now preserved properly while resaving the Excel document.
  • #240677 - Pivot chart is now preserved properly while resaving the Excel document.
  • #240083 - Chart data points will no longer be missed when converting Excel to PDF.
  • #239969 - Argument exception will no longer be thrown on opening the Excel file containing external workbook.
  • #230937 - Excel document is now converted properly while using the OFFSET function.
  • #236370 - DateTime value is now returned correctly in UK culture.
  • #238322 - Pivot table row header is now preserved properly when converting Excel to PDF.
  • #236131 - PivotTable will no longer be crashed on refreshing the resaved Excel file.
  • #239384 - Performance delay will no longer occur while resaving the Excel document.
  • #237809 - Conditional format formula for specific text is now updated properly while copying cells.
  • #236873 - DisplayText is now returned correctly when accessing the date time using formula with DDDD number format.
  • #238626 - Creating table with invalid table name will throw an exception.
  • #236136 - PercentOfParent option is now set correctly while creating a pivot table.
  • #237114 - AutoShape text is now rendered properly when converting Excel to PDF.
  • #239217 - Cell text with lesser than and greater than symbols are now preserved properly when converting the worksheet to HTML.
  • #236197 - Time value is now set correctly for 1904 enabled workbook.
  • #241751 - Checkboxes are now checked properly after resaving the Excel document.
  • #238322 - Grand totals of rows and columns are now preserved properly in Excel to PDF conversion.
  • #241336 - Excel document containing conditional formats will no longer be corrupted on inserting a row.
  • #237235 - Legend is now preserved properly on setting custom data label.
  • #240083 - Chart data point will no longer be missed when converting Excel to PDF.
  • #242245 - Performance has been improved while opening the SpreadsheetXML file.
  • #241403 - Vertical text alignment now works properly in Excel to PDF conversion.
  • #242613 - Japanese characters are now preserved properly in Excel to PDF conversion.
  • #242913 - Font name and font size will no longer be changed while opening the Excel document.
  • #244193 - Exception will no longer be thrown on converting the Excel document with date time to PDF.
  • #239659 - Checkbox when removed is now preserved properly.
  • #226622 - Cell value is now updated properly while coping a range from source to destination.
  • #239384 - Performance is improved while converting Excel document into PDF with conditional formatting.
  • #244535 - Filter applied columns are now auto-fitted properly.
  • #243110 - Code name is now preserved properly for XLSX files.
  • #242235 - Alternative text for chart shape is now preserved properly on resaving the Excel document.
  • #245833 - Worksheet with autoshapes is now cloned properly.
  • #243737 - Conditional format styles are now copied properly while applying marker with jump arguments.
  • #240083 - Conditional format formula is now calculated correctly in Excel to PDF conversion.
  • #244284 - Table formatting issues will no longer occur on resaving the Excel file.
  • #F144906 - Active worksheet is now unselected when multiple worksheets are selected in the Excel file.
  • #F145816 - Exception will no longer be thrown on saving the workbook after invoking IApplication.IsSupported() method.
  • #F146576 - Cell with indentation will no longer be missed in worksheet to image conversion.
  • Exception will no longer be thrown when getting intersect range from invalid named ranges.
  • Saving the input document as xlsx file after saving it as xml document will no longer be corrupted.
  • CalcEngine will no longer be reinitialized after performing Excel to PDF conversion.
  • Legend text color is now preserved properly on saving the Excel document.
  • Chart is now preserved properly on copying the worksheet using the AddCopy() method.
  • Output Excel file will no longer be corrupted when an empty pivot table is updated with data and saved using XlsIO.
  • Exception will no longer be thrown while using named range for page setup in XlsIO.
  • Formula is now correct on resaving the Excel document containing formula with external workbook reference.
  • Exception will no longer be thrown while converting the Excel document to PDF after resave.