Released: Aug 22, 2019

Updates in 2019 Volume 2 SP1

Features

PdfViewerControl

• Support has been added for finding text in a specific page using the PdfLoadedDocument.

Fixes

AutoLabel

• Now, the AutoLabel position is matched between design time and compile time.

Calculate

• Improved the COUNTIF and SUMIF formula calculation performance.
• The MAX formula returns exact calculated value when it refers more number of dependent cells.
• The ATAN formula now returns valid error message for invalid arguments.
• The IFERROR formula now returns the proper result value when using the invalid named ranges as arguments.
• The DAverage formula returns calculated value properly when criteria argument is decimal value.
• VLOOKUP formula is now calculated properly with range_lookup argument.
• CalcEngine now returns valid error message when performing invalid arithmetic operations.

CheckBoxAdv

• CheckBoxAdv is rendered properly while adding it inside ToolStrip.

ComboDropDown

• Exception will no longer occur when the fore color property or style property is set.

Diagram

• Null reference exception thrown when double clicking the node is now resolved.
• The issue “layout moves down when adding the new child at runtime with SizeToContent as true” is now resolved.
• Exception raised while migrating the file from old file to new is now resolved.
• The issue “node name is overwritten” has been fixed.

DocIO

• The ArgumentOutOfRangeException will no longer be thrown while opening a DOC format Word document.
• Line numbers are now preserved properly when resaving the Word document.
• Text encoding issue has been resolved while opening a RTF format Word document.
• Line spacing is now preserved properly while converting a Word document into HTML.
• Paragraphs are now preserved properly while performing horizontal cell merge in a Word document.
• Nested IF field result is now preserved properly while converting a Word document as a Text file.
• List value is now updated properly when converting a Word document to HTML.
• ActualFormatType is now considered as DOCX when creating a new Word document from scratch.
• Character format is applied properly in Inline content control while opening Word document.
• The NullReferenceException will no longer be thrown when updating the fields in the Word document.
• Text border is preserved properly when converting HTML to Word document.
• Character format is applied properly while updating document fields.
• Nested bookmark is now preserved properly while opening a DOC format Word document.
• RTL text alignment and indent issues has been resolved while converting a Word document to PDF.
• Hanging issue has been resolved while converting a Word document to PDF.
• Tab leader is now preserved properly while converting a Word document to PDF.
• Text is now preserved properly while converting a Word document to PDF.
• Underline is now preserved properly while converting a Word document to PDF in fast rendering.
• Font is now preserved properly while converting a Word document to PDF.
• TOC text color is now drawn properly while converting a Word document to PDF.
• Paragraph is now preserved properly while converting a Word document to PDF.
• Shape is now preserved properly while converting a Word document to PDF.
• Spacing issue has been resolved while converting a Word document to PDF.
• Blank page preservation issue has been resolved while converting a Word document to PDF.
• Table is now preserved properly while converting a Word document to PDF.
• The IndexOutOfRangeException will no longer be thrown while converting the Word document to PDF.
• Vertical text fill color is now drawn properly while converting a Word document to PDF.
• Tab is now preserved properly while converting a Word document to PDF.
• Text box is now preserved properly while converting a Word document to PDF.
• Horizontally merged table cell border is now preserved properly while converting a Word document to PDF.

DockingManager

• OnCaptionDoubleClick event will be triggered, independent to EnableDoubleClickOnCaption property.

RadialGauge

• When the EndValue is specified after the StartValue in Range collection, the StartValue is reset to 0 and it is fixed.

GridControl

• The search text is now highlighted properly when cell text is aligned top, left, bottom, or right and cell has margin padding.
• Now, resize and drag drop icons size is updated properly in high DPI scaling.

GridGroupingControl

• DataBar is now drawn properly when adding DataBarRule through designer or property window.
• The dynamic filter dropdown of particular column is now populated with all values after filtered the values in that column using GridExcelFilter.
• The Excel filter dropdown of a column is now populated with values after filtered the values in DateTime type column using GridExcelFilter.
• Improved the dynamic filtering performance when the FilterMode is DisplayText.
• The current cell focus is now moved to filter the row when press Ctrl+Up Arrow keys.

MultiSelectionComboBox

• Now able to select the select the item programmatically in MultiSelection combobox through the binding source.

PDF

• The NullReferenceException will no longer be thrown when merging the particular documents.
• Free text annotation will no longer return invalid text.
• PdfAnnotation will be cleared properly while removing the annotations.
• Font name will be retrieved properly from the PdfLoadedAnnotation.
• Radio button page will be null if it is not added in the page.
• Inserting long text in PdfLightTable cell works properly.
• 3D annotations will be rendered properly with different Pdf3DRendermode.
• PdfFreeTextAnnotation color will be preserved properly.
• Signature information will be rendered properly when applying security.
• Radio button will be added to the existing PDF documents.
• Symbols will be encoded properly in Code 39 Extended and Code 93 Extended barcodes.
• PdfLayoutResult will return proper bounds when enabling auto tag.
• Radio button field will be flattened properly in all PDF pages.
• Text will be rendered properly when filling and flattening text with right alignment.
• Code 32 barcode is now preserved properly for the input text containing zero.
• Text will be rendered properly when converting a particular Word document to PDF.
• Tilling brush will be rendered in proper location on XPS to PDF conversion.
• The PDF document will no longer be corrupted when converting EMF to PDF.
• System out of memory exception will no longer be thrown when converting a Word document to PDF.
• Content inside the child grid will be wrapped properly.
• Barcode will be generated properly with PdfCode93Barcode.
• 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

