Released: Feb 6, 2024

Updates in V24.2

Features

• Added support for the TOROW/TOCOL functions.
• Show "convert to number" menu for cells which have a number stored as text.
• Added support for copying/pasting image and HTML content to GridDesktop.
• Added key word search support for filter list to GridDesktop.
• Added support for clear filter operation to GridDesktop.
• Added support for number filter for GridDesktop.
• Added support for detecting OXPS format.
• Added support for parsing color attribute containing "var" or "rgba" fields.
• Improved large dataset sorting performance.
• Improved the filter for large data for GridDesktop.
• Added options to differentiate empty cells when exporting data to DataTable and detecting data type.

Fixes

• Obtain incorrect connection points when calling the GetConnectionPoints method.
• The result file crashes after setting X rotation of Line.
• Cell background color incorrect for conditional formatting.
• MAP returns #VALUE! error when input arrays have length of 1.
• The formula in adjacent cell is removed after calling ImportData.
• The bar chart changed direction after resaving the sample file.
• The line style of Chart changes after copying the range.
• Some UI message in GridDesktop have not been localized.
• Custom server validation does not show in GridWeb.
• Check box validation does not work in GridWeb.
• Dropdown list does not load in GridWeb .NET Core.
• Support to extend display area for cell content in GridWeb for .NET Core when open the customer's file.
• Error setting Cell.HtmlString for em font sizes smaller 1.0.
• Span text elements are gone after saving HTML to Excel.
• HR black line elements are gone after saving HTML to Excel.
• First table bottom border is gone after saving file to Excel.
• Extra borders and border color errors occurred when resaving XLSB file.
• Some strange values appear when opening a workbook with LoadDataFilterOptions.CellValue.
• Columns are sometimes hidden incorrectly after filtering blank cells.
• Pivot table refresh results are incorrect.
• The resultant file crashes after filtering blank cells.
• Cell.HtmlString CSS "color:#FF0000 !important" throws an Exception.
• ArgumentOutOfRangeException occurred when copying the worksheet.
• NullReferenceException occurred when saving a Workbook.
• New Workbook - System.ArgumentOutOfRangeException.