Released: Nov 13, 2024

V24.11 中的更新

特性

• Updated package.json to use 'optionalDependencies' to install the corresponding pre-built binary package.
• Added the getCount method to CustomDocumentPropertyCollection and BuiltInDocumentPropertyCollection.
• You can now construct a color object based on a color name.
• Added predefined colors to the Color class.
• Added support for converting a picture in a cell to PDF.
• Added the ability to place an image in a cell in MemoryPreference mode.
• Added support for using a picture as result of calculation.
• Added support for matching conditional formatting when placing same image into different cells.
• Added support for XLSX to PCL conversion.
• Added the ability to get the source for PivotTable with an external source.
• Added the ability to get table relationships in Excel sheet.
• Updated the text options API.
• Added new API in ShapeCollection to add SignatureLine as it does in Excel.
• You can now add Freeform (Scribble) shapes to the worksheet.
• Added support for using the formatting feature in multi-threads environment concurrently.
• Optimized writing Icon Sets to HTML.
• Added support for reading the data model of a XLSX file.
• Added support for all properties of pivot item.
• Added support for getting and setting default resolution of an image.
• You can now show all when removing Auto filter.
• Added support for connection source and calculated member of pivot table.
• Added support for copying entity rich value of the cell.

修補程式

• No API reference is generated for getters or setters with the same name as an overloaded method.
• DataSorter::AddKey with Color object not working.
• Aspose.Cells mentioned in metadata of file.
• Set range style will make sheet have 16384 columns.
• No image shown even after using signedSignatureLine with SetDigitalSignature.
• Boxes (SmartArt/Shapes) appear empty in Excel to PDF rendering.
• Getting cells' formatted results causes exception in multi-threads (one thread per sheet).
• Picture in cell is missing after resaving the sample file in MemoryPreference mode.
• RefreshDynamicArrayFormulas slow after calculating formulas.
• The result file crashes when resaving the sample file.
• Some cells display incorrect #NUM! after formula calculation.
• TEXTJOIN with too long text should produce #VALUE!/#CALC! instead of string value.
• IMDIV function was incorrectly calculated as #NUM?.
• Incorrect value for a formula using LET MAP and LAMBDA after calling CalculateFormula method.
• Dynamic array formulas with IF function are not refreshed correctly when "calculate" parameter is false.
• Some formulas are evaluated as "#NUM!" by Aspose.Cells formula calculation engine.
• Chart is not printed in rendering worksheet.
• Selected column (Axis labels) mismatch Excel.
• Aspose.Cells Chart legend mismatch Excel.
• [+] symbol in the bar graph captured in the output image.
• The font color changed (should be white for the percentage values) in the graph image.
• Thin blue line for no data in bar graph is not rendered in the output image.
• The program keeps hanging when saving file to PDF.
• The strikethrough is lost when converting XLSX files to XPS.
• Layout breaks on MacBook in Safari when rendering Excel spreadsheet to HTML.
• Some borders lost when converting HTML to XLSX.
• The foreground color is incorrect after converting HTML to XLSX.
• Borders and alignment are not picked up when importing HTML to Excel.
• Unable to open XLSX file and saved file is corrupted.
• Corrupted file.
• Power Pivot table properties not retrieved correctly.
• Not able to retrieve a data connection from an Excel spreadsheet.
• Unable to open XLSB file and saved file is corrupted.
• Lost autoshow setting of pivot table in XLSB.
• Incorrect source value of data model connection and pivot table.
• Spreadsheet loses grouped selection buttons.
• Lost relationships of tables after saving the file.
• Invalid PowerQueryFormula property for some connections.
• Pivot table gets corrupted/changed after re-saving the Excel file.
• Regression: Copying worksheet to new workbook corrupts the output XLSX file in versions after 24.2.
• Create/Add Hyperlinks in Smart Markers feature.
• Exception when calling Workbook.RefreshDynamicArrayFormulas method with custom function.
• System.NullReferenceException is thrown when setting cell value with FormulaSettings.EnableCalculationChain = true.
• InvalidCastException occurs when calling InsertRows method.
• Cells.DeleteBlankColumns() with specified range for DeleteBlankOptions caused exception.
• System.InvalidCastException when saving XLSB with table formula.
• RefreshDynamicArrayFormulas throws OverflowException.
• System.OverflowException: 'Arithmetic operation resulted in an overflow when rendering chart/shape to image.
• Regression: System.IndexOutOfRangeException When Setting Nested Divs in HtmlString.
• NullReferenceException occurs when adding PivotDateTimeRangeGroupSettings.
• IndexOutOfRangeException occurs when adding PivotDiscreteGroupSettings and saving to file.