Rilasci di Document Solutions for Excel, .NET Edition
Released: Oct 18, 2021
Aggiornamenti in 4.2.4
Correzioni
- IGraphic.LockAspectRatio didn't take effect when adding picture or changing picture size.
- An error would be thrown when loading the JSON file exported by GcExcel in SpreadJS designer.
- InvalidFormulaException is thrown on opening an Excel file.
- Exception is thrown on copying range.
- Exception is thrown on loading JSON file exported by GcExcel.
- Formula is lost after loading JSON and exporting to Excel file.
- (Duplicate)InvalidFormulaException is thrown on opening an Excel file.
- The...
Released: Oct 4, 2021
Aggiornamenti in 4.2.3
Funzionalità
Released: Sep 24, 2021
Aggiornamenti in 4.2.2
Funzionalità
- Added support for XlsmOpenOptions and XlsmSaveOptions.
Correzioni
- "Justify distributed" setting is lost in the exported PDF file.
- Exception is thrown on copying a worksheet to another workbook.
- The checkbox is lost in the exported PDF file.
- The cell value is incorrect after using setValue method to set the cell value.
- Print Area is different from the original JSON file in the exported JSON.
- Exception is thrown on reading the JSON file.
- The exported Excel file is corrupted after...
Released: Sep 3, 2021
Aggiornamenti in 4.2.1
Funzionalità
- Added dynamic array and workbook URI links to formula parser.
- Enhanced Range.AutoFit(bool considerMergedCell).
Correzioni
- ITickLabels.NumberFormat is not applied when saving a workbook to PDF/Image/HTML file.
- When IAxis.MajorUnit is set, tick labels are duplicated in exported PDF/Image/HTML file.
- When the chart series is added, orders of series and legends are incorrect in exported XLSX file.
- Values of category axis are incorrect in exported PDF/Image/HTML file.
- Exception is thrown...
Released: Aug 16, 2021
Aggiornamenti in 4.2
Funzionalità
- Dynamic Array Formulas
- GcExcel adds extensive support for adding dynamic array formulas to Microsoft Excel files through code. The new workbook.AllowDynamicArray will allow you to enable/disable the dynamic array formula in the worksheet. Once enabled, you can use these seven new functions and the dynamic array formula to give the results desired by your applications:
- FILTER.
- RANDARRAY.
- SEQUENCE.
- SINGLE.
- SORT.
- SORTBY.
- UNIQUE.
- Two new errors have also been added:
Released: Jul 29, 2021
Aggiornamenti in 4.1.4
Correzioni
- The exported PDF is different from SpreadJS designer.
- Throws an exception on saving a PDF file.
- Program stuck on using the 'copy' method of IRange.
- 'CellInfo.GetRangeBoundary' method generates incorrect result.
- Zoomfactor info is lost in the exported JSON.
- The page footer in exported PDF is incorrect with the '&D' format.
- The number format of PivotTable's data field is lost in the exported Excel file.
- Throws an exception on using the 'IWorksheet.FromJson' method.
- Treemap and...
Released: Jul 9, 2021
Aggiornamenti in 4.1.3
Funzionalità
- Reduces the size of exported json files.
- Optimizes the performance of importing and exporting json files.
Correzioni
- Throw NumberFormatException when opening the Microsoft Excel file.
- Method 'toJson' fails while using Cube Formulas and OLAP Tools.
- When the connector which is set as arrow head style is exported to JSON file, it is not displayed correctly on importing that JSON file in SpreadJS.
- PivotTable's data field NumberFormat lost after exporting to Microsoft Excel file...
Released: Jun 16, 2021
Aggiornamenti in 4.1.2
Correzioni
- Performance Issue in reading formula from Excel file using GcExcel API with compare to Spread.
- Range Value not getting after loading file in GcExcel.
- Performance issue in accessing the cell when using Slicer in the Excel sheet.
- FormulaResult is not correct if the Evaluate returns null.
- Saved Workbook corrupted after copying sheet with invalid cell format from existing workbook.
- GcExcel for Java takes too long to import SSJSON.
- ToJSON throw Index out of bound exception.
- [I/O Lossless...
Released: May 20, 2021
Aggiornamenti in 4.1.1
Correzioni
- Shape Color changed after saving Excel file using GcExcel API.
- Invalid formula error when opening particular Excel using GcExcel API.
- Behaviors of pivot table changed after saving using GcExcel API.
- INDEX function value in returning "Ref" when opening Excel using GcExcel API with DoNotRecalculateAfterOpened= false.
- Collapsed grouping shows "-" sign when opening exported Excel from GcExcel, in SpreadJs.
- Value is returning "Ref" for the output fields after calling Calculate method of...
Released: Apr 30, 2021
Aggiornamenti in 4.1
Funzionalità
- Performance improvements in Microsoft Excel Template processing.
- Parse formula strings into a syntax tree.
- Ignore formulas when saving Excel files.
- Support open action script on PdfSaveOptions.
- New overload method to load JSON.
- Improved Calculation Engine performance when setting values.
- More features for SpreadJS integration:
- Support for RangeTemplate cell type.
- Apply custom objects on CheckboxList and RadioButtonList cell type.
- Added new ToJson and FromJSON methods to Workbook...