Released: Jul 3, 2025

Mises à jour de 8.1.4

Correctifs

• After ignoring formulas, the calculation results of LAMBDA formulas are not exported properly.
• A NullPointerException is thrown when saving a Workbook to SJS, HTML, or PDF formats.
• After setting FitToPagesWide, the exported PDF file still has two pages.
• The calculated result is incorrect when ROW function is used in defined name.

Released: Jun 13, 2025

Mises à jour de 8.1.3

Correctifs

• Grouping a range results in an incorrect outline.
• The result of setting the option to insert entire rows and columns is not as expected.
• An exception is thrown when exporting a PDF file that contains a specific chart.
• Fetching IconType throws an ArrayIndexOutOfBoundsException when the icon is IconType.NoCellIcon.
• Formula cells are not evaluated after calling Workbook.Calculate() method.
• Pivot table totals to an incorrect value.

Released: May 22, 2025

Mises à jour de 8.1.2

Correctifs

• The applyFilter method does not take effect.
• Exception occurs in Workbook.processTemplate().
• The PivotTable data source is not updated after the sheet name is changed.
• An error is thrown when saving an SJS file.
• The program throws an exception when opening an SSJSON file.
• Issues with SUMIF calculation when exporting Excel to PDF.
• ConditionalFormats values are lost after processing the template.
• The value of RowCount is not expected.
• The exported PDF file does not display consistently...

Released: Apr 30, 2025

Mises à jour de 8.1.1

Correctifs

• The result of a dynamic array formula is incorrect when there is a default value in the worksheet.
• The exported Excel file is corrupted when the workbook contains a particular Pivot Chart.
• An exception is thrown when executing the getRefersTo method.
• The column positions are incorrect after the template is extended.
• The count of the runs of rich text increases after calling the IRange.characters() method.
• The result of the IFont.getUnderline() method is incorrect in rich text.
• An...

Released: Apr 21, 2025

Mises à jour de 8.1.0

Fonctionnalités

• Added Clone method to duplicate the workbook instance.
• Added support for adding cell addresses to exported tables in HTML.
• Performance improvements for VLOOKUP and UNIQUE functions.
• Features for SpreadJS Compatibility - The following SpreadJS features are supported as lossless in SJS and SSJSON file format:
  • Data charts.
  • Data charts in Report sheet.
  • Support for binding data manager table as a data source.
  • Support for SpreadJS DataRange.

Correctifs

• Exception was thrown on calling...

Released: Apr 11, 2025

Mises à jour de 8.0.5

Correctifs

• Exception is thrown on saving an SJS file after deleting a worksheet which is referenced by a linked picture.
• The diagonal border in the exported PDF file is incorrect.
• The Y axis is not shown after adding it using API.
• The result of CODE function is incorrect when the parameter contains CJK characters.
• The result of IWorksheet.getUsedRange() is incorrect when UsedRangeType contains Axis.
• The binding path of table is lost in the exported SJS file after processing template.
• The active...

Released: Mar 6, 2025

Mises à jour de 8.0.4

Correctifs

• An exception was thrown when loading a specific SSJSON file.
• The result was incorrect after calling the IRange.sort() method.
• The binding information for table columns was lost after processing the template.
• The formula in the exported workbook was incorrect after processing the template.
• The custom formatter was lost in the exported SJS file.
• The shape's border remained visible in the exported PDF and SJS files despite being set to invisible.
• The custom formatting of the table was...

Released: Feb 21, 2025

Mises à jour de 8.0.3

Correctifs

• The text display different comparing with Excel in the exported PDF file.
• Exception is thrown on processing Template.
• Unexpected cell borders appear in the exported PDF file.
• The scale of tick labels in vertical axis is incorrect in the exported PDF file.
• Exception should be thrown when data source in template is missing.
• There are Spill and NA errors when using COUNTIFS formula.
• The cell locked status has changed after exporting workbook to SSJSON file then import it.
• The exported...

Released: Jan 15, 2025

Mises à jour de 8.0.2

Correctifs

• The cell reference is not as expected in the expanded result after processing template.
• The size of Pie chart is smaller than Excel in the exported Image file.
• Performance issues on processing templates with a large expanded result range.
• The cell tag is lost in the exported Excel file after processing template.
• The row count is incorrect in the exported SJS file.
• Exception is thrown on copying cell across workbook if the source range contains conditional format.
• Exception is thrown...

Released: Jan 3, 2025

Mises à jour de 8.0.1

Correctifs

• The cell value is incorrect when it is in the spilled range of dynamic array formula.
• The style in the hidden column is shown after processing template.
• The z-order of shapes changed after processing template.
• Exception is thrown on calling the processing template method when null exists in the data source.
• Background picture is not copied when calling IRange.Copy method.
• The result of XIRR formula is incorrect.
• Exception is thrown on getting value when cell uses PERCENTRANK.EXC...