Released: Apr 22, 2022

5.1.0 中的更新

特性

• [Pivot Table] Added the ability to specify 'ShowValuesAs' Option for 'Values' Field.
• Added Numbers Fit Mode of overflow/mask.
• Added the ability to modify passwords of Microsoft Excel Documents.
• [Pivot Table] Added support for Calculated Field.
• Added support for JSON data source for template language.
• Added support for "Show #N/A as an empty cell" in Chart.
• Added the ability to convert Table to Range.
• Added support for CELL function.
• Added a CSV Custom Parser.
• Added support for Pivot table views (JSON I/O).
• Added the Import Data Function to Import Table, Range, or Worksheet from Excel Files.
• Added support for TableSheet (JSON I/O).

修補程式

• Converting the imported Excel to JSON breaks all formulas in it.
• [Template language]Out of memory exception is thrown on using template in multi-thread.
• [Template language]The layout is incorrect in the exported XLSX file when using template with cross table.
• [Template language]The result of sum function is incorrect in the exported XLSX file.
• [Template language]The cell values are not expected in the exported Excel file.
• [Template language]The IF formula is lost in the exported XLSX file.
• [Template language]The formula is not expanded correctly in exported XLSX file.
• IndexOutOfRangeException is thrown on exporting radar chart to PDF file.
• [Template language]The result of sum function is incorrect in the exported XLSX file.
• The legend of series is not shown in the exported PDF file if the datapoints of the series are empty.
• InvalidFormulaException is thrown on creating table when there is "'" in the table column's name.
• Extra characters are exported in data validation in the exported JSON file.
• NullReferenceException is thrown on setting series formula which contains bubble size info.
• The layout of checkbox list is incorrect in the exported PDF file.