Released: Jul 13, 2024

V24.7 中的更新

特性

• Added support for the DROP function.
• Added support for outlining the star characters in the chart.
• Added support for DateOnly when calling ImportCustomObjects method.
• Added support for making an object as decorative in XLSX.
• Improved the performance of calculating LET function with complex parameters.
• Improved the performance of calculating MAKEARRAY function.
• Added support for swapping series.
• Changed ArgumentException to CellsException.
• Added "ApplyFont" in series datalabels.
• Renamed the...

Released: Jun 15, 2024

V24.6 中的更新

特性

• Added color saturation and color temperature adjustment functions for images.
• Image Recoloring: Added the ability to render duotones.
• Added support for outlining the star characters in chart.
• Added support for Range.ToHtml() method.
• Added support for aligning axis x values to the right when converting chart to image.
• Added support for converting workbooks containing Webp images to PDF and image for .NET 6.0, 7.0 and 8.0 on Linux.
• Added support for Range.ToImage() method.
• Enhanced merging...

Released: May 11, 2024

V24.5 中的更新

特性

• Added support for new XMATCH and XOR functions.
• Added the ability to transpose data of the range.
• Added support for obtaining properties of advanced filtering settings.
• Added support for determining whether the ReferredArea is a entire row or a entire column.
• Added the ability to export metadata of a cell into PDF, image and HTML.
• You can now process font RGBA color with style background color.

修补程序

• Floor function returns #NUM! for negative number.
• Remove picture in cell when set value to the...

Released: Apr 12, 2024

V24.4 中的更新

特性

• Added support for converting ChartX to image.
• Provided simple implementation of 'interrupt monitor'.
• Added the ability to embed attachments when converting OLE Object to PDF file.
• Added support for embedding images into cells for XLSB files.
• Added support for hiding rows and columns when exporting Numbers files to XLSX.
• Added support for merging cells in Numbers file export to XLSX.
• Added support for exporting charts from Numbers files to XLSX.
• Added the ability to export picture in cell to...

Released: Mar 11, 2024

V24.3 中的更新

特性

• Added support for EVALUATE function.
• Improved filtering in GridDesktop.
• 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...

Released: Feb 5, 2024

V24.2 中的更新

特性

• Added support for the TOROW/TOCOL functions.
• Show "convert to number" menu for cells which have a number stored as text.
• Added support for copying/pasting image and HTML content to GridDesktop.
• Added key word search support for filter list to GridDesktop.
• Added support for clear filter operation to GridDesktop.
• Added support for number filter for GridDesktop.
• Added support for detecting OXPS format.
• Added support for parsing color attribute containing "var" or "rgba" fields.
• Improved large...

Released: Jan 12, 2024

V24.1 中的更新

特性

• Added the ability to keep the header row for each worksheet when converting a CSV to Microsoft Excel.
• Added support for Microsoft .NET 8.
• Added a new GridDesktop auto-fill feature.
• Added support for adding custom styles when exporting files to HTML.
• Added auto-fill support for the merge area.
• Added support for setting wrap using the UI.
• Added support for setting text rotation using the UI.
• Auto-fill data from right to left and bottom to up.
• Show the active sheet background in the bottom tab...

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