Released: Apr 30, 2025

Updates in 8.1.1

Fixes

• 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 exception...

Released: Apr 21, 2025

Updates in 8.1.0

Features

• 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.

Fixes

• Exception was thrown on calling IWorksheet...

Released: Apr 11, 2025

Updates in 8.0.5

Fixes

• 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 sheet...

Released: Mar 6, 2025

Updates in 8.0.4

Fixes

• 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 lost in...

Released: Feb 21, 2025

Updates in 8.0.3

Fixes

• 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 Excel...

Released: Jan 15, 2025

Updates in 8.0.2

Fixes

• 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 on...

Released: Jan 3, 2025

Updates in 8.0.1

Fixes

• 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 formula...

Released: Dec 11, 2024

Updates in 8.0.0

Features

Import Data from Object Collections and Data Tables

• When working with Excel sheets programmatically in business applications, one common task is to import data from different data sources, such as classes and objects, relational databases etc. In the v8 release, Document Solutions for Excel (DsExcel) adds the ability to import data from the following types of data sources:
  • Simple enumerable.
  • Multidimensional array.
  • Jagged arrays.
  • Custom objects.
  • Custom objects from weakly typed...

Released: Nov 21, 2024

Updates in 7.2.5

Fixes

• When copying array formulas and exporting them to Excel, the reference ranges change.
• The form fields are incorrect in the exported PDF file after processing template.
• Some conditional formats are lost in the exported Excel file.
• Exception is thrown on opening a specific Excel file with a password.
• The XMATCH function does not return correct value if lookup array contains empty cells.
• Exception is thrown on loading SJS file contains null author in comment.
• The autofit method does not work...

Released: Oct 31, 2024

Updates in 7.2.4

Fixes

• OutOfMemoryException is thrown on exporting Excel file to SJS file.
• The font name in specific cells has changed after loading the SSJSON file.
• Some unused named styles are missing after loading the original SJS file.
• Some data labels are missing in the exported image file.
• Exception is thrown on opening an SJS file.
• The chart is corrupted in the SJS file exported by DsExcel.
• Emoji characters in sheet name get corrupted in the exported SJS file.
• The fill color is incorrect after adding a...