Essential Studio for WPF Release Notes

v17.4.0.39
December 17, 2019

CalendarEdit

Features

  • Improved the Keyboard interaction for CalendarEdit
  • Accessibility support has been provided to CalenderEdit

CheckListBox

Features

  • #250891 - Provided ItemChecked event to notify when CheckListBox items are checked / unchecked.

Bug Fixes

  • #251567 - Built-In grouping and sorting feature will no more break default filtering, sorting and grouping operations.
  • #251405 - SelectedValuePath and SelectedValue property will now function properly.
  • #250591, #251405 -The DisplayMemberPath property in the CheckListBox will work properly.
  • #254137 - The checkbox will now be shown in CheckListBox when items are added to the CheckListBox item collection.

ChromelessWindow

Features

  • #220354, #179829 - Support has been provided to add custom controls in the left and right sides of ChromelessWindow.

Bug fixes

  • Window position now updates properly while changing the maximized state to the normal state in Chromeless Window.

ColorPicker

Behaviour change

Color Editor UI has improved in such a way that it feels logical and intuitive.Provided VS like Gradient Editor Structure, to make editing easier.

ComboBoxAdv

Bug fixes

  • #253446 – ComboBoxAdv data will be displayed properly while binding the attribute of the property.

DateTimeEdit

Features

  • Provided support to update the current Time value along with Date, when clicking Today button.
  • Provided Keyboard navigation support for DateTimeEdit Calendar control.
  • Improved the behavior of black-out dates
  • Provided navigation keyboard support to open and close pop-ups using shortcut keys

DocIO

Features

  • #65714, #66953, #85228, #171046, #F139709, #245097 - Added support for mathematical equations (MathML) in Word documents (DOCX and WordML).
  • #73803, #88325, #89142, #97223, #100048, #103105, #105507, #177795 - Added support to automatically resize the table to fit its content.
  • #F145606, #175965, #199216, #236159, #250497, #250237 -API has been added to change data source path and remove mail merge settings from a Word document (DOCX).

