Document Solutions for Excel, .NET Edition 新版本發表
Released: Jan 19, 2024
7.0.2 中的更新
修補程式
- The formula changes after inserting columns if the referenced worksheet does not exist.
- After importing SJS and SSJSON files exported by DsExcel into the SpreadJS designer, the charts appear differently.
- The cell value is incorrect after loading the SJS file exported by SpreadJS.
- The exported Excel file is corrupted after loading the SSJSON file then exporting.
- Exception is thrown on calling GetAccurateRangeBoundary method for particular Excel if the calc engine is turned off.
- Exception is...
Released: Jan 4, 2024
7.0.1 中的更新
修補程式
- It takes more than 5 minutes to export specific SSJSON file to PDF.
- Unexpected diagonal border is exported in the XLSX file.
- The result of AGGREGATE formula is incorrect.
- The font style of shape is incorrect in the exported PDF file.
- The icon of conditional format in the exported HTML file is different from Excel and SpreadJS.
- Some back color of cells change to black in the exported PDF file.
- Exception is thrown on loading a specific XLSX file.
- Exception is thrown on loading a specific...
Released: Dec 11, 2023
7.0.0 中的更新
特性
- Async User-Defined Function Support - A user-defined function derived from the new AsyncCustomFunction class now supports asynchronous calculations. Additionally, the CalcError type introduces a 'Busy' enum, signifying that a cell is currently engaged in calculating an asynchronous formula. This enhancement in DsExcel empowers users to leverage asynchronous calculations within their custom functions, providing flexibility and efficiency in scenarios involving complex computations...
Released: Nov 21, 2023
6.2.5 中的更新
修補程式
- After calling IWorksheet.copyAfter() method, an error occurs when opening the exported Excel file.
- Performance issue when calling IRange.Copy() method many times.
- The icon of conditional format in the exported PDF file is different from Excel and SpreadJS.
- Exception is thrown on copying sheet across Excel files when sheet contains custom sheet views.
- The selected area is a whole row, the used range would be changed in the exported SJS file.
- The picture cannot be fully displayed in the...
Released: Nov 3, 2023
6.2.4 中的更新
修補程式
- Chart is not output correctly in PDF file when combo chart of scatter charts have no data.
- Exception is thrown on Workbook.processTemplate() method.
- The cell formatting is incorrect in the copied worksheet.
- Exception is thrown on calculating the function which refers to a non-exist worksheet.
- Exception is thrown on saving workbook to the Excel file.
- The exported XLSX file is corrupted when the hyperlink contains quote.
- Inconsistent results when processing template with multiple threads.
Released: Oct 13, 2023
6.2.3 中的更新
修補程式
- There are unexpected lines in the exported Excel file after processing Template file.
- DataValidation Error Alert doesn't preserves after saving the Workbook.
- InvalidOperationException is thrown on specifying multiple ranges for a chart data source.
- The calculated result is inconsistent between the exported PDF and Excel files.
- The EAN-13 barcodes which values start with 0 are not output correctly.
- Threaded comments are not visible in Finnish locale.
- Size of Chart Y Axis is incorrect in the...
Released: Sep 15, 2023
6.2.2 中的更新
修補程式
- The result of XLOOKUP function is incorrect.
- The text wrapping position is inconsistent with SpreadJS.
- The picture is incorrect in the exported PDF file when picture has crop and rotation setting.
- The center header of printinfo is lost in the exported SSJSON file.
- Exception is thrown on loading the SSJSON file that contains invalid chart data.
- Exception is thrown on rendering PDF file when workbook contains particular chart.
- Performance issue on setting cell value.
- The interior of cell is...
Released: Aug 26, 2023
6.2.1 中的更新
修補程式
- The legend of deleted series in chart are displayed in the exported Excel file.
- Doughnut charts is lost in the exported PDF file.
- The wrap position is incorrect when text contains "-" charactor in the exported PDF file.
- The result of the formula in the defined name is not updated correctly.
- The program gets stuck when processing template.
- The sparklines is incorrect in the exported PDF file.
- The program gets stuck when processing template.
- Exception is thrown on exporting PDF file when...
Released: Aug 7, 2023
6.2.0 中的更新
特性
- Added support for double-sided printing.
- GcExcel .NET supports the
Duplex
enum in PrintOutOptions
class to enable/disable double-sided printing on a page.
- There are four options in the enum that the user can use accordingly to print the workbook:
- Duplex.Default indicates the printer's default duplex setting.
- Duplex.Simplex indicates Single-sided printing.
- Duplex.Vertical indicates the Double-sided, vertical printing.
- Duplex.Horizontal indicates the Double-sided, horizontal printing.
- Added the...
Released: Jul 21, 2023
6.1.4 中的更新
修補程式
- Requested Registry access is not allowed error occur on setting the impersonate in the web.config for web app.
- The result of XIRR func is incorrect.
- InvalidFormulaException is thrown on opening an Excel file with XLOOKUP formula which refers to external Table formula.
- The result of reappling filter is incorrect after setting data source.
- The result of dynamic array formula is incorrect when disabling calculation engine the enabling.
- StackOverFlowException is thrown on processing template...