Released: Sep 12, 2024

Mises à jour de V24.9

Fonctionnalités

• Added support for displaying details for a value field in a PivotTable report.
• Improved width and height measure for Aptos Narrow font.
• You can now keep and remove custom JavaScript macros.
• Added support for skipping smart markers with JSON data sources.
• Added support for array data when importing JSON data to Excel using SmartMarkers.
• Added support for base64 picture data when importing JSON data to Excel using SmartMarkers.
• Added support for JSON as the data source of repeated formulas in SmartMarkers.
• Added support for converting UTC date string to Datetime in processing SmartMarkers.

Correctifs

• The spacing between text lines in the text box is incorrect when converting the file to PDF.
• ASC function does not give correct value for some characters.
• WIDECHAR does not give correct result for some Japanese characters.
• TEXT function was not calculated correctly for some regions.
• Incomplete display of chart data when converting file to HTML.
• Image size exceeds the limit when using ImageOrPrintOptions.setOnePagePerSheet (true).
• Performance regression of Cells.clearContents since 24.6.
• Page break is not right when using Aptos Narrow font.
• Incomplete display of a certain line of text when saving file to PDF.
• Copying a Workbook does not copy settings.
• Cell.setHtmlString not rendering image from URL.
• Result file data display error when converting file to HTML.
• Currency symbols were lost when saving ODS file.
• Cannot insert a new column with desired style besides a Pivot Table.
• SetSkipBlanks(true) does not skip blank source cells when pasting.
• Changing the color of a few words in the chart shape will result in extra strings appearing.
• Row labels and column labels are not converted while converting Excel pivot table to PDF.
• TEXTJOIN() function results inconsistent with MS Excel.
• Named range not available after Aspose.Cells converting an XLSX file to XLSB.
• Excel to HTML conversion - Line display problem.
• Space loss when using Cell.setHtmlString function to set values.
• NullPointerException occurs when importing JSON data to Excel using smart markers.
• Data replacement failed when using map as the data source for smart marker.
• Pivot Cache truncated after calculateRange.
• NullPointerException occurs when converting file to HTML.
• ArrayIndexOutOfBoundsException occurs when calling Workbook.calculateFormula() method.
• "com.aspose.cells.CellsException: Invalid Power query formula definition" on merging files.
• Loading XLS file throws Out of Memory exception.
• Corrupted file due to pivot field name contains single quotation mark while converting XLSB to XLSM.
• NullPointerException occurs when smart marker tag is not present in JSON input file.