Released: Oct 13, 2023

V23.10 での更新項目

機能

• Added support for adaptive paste operation when size of target range is different from source range.
• Added new API for setting range hyperlinks directly on Range.
• Added support for copying multiple worksheets simultaneously and preserving dependencies.
• Improved performance for setting formulas with sheet references for large amount of cells.
• Updated to SkiaSharp 2.88.6.
• You can now ignore threaded comments when printing comments in place.
• Added support for checking whether one cell range is...

Released: Sep 14, 2023

V23.9 での更新項目

機能

• Added support for calculating LAMBDA, MAP and SCAN functions.
• Added support for parsing and calculating formulas with user defined custom function and definition.
• Added support for excluding specific data when exporting data to DataTable.
• Added localization support to GridDesktop.
• Added support for picture click event to GridDesktop.
• You can now auto extend empty rows/columns when scrolling down/right like Microsoft Excel.
• Added support for selecting text within a textbox control while in...

Released: Apr 11, 2023

V23.4 での更新項目

機能

• Added support for calculating 'ENCODEURL' function.
• Added support for saving XLSB files in 'LightCells' mode.
• Added 'CalculateFormula()' multiply array.
• Added support for rendering ActiveX control and form control for checkbox, textbox and option button in GridWeb.
• Added API for checking whether font is installed or available.
• Added support for setting a formula to a specified cell in the 'ListObject'.
• Improved center aligned text when exporting to HTML.
• You can now save the name of the sheet...

Released: Mar 31, 2023

V23.3.1 での更新項目

機能

• Add sign for NuGet package.

Released: Feb 6, 2023

V23.2 での更新項目

機能

• You can now 'interrupt' when calculating formulas.
• Change the default style of a row/column without changing the style of existing cells.
• Support for new functions: HSTACK and VSTACK.
• Added support for reading the author and date/time of revisions.
• Added support for CHOOSECOLS and CHOOSEROWS Microsoft Excel 365 formulas.
• Enhanced 'SaveOptions.HasHeaderRow' when converting XLSX to JSON.

不具合の修正

• JSON value is missing when a sheet is empty.
• JsonSaveOptions.SkipEmptyRows is not working properly...

Released: Jan 10, 2023

V23.1 での更新項目

機能

• You can now 'interrupt' when calculating formulas.
• Change the default style of a row/column without changing the style of existing cells.
• Support for new functions: HSTACK and VSTACK.
• Added support for reading the author and date/time of revisions.
• Added support for CHOOSECOLS and CHOOSEROWS Microsoft Excel 365 formulas.
• Enhanced 'SaveOptions.HasHeaderRow' when converting XLSX to JSON.

不具合の修正

• JSON value is missing when a sheet is empty.
• JsonSaveOptions.SkipEmptyRows is not working properly...

Released: Oct 12, 2022

V22.10 での更新項目

機能

• Added support for CRTX files.
• PivotTable Timeline Filter now disappears after loading and updating Microsoft Excel documents.
• You can now translate legend labels in accordance with locale/regional settings.

Released: Aug 5, 2022

V22.8 での更新項目

不具合の修正

• Fixed API reference issue.
• Fixed open FODS file format error.

Released: Jul 4, 2022

V22.7 での更新項目

機能

• Added a new 'IWarningCallback' interface.
• Synced features with the .NET version.

Released: May 5, 2022

V22.5 での更新項目

機能

• Improved XML module.

不具合の修正

• Fixed DateTime::parseUTC issue.