Bug Fixes

  • #256141, #247556 - The NullReferenceException will no longer be thrown while opening the DOCX format Word document.
  • #255070 - Grid after values of the table rows will be preserved properly while loading the RTF document.
  • #255039, #245828 - The ArgumentException will no longer be thrown while saving the Word document.
  • #254719 - Text will be preserved properly when open and save the DOCX format Word document.
  • #254399 - The IndexOutOfRangeException will no longer be thrown while opening the Word document.
  • #254157 - Shape in text box is now preserved properly while saving the DOCX format Word document.
  • #253773, #252275 - The ArgumentOutOfRangeException will no longer be thrown while opening the DOCX format Word document.
  • #252537 - SVG images are now preserved properly when open and save the DOCX format Word document.
  • #253232 - List style is now preserved properly when open and save the Word document.
  • #253082 - The NullReferenceException will no longer be thrown while merging the DOCX format Word documents.
  • #252912, #249887 - Bookmark contents are now replaced properly while replacing the bookmark content in the Word document.
  • #251861 - Paragraph style is now preserved properly when open and save the Word document.
  • #251545 - Mapped content in content control is now preserved properly when open and save the DOCX format Word document.
  • #250506 - The NullReferenceException will no longer be thrown while inserting text into the bookmark in the Word document.
  • #250227 - The StackOverFlowException will no longer be thrown while opening the DOC format Word document.
  • #246574 - Date time is now preserved properly while converting a DOCX format Word document to PDF.
  • #F149304 - Header/Footer contents will not be duplicated when the LinkToPrevious is modified.
  • #255069 - Watermark layout will be preserved properly while initializing the values using constructor.
  • #255509 - The ArgumentOutOfRangeException will no longer be thrown while getting the text from the Word document.
  • #253507 - Paragraph spacing will be preserved properly while converting the Word document to PDF.
  • #252379 - The text form field is now updated properly while saving the Word document.
  • #252217 - AutoshapeType is now read properly for VML structure text box in the Word document.
  • #252217 - AllowOverlap is now read properly for VML structure shapes and group shape in the Word document.
  • #F148303 - Text inside a group shape is now searched and replaced properly.
  • Document compatibility will be preserved properly while resaving the Word document
  • #250497 - IF field is updated properly when using updateDocumentFields in the Word document.
  • #250993 - The ArgumentOutOfRangeException will no longer be thrown while cloning the Word document.
  • The NullReferenceException will no longer be thrown while cloning the Word document.
  • #F147804, I250466 - The Hyperlink field is now updated properly in the Word document.
  • #250408, #253433, #251662 - The ArgumentException will be no longer thrown while opening the Word document.
  • #250042, #255301, #256507 - Styles template is now preserved properly when open and save the DOCX format Word document.
  • #249158 - Hanging issue has been resolved while opening a Word document.
  • #248402 - The Corruption issue has been resolved while saving the DOCX format Word document.
  • #247383, #F148303 - The InvalidOperationException will be no longer thrown while cloning a Word document.
  • #248409 - Section break is now preserved properly in Word to EPUB conversion.
  • #248400 - Corruption issue has been resolved while saving the DOCX format Word document.
  • #248024 - Text is now preserved properly while retrieving bookmark content from a Word document using the GetBookmarkContent API.
  • #239792 - Content control mapped text is preserved properly in Word to PDF conversion.
  • #246022 - The list is now preserved properly when show the track changes in the generated Word document.
  • #247034 - Watermark is now preserved properly while saving the DOC format Word document.
  • #199319 - Improved the stability by resolving a possible NullReferenceException of Word to PDF conversion.
  • #250884 - Cleared the memory leakage during Word to PDF conversion.
  • #251858 - Text in a rotated TextBox is now preserved properly while converting a Word document to PDF.
  • #250815 - Table cell is now preserved properly while converting a Word document to PDF.
  • #250550 - Footer content is now preserved properly while converting a Word document to PDF.
  • #249809, #252063 - Text is aligned properly while converting a Word document to PDF.
  • #249288, #247991, #251298, #246790 - Table content is now preserved properly while converting a Word document to PDF.
  • #249004 - Border is now preserved properly while converting a Word document to PDF.
  • #249004 - Autofit textbox is now preserved properly while converting a Word document to PDF.
  • #247476 - The NullReferenceException will no longer be thrown while converting the Word document to PDF.
  • #247391, #256090, #F149111, #253512 - Hanging issue has been resolved while converting a Word document to PDF.
  • #246790 - Blank page preservation issue has been resolved while converting a Word document to PDF.
  • #246771 - Header content is now preserved properly while converting a Word document to PDF.
  • #156982, #249734 - Blank page is now preserved properly while converting a Word document to PDF.
  • #F148161 - The ArgumentOutOfRangeException will no longer be thrown while converting a Word document to PDF.
  • #254893 - File size of resultant PDF document will be reduced while converting a Word document to PDF with AutoTag.
  • #255280 - Form field is now hidden properly while converting a Word document to PDF.
  • #252827, #253870, #252217 - Shapes are now properly preserved while converting a Word document to PDF.
  • #255040 - Text is now hyphenated properly while converting a Word document to PDF.
  • #254892 - Paragraph top border is now preserved properly while converting a Word document to PDF.
  • #254719 - White color text is now rendered properly while converting a Word document to PDF.
  • #254421 - Footnote text is now aligned properly while converting a Word document to PDF.
  • #252217, #F148303 - Text wrapping with group shape is now preserved properly while converting a Word document to PDF.
  • #F148303 - Group shapes are now preserved properly while converting a Word document to PDF.
  • #252063 - Unicode character is now preserved properly while converting a Word document to PDF.
  • #253870 - Picture is now preserved properly while converting a Word document to PDF.
  • #253521 - Bent and Curved connectors are now preserved properly while converting a Word document to PDF.
  • #253660 - Paragraph is now preserved properly while converting a Word document to PDF.
  • #252063 - Footnote text is now preserved properly while converting a Word document to PDF.
  • #252004 - Keep with next is now working properly while converting a Word document to PDF.
  • #252004 - Textbox is now preserved properly while converting a Word document to PDF.
  • #222803 - Picture in a group shape is now preserved properly while converting a Word document to PDF.
  • Table cell border is now preserved properly in the converted PDF document at different zooming levels.
  • Bookmark text is now preserved properly while converting a Word document to PDF.
  • Table cell is now preserved properly while converting a Word document to PDF.

