Released: Oct 11, 2024

V24.10 での更新項目

機能

• Added support for deleting blank rows/columns between a user specified range.
• Added the ability to get or update server side info for GridWeb .NET 6.
• Added support for getting the source of a pivot table from a corresponding external connection.
• Added support for getting the source of DataModelConnection.
• Added the ability to create compact pivot tables.
• Added support for formatting date as 1900-2-29 to mimic Microsoft Excel's behavior.
• Enhanced converting pivot area to range.
• You can now...

Released: Sep 10, 2024

V24.9 での更新項目

機能

• Added support for reading, storing and rendering limit equations and equation groups.
• Added support for exporting equation content to MathML format.
• Added support for choosing whether equations should be output as images or MathML strings.
• Added support for exporting cell address as attribute when saving HTML.
• Added support for translating "Sum of" column in PivotTable reports.
• Added support for getting formulas of pivot calculated items.
• Added support for getting formulas of pivot calculated...

Released: Aug 8, 2024

V24.8 での更新項目

機能

• Added support for visiting all cells that contain "Place in Cell" pictures.
• Added support for VALUETOTEXT Function.
• Added GridWeb support for .NET 6.0 on Linux.
• Added the ability to sort Pivot Table by Pivot Field Item.
• Added support for sorting by specific pivot item.
• Added support for editing formulas with blank spaces.

不具合の修正

• Do not encrypt document properties when encrypting file.
• Some characters are rendered in wrong positions in Excel to PDF.
• Rendering of text content to PDF is...

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

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