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 20, 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.
• Enhanced 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...

Released: Apr 29, 2024

Updates in 7.1.1

Fixes

• Sheet scrolling buttons are not working when hiding sheet and exporting to Excel file.
• The text direction is different from Excel in the exported PDF file.
• The formula result is incorrect when reading the formula cell value and saving back to Excel.
• The formula result is incorrect with Japanese full-width parameters.
• Exception is thrown on saving an Excel after copying range with formula.
• Exception is thrown on saving Excel to PDF file with Espanol culture.
• Some cell values have an...

Released: Apr 17, 2024

Updates in 7.1.0

Features

• Template Enhancements
  • Enhanced Template language with better performance - The DsExcel Templates have been refactored, emphasizing enhanced performance and stability. The recent improvements include:
    • Addressing the absence of a data source by treating it as null.
    • Enabling OverwriteFillFormat functionality to seamlessly operate in both Pagination and non-Pagination modes.
    • Enhancing template processing capabilities to include support for Picture and Shapes.
    • Enhanced Template performance...