Released: Jun 10, 2022

V22.6 中的更新

特性

• Added new APIs to convert data to 'ICellsDataTable'.
• Improved support for data storage in Numbers format.
• Improved support for reading images in Numbers format.
• Added support for setting CellRange style.
• Added ChartCollection.Add (ChartType, String, Boolean, Int32, Int32, Int32, Int32) overloaded method.
• Added support for importing an array value if the range is a simple cell.
• Added support for saving table formulas to XLSB.

修补程序

• Picture is blurred.
• Wrong UpperLeftRow of CheckBox after loading workbook.
• Duplicate checkboxes.
• Characters written on objects such as shapes and text boxes are garbled in Linux.
• XLS file with Pivot table converted to XLSM is corrupted and data connections details got deleted.
• Dynamic formula with FILTER function cannot be refreshed and calculated correctly.
• Cell.Calculate() does not update formula dependencies when the calculation chain is enabled for the workbook.
• Issue with CEILING function in Aspose.Cells' formula calculation engine.
• DATE function was calculated as #NUM! for 1/0/1900.
• Converting an XLSB file with Data Tables to XLSM format resulted in deletion of Data Table.
• Some cells with very lengthy formulas are not getting calculated by Aspose.Cells.
• Problem with COUNTIFS formula treating 0 incorrectly.
• Chinese characters are corrupted when loading html.
• ImportXml issue with Date field.
• Custom format is changed after reloading saved html into workbook.
• Strikeout font does not work in the rendered SVG/image on linux.
• Exception throws while exporting xml data linked to Xml Map.
• ImportXml issue with Boolean field.
• XLSX to PDF: Bar charts not rendered correctly.
• X-axis labels are wrong.
• Last x-axis parameter is not displayed.
• Chart labels do not fit the box - box is oversized.
• Chart label aligned vertically instead of horizontally.
• Incorrect output of series names when saving workbook to PDF.
• Bugs with Chart.Title.IsVisible=false when saving PDF.
• Missing numbers when creating Image from Excel Chart.
• Saved .ods file is corrupted when the file contains list validation.
• Lose ranges of ErrorCheckOption.
• Chart.SetChartDataRange will skip empty cells in data range.
• Chart.SetChartDataRange did not recognize merged cells.
• The type of empty chart should be ChartType.Line if contains Marker node.
• Has revisions attribute returns true but track changes is disabled.
• workbook.save(filePath) Cancels Freeze Panes.
• Workbook.CalculateFormula causes “Object reference not set to an instance of an object” exception.
• Exception “Cell has been removed: D7” when setting style to a range in Aspose.Cells.GridDesktop.
• Exception “This Excel file contains (Excel2.1 or earlier file format) records” when loading an XLS file.
• New workbook fail raise exception: This Excel file contains (Excel4.0 or earlier file format) records.
• System.FormatException. String was not recognized as a valid DateTime when loading Suomi Excel file.