• The particular PDF document is now printed properly.
• Text is now extracted properly from the PDF document using the PdfLoadedDocument.
• Text bounds are now obtained properly from the FindText method of the PdfLoadedDocument.

PercentTextBox

• The binding of BindablePercentValue property does not convert the value to string and it is fixed.

Presentation

• Font size will be applied properly for second paragraph of table cell.
• Images are now preserved properly while performing clone and merge in PowerPoint presentation.

RibbonControlAdv

• The ToolStripDropDownButton text will not be clipped when the Layout property of ToolStripEx is set to VerticalStackWithOverFlow .
• Disabled ToolStripItem images will be grayed when ImageScaling is set to None.
• The ToolstripButton click event will not be invoked if the form is not in focus.
• Now, the default quick items will be loaded into Ribbon Quick Access Toolbar.
• The size of System Buttons icon is corrected.

ScrollersFrame

• Scroll bar colors will be updated properly in hover state when managed colors are changed.

SfCalendar

• When selection date is set to null, exception is thrown and it is fixed.

SfComboBox

• Now, SfComboBox item height is changed at run time.
• SfComboBox Selected Items behaves properly now when the MultiSelect is enabled.

SfDataGrid

• The CrossThreadException will no longer be thrown when data operation is performed with busy indicator for the details view grid enabled.
• The NullReferenceException will no longer be thrown when expanding details view row after deleting a row.
• Edit cursor will be shown properly for the clipped cell when entering into the edit mode in details view datagrid.
• The DateTime value will be committed when editing without opening dropdown in GridDateTimeColumn.
• The CrossThreadException will no longer be thrown when applying advanced filtering in DataTable using VSTO AddIn Excel.
• The ArgumentOutOfRangeException will no longer be thrown when columns and row header are added in designer.
• Auto row height will be calculated properly for column header that has filter icon and sort icon.

SfDateTimeEdit

• The DateTime value changes from 1/1/1 to 1/1/2001 when the license popup is closed and it is fixed.
• The DateTime Value does not update properly when AllowNull property is true in Mask mode and it is fixed.

SfScrollFrame

• The CrossThreadException will no longer be thrown when closing the form with SfScrollFrame in VSTO AddIn Excel.

SyntaxEditor

• Ctrl + Shift keys combination changes RTL alignment without repetitions.

TreeViewAdv

• The performance delay has been improved when selecting more number of nodes using the Shift key.
• When the width of viewable area node exceeds the width of TreeViewAdv, the horizontal scroll bar appears.
• VerticalScroll Offset is updated properly when the LastVisibleNode exceeds the width of TreeViewAdv.
• Nodes will not be clipped when ShowLines is set to false in higher DPI scaling.
• The ArgumentException will not be thrown when loading nodes at run time.

XlsIO

• Number and date time values are now rendered properly in Excel to PDF conversion.
• Line shapes are now rendered properly when converting Excel to PDF.
• Number alignment is now proper in Excel to PDF conversion.
• Chart series type is now preserved properly while saving the workbook with combination chart.
• Pivot table background color is now preserved properly while resaving the Excel document.
• Pivot chart is now preserved properly while resaving the Excel document.
• Chart data points will no longer be missed when converting Excel to PDF.
• Argument exception will no longer be thrown on opening the Excel file containing external workbook.
• Excel document is now converted properly while using the OFFSET function.
• DateTime value is now returned correctly in UK culture.
• Pivot table row header is now preserved properly when converting Excel to PDF.
• PivotTable will no longer be crashed on refreshing the resaved Excel file.
• Performance delay will no longer occur while resaving the Excel document.
• Conditional format formula for specific text is now updated properly while copying cells.
• DisplayText is now returned correctly when accessing the date time using formula with DDDD number format.
• Creating table with invalid table name will throw an exception.
• PercentOfParent option is now set correctly while creating a pivot table.
• AutoShape text is now rendered properly when converting Excel to PDF.
• Cell text with lesser than and greater than symbols are now preserved properly when converting the worksheet to HTML.
• Time value is now set correctly for 1904 enabled workbook.
• Checkboxes are now checked properly after resaving the Excel document.
• Grand totals of rows and columns are now preserved properly in Excel to PDF conversion.
• Excel document containing conditional formats will no longer be corrupted on inserting a row.
• Legend is now preserved properly on setting custom data label.
• Chart data point will no longer be missed when converting Excel to PDF.
• Performance has been improved while opening the SpreadsheetXML file.
• Vertical text alignment now works properly in Excel to PDF conversion.
• Japanese characters are now preserved properly in Excel to PDF conversion.
• Font name and font size will no longer be changed while opening the Excel document.
• Exception will no longer be thrown on converting the Excel document with date time to PDF.
• Checkbox when removed is now preserved properly.
• Active worksheet is now unselected when multiple worksheets are selected in the Excel file.
• Exception will no longer be thrown on saving the workbook after invoking IApplication.IsSupported() method.
• 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.