Released: Mar 11, 2024

V24.3 中的更新

特性

• Added support for EVALUATE function.
• Support for rich text when using formula editor box.
• Convert Microsoft Excel spreadsheets to ODS using ODF 1.3 standard.
• Support for processing navigation links when converting AZW3 to XLSX.

修補程式

• The ratios of width and height do not change simultaneously when Picture.IsLockAspectRatio is set to true.
• Data shift failed after calling InsertRange method.
• ISERROR function returns false for NPER #NUM! error.
• Calling recalculation on the workbook produces...

Released: Feb 6, 2024

V24.2 中的更新

特性

• Added new UUID API.
• Added support for the TOROW/TOCOL functions.
• Show "convert to number" menu for cells which have a number stored as text.
• Added support for detecting OXPS format.
• Added support for parsing color attribute containing "var" or "rgba" fields.
• Improved large dataset sorting performance.
• Added options to differentiate empty cells when exporting data to DataTable and detecting data type.

修補程式

• Shared formulas disappear in Aspose.Cells for C++.
• Obtain incorrect connection points...

Released: Jan 10, 2024

V24.1 中的更新

特性

• Added the ability to keep the header row in each worksheet when converting a CSV to Microsoft Excel.
• Added support for adding custom styles when exporting files to HTML.
• Added auto-fill support for the merge area.
• Added a build for Windows x86.
• Implemented workbook digital signatures.
• Added the ability to save as TIFF file format.
• Added support for VBA Digital Signature.
• You can now add a TIFF image to PictureCollection.
• Auto-fill data from right to left and bottom to up.
• Show the active...

Released: Dec 14, 2023

V23.12 中的更新

特性

• Improved syntax to be more concise and closer to C++ syntax:
  • Object initialization according to the C++ standard can now be completed.
  • The acquisition of objects in the data collection has been changed from GetObjectByIndex(int) to the more concise Get(int).
  • Most of the interface names have small changes, such as: GetIWorksheets() becomes GetWorksheets().
  • Several new interfaces have been added, mainly for strings, such as: "Shape::AddHyperlink(const char16_t* address)".
  • The base class...

Released: Nov 14, 2023

V23.11 中的更新

特性

• Added support for copy/delete/insert/rename worksheet operations to GridDesktop.
• Auto extend max rows/columns when performing paste operations in GridDesktop.
• Added support for 'SheetPrintingPreview' and 'PdfSaveOptions' in GridDesktop.
• You can now insert text boxes, form control for radio buttons, check boxes and combo boxes.
• Generate ISO32000-1:2008 PDFs.
• Localize dates on grouping fields.
• Added support for inserting common shapes.
• Show gradient fill for cell backgrounds.
• Added support for...

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