Released: Nov 5, 2019

Updates in 2019 Volume 3 SP1

Fixes

ButtonAdv

• The ArgumentException will no longer occur when switching Office2019 theme to Office2016 themes.

Calculate

• The formulas with named ranges returns the calculated value properly when that named range’s name contains special characters.
• CalcEngine returns proper result when sum the string and numeric values.
• The System.ArgumentOutOfRangeException will no longer be thrown when arguments in arithmetic operation has special characters.
• Optimized the OR and AND functions in CalcEngine.
• VLOOKUP function returns proper result when it contains external sheet reference.
• SUMPRODUCT function returns proper result when using arguments like A:A.
• Formulas with multiple cell references (A1:B2:C3:D4) are calculated properly.
• Formulas which has embedded table named range as arguments are now returns computed value properly.

GridGroupingControl

• The records are filtered properly using GridExcelFilter when adding same filter condition or expression again to RecordFilters programmatically.
• Elements and DisplayElements collections of Grid are updated properly when adding ColumnSet using GridColumnSetDescriptorCollection.AddRange method.

PDF

• The NullReferenceException will no longer occur when getting destination of PdfLoadedDocumentLinkAnnotation.
• Default document information from portfolio will be retrieved properly.
• Performance of PDF to PDF A1B converter has been improved.
• Merging will now preserve all the pages from source documents.
• Header style will be preserved properly in PdfLightTable.
• Image will be preserved properly with signature appearance.
• Exception will no longer occur while selecting the bookmark items from existing PDF document.
• Conformance will be validated properly in particular site for the created conformance document.
• Exception will no longer occur while merging the particular document.
• The IndexOutOfRangeException will no longer occur while adding digital signature to the document.
• The PdfInkAnnotation will be preserved properly for two points.
• Date format will be preserved properly while flattening the XFA form field.
• Existing PDF document compression has been improved in file size.
• Characters will be preserved properly in XPS to PDF conversion.
• Lines will be preserved properly in EMF to PDF conversion.
• The NullReferenceException will no longer occur while importing pages from PDF document.
• The PDF document will no longer corrupted while loading and saving in same memory stream.
• Form fields will be flattened properly while merging the PDF documents.
• Images with color space will be preserved properly in PDF document.

PdfViewerControl

• Text selection is now working properly for the particular PDF document.
• Euro symbol is now preserved properly in the extracted text from the PDF document.

PivotGridControl

• Provided support to hide the subtotals based on the ShowSubTotals property of PivotItem.

RibbonControlAdv

• Memory leak will not occur while merging the tabs through RibbonPanelMergeContainer.
• The NullReferenceException will no longer occur when adding RibbonPanel from the BackstageView in Office2019 theme.
• The BackstageView will not be activated from the Quick access item when clicking the Back button.

SfComboBox

• Popup will be closed properly in Excel add in.
• The MaxDropDownItems property will display the items properly while opening the dropdown.

TreeViewAdv

• Null exception will no longer thrown while hiding the nodes.
• TreeNodeAdv cannot turns to edit mode automatically on multi selection.
• Scrolling works properly till the last node while scrolling using the thumb in scroll bar.

XlsIO

• FormulaHidden property now works properly while saving an Excel file in binary format.
• Diamond shape inside the text box is now preserved properly while resaving the Excel document.
• Exception is no longer thrown while loading the Excel file with duplicate hyperlink relation.
• Unicode languages are now rendered properly in Excel to PDF conversion.
• Super script is now rendered properly in Excel to PDF conversion.
• Text within the shapes are now arranged properly in Excel to PDF conversion.
• Performance issue in Excel to PDF conversion is now resolved.
• Table query fields are now updated properly when table range has more columns.
• Exception is no longer thrown on invoking AutoFitColumn for empty worksheet.
• Exception is no longer thrown while deleting and creating a table with the same name.
• Pivot table is now preserved properly in Excel to PDF conversion.
• utofit row height is now proper for “Arial” fonts.
• AutofitColumns is now proper for wrap text applied cells.
• 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.

XpTaskBar

• The PreferredChildPanelHeight property now working properly even AutoSize is set.

XPToolBar

• Customized tooltips will be displayed properly for bar items and parent bar items.