DockingManager

Bug Fixes

  • #250283 - When the saved Read-Only file is loaded, the project will run properly without any exceptions.
  • #252814,254486 - Memory leak problem will no longer occur in DockingManager after the removal of child items from the children collection.

DocumentContainer

Bug Fixes

  • #250573 - By selecting or closing a document, the active document changed will work properly.
  • The Null reference exception will no longer be thrown in DocumentContainer when the project is closed while editing the value.

DoubleTextBox

Behaviour change

  • NumberOfDecimalDigits will no more have any effect, when MinimumNumberDecimalDigits or MaxNumberDecimalDigits is set. Instead, value that is displayed in DoubleTextBox will be dynamically updated without affecting NumberOfDecimalDigits property.

Gantt Control

Bug fixes

  • #250186 - ArgumentNullException will no longer be thrown when CustomScheduleSource is dynamically set as null.
  • #247811 - Striplines has been rendered properly while hiding weekends and Holidays.
  • #252846 – Holiday in one year will not be considered holiday in other years on the same day of the year.

GroupBar

Bug fixes

  • #252481 - SelectedObject property set is called properly while selecting GroupView Items.

OlapClient

Bug fixes

  • #252863 – Xaml parser exception will no longer be thrown while applying the style through SfSkinManager.

PDF

Features

  • #78702, #135996 - Added support for creating PDF A1A, A2A, A2U, A3A, and A3U conformance documents.
  • #241775 - Added support for XMP meta data for image in PDF document.
  • #178545, #192882, #194650, #247660 - Added support to remove identical resources while merging the PDF documents.
  • #252741 - Provided support for adding LTV externally in digital signature.
  • #249016 - Added support for ZUGFeRD 2.0 in PDF creation.
  • #246605 - Form fields will be removed when removing the pages from the PDF document.
  • #F148570 - Added support for validating digital signature based on the incremental updates.
  • #F148363 - Added support for setting SignedName when signing the PDF document.
  • Added support for custom position for Popup annotation.

