Released: Dec 14, 2023

V23.12 での更新項目

機能

• Added support for rendering rotated cell text.
• Added support for PDF/A-2b (ISO 19005-2), PDF/A-2u (ISO 19005-2), PDF/A-2a (ISO 19005-2), PDF/A-3b (ISO 19005-3), PDF/A-3u (ISO 19005-3) and PDF/A-3a (ISO 19005-3) compliance while converting workbooks to PDF.
• You can now keep missing data when refreshing and calculating pivot tables.
• Added support for calculating discrete grouping in pivot table.
• Added support for exporting generic lists.
• Added an auto clear data validation setting in paste area...

Released: Nov 16, 2023

V23.11 での更新項目

機能

• Added support for Apple macOS ARM versions.
• Grid Desktop:
  • Added support for copy/delete/insert/rename worksheet operations.
  • Auto extend max rows/columns when performing paste operations.
  • Added support for 'SheetPrintingPreview' and 'PdfSaveOptions'.
• Generate ISO32000-1:2008 PDFs.
• Localize dates on grouping fields.
• Added support for 'LET' function.
• Added support for keeping data when removing pivot tables.

不具合の修正

• Removes all merged cells in the range when calling Cells.Unmerge().
• Performance...

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 the threaded comments when printing comments in place.
• Added support for checking whether one cell range...

Released: Sep 15, 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: Aug 23, 2023

V23.8 での更新項目

機能

• Improved UI display for dropdowns with long lists of data.
• Added support for preserving padding space in formulas.
• Conditional formatting formulas can now be ignored when saving to XLSB format.

不具合の修正

• CHAR function returns error value when calling CalculateFormula.
• DataSorter does not clear old data when new data is blank.
• Incorrect result of calculating NUMBERVALUE Formula.
• Function’s calculated value changes from “#REF!” to “#VALUE!” after changing file format from xlsx to xls.
• Symbols are...

Released: Jul 19, 2023

V23.7 での更新項目

機能

• Added support for rendering background color and border in GridWeb Textbox control.
• Added support for Microsoft Visio file type detection.
• Added support for Microsoft OneNote package file type detection.
• Added support for XAdES signatures for CSharp X509Certificate2.
• Added support for Workbook digital signatures in Blazor Web Assembly.
• Added support for VBA signatures in Blazor Web Assembly.
• Added support for encrypting/decrypting ODS in Blazor Web Assembly.

不具合の修正

• Aspose.Cells is not working...

Released: Jun 16, 2023

V23.6 での更新項目

機能

• Added support for traversing row/cell in reverse order.
• Added support for refreshing multiple consolidation ranges in a pivot table.
• Added support for extending rows when setting a total formula.
• Improved detection of Gzip files.

不具合の修正

• Row with no data should be taken as blank and removed by Cells.DeleteBlankRows() even if there is merged cells intersect with it.
• Chart does not get updated when writing new lines to a listobject with Aspose.Cells.
• Arrow Shapes placed incorrectly after...

Released: Jun 2, 2023

V23.5 での更新項目

機能

• Added support for updating external sheet data references when removing external links.
• You can now render a checkbox as a control and not as a static picture.
• Added the ability to set image dimension and keep aspect ratio while converting a workbook to an image.
• You can now 'AutoFit' rows for rendering.
• Added support for getting 'PivotArea' and 'PivotFormat'.

不具合の修正

• The file size of generated PDF is too large while converting to PDF.
• 'Invalid column index.' on saving PDF.
• Tick symbol does...

Released: Apr 17, 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: Apr 1, 2023

V23.3 での更新項目

機能

• Added support for setting, reading and saving 'ENCODEURL' and 'LET' functions.
• Changed System.Drawing.Common dependency to 6.0.0 for Microsoft .NET 6 and .NET 7.
• Updated calculated column formula when copying.

不具合の修正

• Fixed issue where double/float value was inserted as integer.
• Text shadow effect disappears when saving file to PDF.
• The text font color of smart art should be black.
• SUBTOTAL and other aggregate functions do not work correctly inside a dynamic array formula.
• Incorrect value...