Released: Jan 3, 2025

8.0.1 中的更新

修補程式

• 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

8.0.0 中的更新

特性

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 in C#/.NET/Java, relational databases, .NET controls, 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.
  • 2D array (.NET only).
  • Multidimensional array.
  • Jagged arrays.
  • Custom...

Released: Nov 21, 2024

7.2.5 中的更新

修補程式

• 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

7.2.4 中的更新

修補程式

• OutOfMemoryException is thrown on exporting Excel file to SJS file.
• The distributed text alignment is incorrect in the exported PDF 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 gets corrupted...

Released: Oct 10, 2024

7.2.3 中的更新

修補程式

• 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

7.2.2 中的更新

修補程式

• 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

7.2.1 中的更新

修補程式

• 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

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