Bug Fixes

  • #249904 – Ink annotation will be preserved properly with different ink points.
  • #255627 - XPS to PDF conversion will be preserved properly in any system resolution.
  • #253601 – The ArithmeticException no longer occurs when signing signature using timestamp server.
  • #254728, #255513 – Text will be preserved properly while flattening the forms.
  • #254691 – PDF document no longer corrupted while performing compression.
  • #254637 – Exception no longer occurs while appending PDF documents.
  • #254064 – Exception no longer occurs while getting used font in PdfLoadedDocument.
  • #253953 – Exception no longer occurs while signing the PDF document with store certificate.
  • #253988 – PdfGrid header with PdfHTMLElement will be repeated properly.
  • #253835 – The NullReferenceException no longer occurs if borders are null.
  • #253859 – The NullReferenceException no longer occurs while splitting the PDF document.
  • #254552 – Encrypted PDF can be opened by native PDF Viewer in iOS.
  • #253203 – LTV will be enabled while signing the PDF document.
  • #247373 – Form fields will be flattened properly in PdfLoadedDocument.
  • #249445 – Transparency will be preserved properly while drawing text to existing PDF document.
  • #254893 – File size has been optimized in Word to PDF conversion.
  • #245556 - PDF conformance will be validated properly in online tools.
  • #255666 - Font name will be retrieved properly from PdfFormFields.
  • #253952 – Exception no longer occurs when exporting PDF to Image.
  • #254234 – Adjacent characters will be preserved properly when redacting PDF contents.
  • #251673 – The NullReferenceException no longer occurs when filling the form fields.
  • #255336 – EncryptAllContentsExceptMetadata will work properly in 256bit encryption.
  • #249332 – The NullReferenceException will no longer occur when getting destination of PdfLoadedDocumentLinkAnnotation.
  • #251487 – Default document information from portfolio will be retrieved properly.
  • #250869 – Performance of PDF to PDF A1B converter has been improved.
  • #251103 – Merging will now preserve all the pages from source documents.
  • #249164 – Header style will be preserved properly in PdfLightTable.
  • #250644, #F147502 – Image will be preserved properly with signature appearance.
  • #248130 – Exception will no longer occur while selecting the bookmark items from existing PDF document.
  • #245556, #252556 – Conformance will be validated properly in particular site for the created conformance document.
  • #250878 – Exception will no longer occur while merging the particular document.
  • #249822 – The IndexOutOfRangeException will no longer occur while adding digital signature to the document.
  • #249904 – The PdfInkAnnotation will be preserved properly for two points.
  • #251928 – Date format will be preserved properly while flattening the XFA form field.
  • #250751 – Existing PDF document compression has been improved in file size.
  • #252156 – Characters will be preserved properly in XPS to PDF conversion.
  • #222803 – Lines will be preserved properly in EMF to PDF conversion.
  • #250380 – The NullReferenceException will no longer occur while importing pages from PDF document.
  • #250294 – The PDF document will no longer corrupted while loading and saving in same memory stream.
  • #247373 – Form fields will be flattened properly while merging the PDF documents.
  • #252063 – Images with color space will be preserved properly in PDF document.
  • #F148726 – The StackOverflow exception no longer occurs while finding corrupted document.
  • #F148569 – Exception no longer occurs while signing the PDF document using timestamp server.
  • Annotation color will be retrieved properly for FreeTextAnnotation.
  • FreeTextAnnotation content will be modified properly when changing the markup text.
  • Signature validation will be validated properly for modified PDF documents.

PdfViewerControl

Features

  • #107034, #124344, #164466, #165208 - Provided the support to extract words from a PDF file along with their bounds information.
  • #107034, #124344, #164466, #165208 - Provided the support to extract lines of text from a PDF file along with their bounds information.
  • #247419 - Provided the support to track the printing progress of a PDF document.
  • #246693 - Exposed the HandwrittenSignatureChanged event to track the changes made in handwritten signatures like add, move, resize, and delete.
  • #246693 - Provided the support to add handwritten signatures in the desired location from code behind.
  • #233156 - Provided the support to control the position of annotation popup notes.

Bug Fixes

  • #250371, #250312 – Text selection is now working properly for the particular PDF document.
  • #250869 – Euro symbol is now preserved properly in the extracted text from the PDF document.
  • #253952 - Images are now exported properly from the merged PDF documents.
  • #250374 - Images are now exported properly from the particular PDF document.
  • #251495 – Annotation related icons are now removed properly from the toolbar when setting the ShowAnnotationTools property to false.
  • #253151 – Orientation of the PDF document is now preserved properly when printing.
  • #249075 – The FitWidth mode of PdfDocumentView is now working properly when resizing the application.
  • #254068 - The Office2016Colorful theme is now applied properly for PdfViewerControl.

Presentation

Features

  • Exposed ScreenTip API to get and set the screen tip of IHyperLink.

Bug Fixes

  • #251612, #252515 - The NullReferenceException will no longer be thrown while saving the PowerPoint presentation.
  • #250068 - The ArgumentException will no longer be thrown while setting the column span as 1 for table cell.
  • #252605 - The ArgumentException will no longer be thrown while opening the PowerPoint presentation with ActiveX control.
  • #254235 - The FormatException will no longer be thrown while opening the PowerPoint presentation.
  • #251612 - The NullReferenceException will no longer be thrown while cloning the PowerPoint presentation.
  • #244971 - The PowerPoint presentation will no longer be corrupted while saving the document.
  • #250515, #251340, #251336, #254213 - The NullReferenceException will no longer be thrown while converting the PowerPoint to PDF.
  • #251850 - RTL text will be preserved properly while converting a PowerPoint Presentation to PDF.
  • #251849 - Parenthesis will be preserved properly while converting a PowerPoint presentation to PDF.
  • #253287 - RTL text will be aligned properly while converting a PowerPoint Presentation to PDF.
  • #250570 - Tab spaces will be aligned properly while converting a PowerPoint presentation to PDF.
  • #229361 - Gradient fill will be applied properly while converting a PowerPoint presentation to PDF.

