Released: Apr 30, 2025
8.1.1 での更新項目
不具合の修正
- The result of a dynamic array formula is incorrect when there is a default value in the worksheet.
- The exported Excel file is corrupted when the workbook contains a particular Pivot Chart.
- The column positions are incorrect after the template is extended.
- The count of the runs of rich text increases after calling the IRange.Characters method.
- The result of the IFont.Underline property is incorrect in rich text.
- An exception is thrown when exporting an Excel file containing a 3D reference...
Released: Apr 21, 2025
8.1.0 での更新項目
機能
- Added support for adding cell addresses to exported tables in HTML.
- Performance improvements for VLOOKUP and UNIQUE functions.
- Features for SpreadJS Compatibility - The following SpreadJS features are supported as lossless in SJS and SSJSON file format:
- Data charts.
- Data charts in Report sheet.
- Support for binding data manager table as a data source.
- Support SpreadJS DataRange.
不具合の修正
- The sorting result of the pivot table was incorrect in an exported PDF file.
- Performance issue on calculating...
Released: Mar 27, 2025
8.0.5 での更新項目
不具合の修正
- Exception is thrown on saving an SJS file after deleting a worksheet which is referenced by a linked picture.
- The diagonal border in the exported PDF file is incorrect.
- The Y axis is not shown after adding it using API.
- The result of CODE function is incorrect when the parameter contains CJK characters.
- The result of IWorksheet.getUsedRange() is incorrect when UsedRangeType contains Axis.
- The binding path of table is lost in the exported SJS file after processing template.
- The active...
Released: Mar 6, 2025
8.0.4 での更新項目
不具合の修正
- An exception was thrown when loading a specific SSJSON file.
- The result was incorrect after calling the IRange.Sort() method.
- The binding information for table columns was lost after processing the template.
- The formula in the exported workbook was incorrect after processing the template.
- The shape's border remained visible in the exported PDF and SJS files despite being set to invisible.
- The custom formatting of the table was lost in the exported Excel file.
- The TintAndShade setting did...
Released: Feb 21, 2025
8.0.3 での更新項目
不具合の修正
- The cell reference is not as expected in the expanded result after processing template.
- The size of Pie chart is smaller than Excel in the exported Image file.
- Performance issues on processing templates with a large expanded result range.
- The cell tag is lost in the exported Excel file after processing template.
- The row count is incorrect in the exported SJS file.
- Exception is thrown on copying cell across workbook if the target range contains conditional format.
- Exception is thrown on...
Released: Jan 15, 2025
8.0.2 での更新項目
不具合の修正
- [TextLayout] Incorrect handling of strikethrough when using TextAlignment.Distributed.
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...