Released: Jan 15, 2025
Updates in 8.0.2
Fixes
- [TextLayout] Incorrect handling of strikethrough when using TextAlignment.Distributed.
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 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...
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 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
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...