PropertyGrid

Features

  • Provided the editors support for nullable DateTypes
  • Provided the editors support for missed DateTypes
  • Improved the behavior of CheckBoxEditor based on nullable and non-nullable DateTypes
  • Improved DateTimeEditor behaviors based on null and non-nullable DateTypes

Ribbon

Features

  • ContextMenu support has been implemented for RibbonGallery of the Ribbon control, similar to Microsoft Word.

Bug fixes

  • #254212 - RibbonWindow now properly updates while changing the theme.

SfBusyIndicator

Features

  • Six new busy indicator types has been provided and listed below.
    • BarChart.
    • DoubleRing.
    • DualRing.
    • Message.
    • Ripple.
    • Clock.

SfChart

Features

  • Now, The chart control supports the stacked line and 100% stacked line chart types.

SfCircularGauge

Bug Fixes

  • #256831 - Default view will be cleared properly when adding the scale dynamically.

SfDataGrid

Breaking Changes

  • Now, when editing a record in a group, the custom group comparer will be triggered properly. If the modified record is about to create a new group than the existing groups, there will be no records for the group retrieved in the custom comparer. The comparer must therefore be checked with null cases for Group.Records if the comparer is customized based on Group.Records.
  • New filtering options to filter data with “Does not begin with” and “Does not end with” in the Excel-like UI filter has been provided. So, the existing resx file for localization needs to be updated with current resx file from here.

Features

  • #214202, #241610, #242604 - Support has been provided to load template in summary rows (table, caption, and group summaries).
  • #F146788 - Support has been provided to position a row at the beginning or end of the DataGrid when a new row is added using built-in AddNewRow option.
  • #244258 - Support has been provided to filter data with “Does not begin with” and “Does not end with” options in the Excel-like UI filter.
  • #F127789, #177140 - Support has been provided to show a title summary and also column summary at the same time (table, caption, and group summaries).
  • Support has been provided to calculate the summary (table, caption, and group summary) for the selected records .
  • #215093 - Support has been provided to navigate the cells using keyboard without focusing the datagrid manually when row or cell is programmatically selected.

Bug Fixes

  • #252796 - The NullReferenceException will be no longer thrown when the column doesn’t have a mapping name and header text when the ColumnSizer is Auto.

SfDatePicker

Features

  • Improved the keyboard interaction support for SfDateSelector

SfDiagram

Bug Fixes

  • #250571 - The NullReferenceException will no longer be thrown while trying to retrieve objects using its ID in IGraphInfo.GetObject method.
  • #251686 - The NullReferenceException will no longer be thrown while trying to change the ParentId at runtime.
  • #253051 - The selector for collapsed node will no longer be visible while doing multiple selections.
  • #256293 - Appropriate cursor is now shown properly for the resizer thumbs when both ZoomPan and Select tool is in active.
  • #F148375 - The NullReferenceException will no longer be thrown while trying to set a parent for the node with empty ParentId.

Behavior Changes

  • Now, Syncfusion.UI.Xaml.Diagram.IExpandCollapseParameter.node is deprecated, so use Syncfusion.UI.Xaml.Diagram.IExpandCollapseParameter.Node.

SfLinearGauge

Bug fixes

  • #254042 - LabelFormat will be updated properly when changing dynamically.

SfMultiColumnDropDownControl

Behavior Changes

  • The default UI of the control has been changed for better look and feel.

Features

  • Support has been provided to select multiple rows by interacting with the check boxes in a column or within the rows. Users can also select all the rows using an intuitive check box in the header.
  • #215601 - Support has been provided to delay filtering or searching records in the drop-down when typing each character in the editor so that filtering won’t be applied for each character when you type quickly.

