Released: Oct 12, 2023

Updates in V23.10

Funktionen

• 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...

Released: Sep 13, 2023

Updates in V23.9

Funktionen

• 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...

Released: Aug 9, 2023

Updates in V23.8

Funktionen

• Added support for validating formula expressions.
• Added support for preserving padding spaces in formulas.
• Added support for list validation.
• Added the ability to replace text with rich formatting text.
• Added support for using Aspose.Cells in AWS lambda function projects.
• Improved the UI display for dropdown lists with long lists of data.
• Added support for text length and decimal validation.

Fehlerkorrekturen

• Formulas of some conditional formattings can be ignored when saving XLSB...

Released: Jul 13, 2023

Updates in V23.7

Funktionen

• GridWeb Textbox control added support for rendering background color and border.
• GridJs added support for rendering ActiveX control and form control as option button.
• GridJs ComboBox added support for rendering ActiveX control and form control.
• Added server-side 'saveback' for Combobox selected value.
• Added 'clearHighlights' and 'updateHighlightStyle' API.
• GridJs added support for sheet loaded events.
• Added support for Microsoft Visio file type detection.
• Added support for Microsoft...

Released: Jun 8, 2023

Updates in V23.6

Funktionen

• Added support for traversing row/cell in reverse order.
• Added support for refreshing multiple consolidation ranges in a pivot table.
• Added support for showing chart sheets.
• Added support for filtering by datetime.
• Added support for rendering checkboxes as an ActiveX control or form control.
• Added support for extending rows when setting a total formula.
• Improved detection of Gzip files.
• Improved display of background image layers.

Fehlerkorrekturen

• Chart does not get updated when...

Released: May 9, 2023

Updates in V23.5

Funktionen

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

Fehlerkorrekturen

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

Released: Apr 11, 2023

Updates in V23.4

Funktionen

• 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...

Released: Mar 7, 2023

Updates in V23.3

Funktionen

• Added support for setting, reading and saving 'ENCODEURL' and 'LET' functions.
• Adds 'CalculationOptions.LinkedDataSources' property which allows the user to set linked data sources in calculation formulas.

Fehlerkorrekturen

• 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 returns when calculating SWITCH statement Array...

Released: Feb 8, 2023

Updates in V23.2

Funktionen

• Added support for parsing, reading and saving SCAN and Lambda functions.
• Added support for multiple pagination formats when converting Microsoft Excel to PPTX.
• You can now extract cell style to a generic object (i.e. JSON).

Fehlerkorrekturen

• Cell.Formula is not same as displayed in MS Excel.
• Formulas are calculated incorrectly.
• Issue with reading charts from Excel file (generated by Aspose.Cells) through Microsoft Graph API.
• Chart to PDF not same as to image.
• Text in chart in SVG has...

Released: Jan 10, 2023

Updates in V23.1

Funktionen

• 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.

Fehlerkorrekturen

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