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

Released: Oct 10, 2024

Updates in 7.2.3

Fixes

• The alignment is incorrect in the exported Excel file when overwrite fillmode is applied to cross table in template.
• The invocation of the PrintManager consumes a lot of memory.
• The plot area is not in the center in the exported image file.
• Some resources are incorrect in the de-DE/de-CH/it-CH/fr-CH culture in the exported Excel file.
• Exception is thrown on exporting SJS file after copying formula from another workbook.
• Enhance the exception message when inserting column is invalid...

Released: Sep 18, 2024

Updates in 7.2.2

Fixes

• There are many unexpected diagonal lines in the exported PDF file.
• Exception is thrown on exporting HTML file if some shape width is zero.
• The exported Excel file is corrupted when the source data of the PivotChart contains CalcError.
• The result of AVERAGEIF function is incorrect.
• Exception is thrown on opening an SJS file that contains invalid quality factor.
• The text that exceeds the boundaries of the shapes has not been cropped in the exported PDF file.
• After setting the value to a cell...

Released: Aug 30, 2024

Updates in 7.2.1

Fixes

• The macro button is missing after processing template file.
• The XValues of chart are incorrect in the exported PDF file.
• The static cell did not expand with the adjacent cell.
• Performance issue on calling ToJson method.
• The value and reference range of defined name become "#REF!" after processing template.
• "_Report_0" is added to the end of the shape name after processing template.
• There is a null fallback FontFamily in the exported HTML file.
• Exception is thrown on setting formula of...

Released: Aug 19, 2024

Updates in 7.2.0

Features

Document Solutions for Excel

• Add Goal Seek to Spreadsheets
  • Excel's Goal Seek function enables users to determine the necessary input value to achieve a desired result. By setting a target output, the Goal Seek feature automatically adjusts input values until the desired outcome is reached. This feature is invaluable for scenario analysis and decision-making in Excel modeling.
  • DsExcel adds a new API to add the Goal Seek function programmatically to your spreadsheets. The new IRange...

Released: Jul 19, 2024

Updates in 7.1.5

Fixes

• The formula becomes dynamic array formula in the exported Excel file after processing the template.
• The custom formatter is lost in the exported SSJSON file.
• The source data of the Pivot Table is not updated after data binding.
• Some constant text is lost in the exported Excel file when setting FillMode as overwrite.
• The applied range of conditional formatting is incorrect in the exported Excel file after processing the template.
• The IndentLevel is reset to 0 after setting horizontal...

Released: Jun 27, 2024

Updates in 7.1.4

Fixes

• Merged cells are unmerged in the exported Excel file when template cell have G=R property.
• The series line of chart changed after loading the SSJSON file then exporting to SJS file.
• The formula is lost after loading the particular SJS file.
• The font weight is lost after loading the particular SSJSON file.
• Performance issues on opening a particular Excel file which contains lots of external workbooks.
• Exception is thrown on exporting Excel file after deleting particular sheet.
• The...

Released: Jun 7, 2024

Updates in 7.1.3

Fixes

• The column style is lost after calling processTemplate method in the exported XLSX file.
• There is a performance issue when saving specific Excel files to an HTML file.
• Enhance the exception message when deleting range is not allowed.
• Exception is thrown on filling the specific template file.
• Row heights are changed after opening an XLSX file then export to SSJSON file.
• Exception is thrown on deleting row after loading some particular SJS file.
• Constant cells are expand along with the...

Released: May 16, 2024

Updates in 7.1.2

Fixes

• The formula result is incorrect using API to get the cell value.
• Performance issue on calculating workbook containing dynamic array formulas.
• The number format is incorrect when using Chinese version of Excel to open the Excel file exported in US culture.
• Rich text is missing in the exported PDF file.
• Copying the sheet takes a long time when sheet contains lots of pictures.
• The print info is changed in the exported SSJSON file.
• An exception is thrown on saving Excel file.
• Chart data lost...