SfRangeSlider

Features

  • Custom ToolTip support has been provided to customize the tooltip in SfRangeSlider.
  • #234914 - Support to drag a selected range in SfRangeSlider has been provided.

SfRichTextBoxAdv

Features

  • #250693 - Added support to determine whether an image is selected in the RichTextBox control.
  • #249459 - Added ShowPageNumber property in LoadAsyncSettings class to show or hide page number while loading document asynchronously.
  • #248029 - Added support to apply cell formatting for all the cells when multiple cells are selected.
  • #225788 - Added LostFocusBehavior property in SfRichTextBoxAdv class to show the caret (blinking cursor) and highlight selection when the control lost focus.
  • #122923, #245158, #249959, #255797 - Added Background property in DocumentAdv class to modify the page background color of the document.

Bug Fixes

  • #246699, #251367- Selection format is now properly copied to following new paragraph on pressing enter key.
  • #248138 - Undo operation is now working properly for the backspace action.
  • #248134 - Stack overflow exception is no longer thrown while selecting all contents of a large document.
  • #249151 - HTML encoded characters are now mapped properly with its Unicode character while opening HTML.
  • #250691 - Text with automatic color are now printed properly in black color with page background white color, even if the page background is set as dark color.
  • #253944 - Shading is now applied properly to the table cells.
  • #238489 - The decent value is not added to the line height, if it does not contain text element.
  • #255613 - Undo and Redo operations are now working properly for style modification actions.

SfSchedule

Breaking Changes

  • Deleting recurrence popup will be occurred when try to delete the recurrence appointment to delete the recurrence or occurrence appointment.

Bug Fixes

  • #255476 - Appointment can cast in AppointmentEditorOpening event by binding object type.
  • #244420 – ReminderAppCollection returns the reminder appointments properly when binding the data object with recurrence.

SfTextBoxExt

Features

  • #227094 - Search performance in SfTextBoxExt has been improved.

SfTextInputLayout Preview

The new Text Input Layout control adds decorative elements like floating labels, icons and assistive labels on top of the WPF TextBox.

Key Features

  • Displays floating labels when the input view is focused.
  • Displays error labels.
  • Supports none, filled, and outlined container types.
  • Displays leading and trailing icons.
  • Displays helper labels.
  • Displays maximum character count.

SfTimePicker

Features

  • Improved the keyboard interaction support for SfTimeSelector

SplitButton

Bug fixes

  • #253994 - Mouse interaction now works properly in SplitButton borders when applying MetroStyle.

SfSurfaceChart

Features

  • #247594 - Provided the LabelFormat support for Legends.

  • #243482 - Provided the support for serialization.

Syntax Editor

Features

  • Provided the status bar support in Syntax Editor to show the file path, line number, column index and encoding type.
  • #173864 – Provided the single line mode behavior in Syntax Editor.

Bug fixes

  • #251212 - KeyNotFound Exception will no longer be thrown while using tab key in EditControl.

TabControlExt

Bug Fixes

  • #254799 – Opacity of disabled items is now updated correctly in TabControlExt while applying the SkinManager themes.

Theme Studio

Bug fixes

  • #251205 - Default section now shows properly in WPF Theme Studio when running on German OS.

TileView

Bug Fixes

  • #254124 – ScrollBar is now shown in the TileView control while applying the SkinManager themes.

TreeViewAdv

Bug fixes

  • #F149436 - Item will be properly selected while selecting through code.

XlsIO

Features

  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - The Excel VBA project is now supported.
  • The Top, bottom, above, and below rules in conditional formatting are now supported.
  • The Average(), Max(), Min(), Sum(), and Trim() methods in IRange are implemented.
  • Replace functionality is implemented for Range.

