Released: Dec 12, 2024

V24.12 中的更新

特性

• You can now get notified of formula changes when inserting/deleting cell range.
• Added support for BYROW and BYCOL lambda functions.
• Added support for parsing fraction values such as "33 1/3" as numeric when calculating formulas.
• Added support for rendering LinearGradientBrush, PathGradientBrush, HatchBrush and TextrueBrush to PCL.
• Added support for placing inline styling/formatting inside HTML elements.
• You can now add Font Color, Cell Color as data sorter key.
• Enhanced pivot filter APIs.
• Added support for multiple pivot field filters.
• Added support for using whole day for date pivot filter.
• Updated order and add group to PowerQueryFormulas.
• Unified and integrated types of Warning and CellsException.
• Merged legacy version into main version for Linux.

修補程式

• Output process does not complete when converting file to PDF.
• Formula result wrong for the customer's file.
• XYScatter chart is not rendered properly in Excel to PDF conversion.
• Chart line ending arrows are missing - just straight line is printed.
• The text before the graph is clipped when converting chart to image.
• Text is wrapped into multiple lines when converting chart to image.
• Chart.Calculate() method hangs.
• Last column of Excel chart disappearing when rendering range to image.
• Last point label of Bar chart is missing when converting chart to image.
• Chart does not render same as in Excel.
• The Subtitle of the chart is incorrect when file is not ODS.
• Printed graphics/charts is different from MS Excel print.
• The image automatically shrinks when saving file to PDF.
• CellsException(Cell value type is not boolean) occurs when saving file to PDF.
• Table row in HTML is ignored when converting HTML to Excel.
• Power pivot table is lost when converting XLSB to XLSX.
• Default settings for FontSettings overwrite the existing styles after calling Workbook.Replace method.
• Invalid result of pivot view after refreshing pivot table with value filter.
• Cell background color disappears when saving.
• Incorrect type of PowerQueryFormula.
• Invalid original width and height of WMF image in the Excel 5/95 file.
• The Excel file becomes corrupted after adding references to all cells due to charts.
• Incorrect items in data connections and query table.
• Conditional formatting rules are missing after copying a worksheet.
• Regression: Changing the ExternalLink DataSource corrupts the XLSX file.
• Copy rich array data when copying workbook.
• Generated file is corrupted if the file contains python formulas.
• Generated file is corrupted if copying worksheet contains python formulas.
• The result file crashes after importing data and resaving file.
• Unsupported data model exception when calling CalculateFormula() method.
• Converting checkbox to PDF caused exception when the cell value is not boolean.
• Converting checkbox to HTML caused exception when the cell value is not boolean.
• NullReferenceException when loading an XLSM file.
• NullReferenceException when reading workbook.DataMashup.