Released: Aug 20, 2024

7.2.0 中的更新

特性

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

Released: Jul 19, 2024

7.1.5 中的更新

修補程式

• 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

7.1.4 中的更新

修補程式

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

Released: Jun 7, 2024

7.1.3 中的更新

修補程式

• 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

7.1.2 中的更新

修補程式

• 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

7.1.1 中的更新

修補程式

• 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

7.1.0 中的更新

特性

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

Released: Mar 22, 2024

7.0.5 中的更新

修補程式

• Some content in the hyperlink is escaped after loading the SJS file.
• The legend of chart in the exported PDF file is incorrect.
• The table range is not updated after data binding.
• Exception is thrown on exporting PDF file when workbook contains specific cell button.
• Exception is thrown on processing template.
• Exception is thrown on loading Excel file.
• Exception is thrown on exporting PDF file in France (Belgium) culture.
• Exception is thrown on loading SJS file when some table formula is...

Released: Feb 28, 2024

7.0.4 中的更新

修補程式

• The checkstatus of the checkbox is incorrect in the exported PDF file.
• Exception is thrown on exporting SJS file when data validation contains invalid formulas.
• Exception is thrown on getting cell value when the cell refers to non-existing worksheet.
• The formula changed after inserting a column when formula contains non-existing worksheet.
• Exception is thrown on opening a particular Excel file.
• The shape is not copied using IRange.Copy() method.
• Merge area changed in the exported Excel file...

Released: Feb 8, 2024

7.0.3 中的更新

修補程式

• The captions of a Pivot Table item are reset after refreshing.
• Exception is thrown on exporting workbook to PDF file.
• Performance issue when copying cells to another workbook.
• The border in the exported HTML file is inconsistent with the display in SpreadJS.
• The processing time of the template has significantly increased after the upgrade.
• Exception is thrown on trying to get the DataValidation Formula.
• Integers have an extra decimal place in the exported file after template processing...