Breaking Changes

  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - VbaModuleType enum in VbaModuleType class specifies the Vba module type.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - IVbaModule interface is added for using Vba project module.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Name property in IVbaModule interface specifies the Vba module name.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Type property in IVbaModule interface indicates the Vba module type.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Code property in IVbaModule interface specifies the Vba code for the module.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - DesignerStorage property in IVbaModule interface specifies the Vba project form module storage.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - IVbaModules interface is added for accessing Vba project module collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Count property in IVbaModules interface specifies the number of Vba modules in the collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - IVbaModules[int index] property in IVbaModules interface gets the Vba module at the specified index in the collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - IVbaModules[string name] property in IVbaModules interface gets the Vba module with the specified name in the collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Add() method in IVbaModules interface adds a Vba module to the Vba project module collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Remove() method in IVbaModules interface removes a Vba module with the specified name.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - IVbaProject interface is added to be used for Vba project in the workbook.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Name property in IVbaProject interface specifies the Vba project name.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Description property in IVbaProject interface specifies the Vba project description details.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Constants property in IVbaProject interface specifies the Vba project constants.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - HelpFile property in IVbaProject interface specifies the path of the help file.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - HelpContextId property in IVbaProject interface indicates the help context id in the help file.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - Modules property in IVbaProject interface specifies the Vba project module collection.
  • #75722, #87133, #89984, #104651, #114969, #118436, #124236, #137359, #153779, #230270, #254045 - VbaProject property is added to IWorkbook interface and implemented in WorkbookImpl class to get the Vba project in the workbook.
  • ITopBottom interface is added to represent the top or bottom conditional formatting rules.
  • Type property in ITopBottom interface specifies whether the ranking is evaluated from the top or bottom.
  • Percent property in ITopBottom interface specifies whether the rank is determined by a percentage value.
  • Rank property in ITopBottom interface and TopBottomImpl class specifies the maximum number or percentage of cells to be highlighted for the conditional formatting rule.
  • IAboveBelowAverage interface is added to represent the above or below conditional formatting rule.
  • AverageType property in IAboveBelowAverage interface specifies whether the conditional formatting rule looks for cell values above or below the range average or standard deviation.
  • StdDevValue property in IAboveBelowAverage interface and AboveBelowAverageImpl class specifies standard deviation number for AboveBelowAverage conditional formatting rule.
  • TopBottom property in IConditionalFormat interface gets the TopBottom conditional formatting rule.
  • AboveBelowAverage property in IConditionalFormat interface gets the AboveBelowAverage conditional formatting rule.
  • ExcelCFTopBottomType enum is added to specify whether the TopBottom conditional formatting rule looks for ranking from the top or bottom.
  • ExcelCFAverageType enum is added to specify whether the AboveBelowAverage conditional formatting rule looks for cell values above or below the average.
  • TopBottom value is added to ExcelCFType enum to represent the conditional formatting rule to highlight the top 10 or bottom 10 cells with the values.
  • AboveBelowAverage value is added to ExcelCFType enum to represent the conditional formatting rule to highlight the cells that contain values above or below the range average.
  • Sum() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the sum of numeric cells in the range.
  • An overload to Sum() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the sum of numeric cells along with date formatted cells in the range, with a boolean to consider date as number.
  • Average() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the average of numeric cells in the range.
  • An overload to Average() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the average of numeric cells along with date formatted cells in the range, with a boolean to consider date as number.
  • Min() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the minimum value from the numeric cells in the range.
  • An overload to Min() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the minimum value from the numeric cells and date formatted cells in the range, with a boolean to consider date as number.
  • Max() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the maximum value from the numeric cells in the range.
  • An overload to Max() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to return the maximum value from the numeric cells and date formatted cells in the range, with a boolean to consider date as number.
  • Trim() method is implemented in NameImpl, RangeImpl, and RangesCollection classes to trim the empty rows at the top and bottom of the range, and the empty columns at the left and right of the range.
  • Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified old string value with the specified new string value.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified old string value with the specified new string value, based on the ExcelFindOptions.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified double value.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified datetime value.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified array of new string value in the direction specified by a boolean.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified array of new integer value in the direction specified by a boolean.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified array of new double value in the direction specified by a boolean.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified new value from DataTable.
  • An overload to Replace() method in NameImpl, RangeImpl, and RangesCollection classes replaces the specified string value with the specified new value from DataColumn.

