Released: Aug 9, 2024

V24.8 での更新項目

機能

• Added support for visiting all cells that contain "Place in Cell" pictures.
• Added support for VALUETOTEXT Function.
• 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 inconsistent with rendering to PDF via Excel...

Released: Jul 12, 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.
• Renamed the methods of ChartDataTable.
• Optimized the...

Released: Jun 18, 2024

V24.6 での更新項目

機能

• Added support for getting a DocumentProperty object from BuiltInDocumentPropertyCollection by index.
• You can now add GetIObject to Filter classes.
• Added some new members to PivotGlobalizationSettings class.
• Added support for getting a FontSetting object from Title by index and length.
• 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...

Released: May 10, 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 11, 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.
• 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...