Bug Fixes

  • #248627, #249737 - FormulaHidden property now works properly while saving an Excel file in binary format.
  • #240237 - Diamond shape inside the text box is now preserved properly while resaving the Excel document.
  • #246292 - Exception is no longer thrown while loading the Excel file with duplicate hyperlink relation.
  • #246462 - Unicode languages are now rendered properly in Excel to PDF conversion.
  • #248378 - Super script is now rendered properly in Excel to PDF conversion.
  • #240237 - Text within the shapes are now arranged properly in Excel to PDF conversion.
  • #245763 - Performance issue in Excel to PDF conversion is now resolved.
  • #250058 - Table query fields are now updated properly when table range has more columns.
  • #251122 - Exception is no longer thrown on invoking AutoFitColumn for empty worksheet.
  • #249565 - Exception is no longer thrown while deleting and creating a table with the same name.
  • #250189 - Pivot table is now preserved properly in Excel to PDF conversion.
  • #249466 - Autofit row height is now proper for “Arial” fonts.
  • #249233 - AutofitColumns is now proper for wrap text applied cells.
  • #253015 - Font is now correct while converting Excel document in Linux environment.
  • #250108 - Size property is now updated properly for AutoShapes.
  • #250310 - Conditional format is now copied properly while using horizontal argument and copy style in template maker.
  • #249733 - Legend is now preserved properly while setting a text to data label in line charts.
  • #249432 - Performance is improved in Excel to PDF conversion.
  • #253221 - Arabic text is now rendered properly in Excel to PDF conversion.
  • #253074 - Rotated text is now rendered properly in worksheet to image conversion.
  • #251343 - Exception is no longer thrown while converting the Excel document into PDF with scatter line chart.
  • #251914 - Textbox background color is now preserved properly in Excel to PDF conversion.
  • #251498 - Charts in Excel to PDF converted documents are now visible in PDF XChange Editor.
  • #252776 - Styles are preserved properly while add copying worksheets with ParseOnDemand option.
  • #251321 - Exception is no longer thrown while converting Excel document with large range as print title.
  • #250406 - XmlException is no longer thrown on parsing the Excel workbook.
  • #252776 - Add copying the worksheet with ParseOnDemand option no longer hides the columns in the saved Excel document.
  • #254666 - Transparency is now set properly for AutoShapes.
  • #251345 - Text is no longer cropped when the length exceeds the cell width in Excel to PDF conversion.
  • #250406 - Exception is no longer thrown on parsing the cell style name with empty name or name length greater than 255.
  • #254623 - External data properties are now preserved properly while resaving the Excel document.
  • #253078 - Excel file is no longer corrupted while copying worksheets with more number formats from different workbooks.
  • #255064 - Timeout exception is no longer thrown while refreshing the query table.
  • #253937 - Gridlines in merged cells are now rendered properly in Excel to PDF conversion.
  • #F148410 - Japanese characters are now rendered properly in Excel to PDF conversion.
  • #F146791 - Performance is improved while adding picture multiple times.
  • Exception is no longer thrown while saving the Excel document in CSV format.
  • Rotation angle for the text in text box is now proper in Excel to PDF conversion.
  • Date format m/d/yyyy h:mm is now preserved properly in Excel to PDF conversion.
  • AutoShape and TextBox are now preserved properly while resaving the Excel document and converting the same to PDF.
  • Font name, size, and color of the chart elements are no longer changed while cloning the workbook.
  • Issue while clearing border using BorderNone() method is now fixed.
  • Table named ranges are now added properly to the workbook named range collection.
  • Conditional format is now applied properly while using different cases for text in Excel to PDF conversion.
  • Error display text is now proper in Excel to PDF conversion.
  • Conditional format style is now proper in Excel to PDF conversion when StopIfTrue is set to the condition.
  • Data is no longer lost while using Range.ClearAll option.
  • Conditional format Blanks, NoBlanks, Errors, and NoErrors are now applied in Excel to PDF conversion.