Lancements de Aspose.Cells for .NET
Released: Jun 8, 2023
Mises à jour de V23.6
Fonctionnalités
- 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.
Correctifs
- Chart does not get updated when writing...
Released: May 9, 2023
Mises à jour de V23.5
Fonctionnalités
- 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'.
Correctifs
- The file size of generated PDF is too large while converting to PDF.
- 'Invalid column index.' on saving...
Released: Apr 11, 2023
Mises à jour de V23.4
Fonctionnalités
- 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...
Released: Mar 7, 2023
Mises à jour de V23.3
Fonctionnalités
- 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.
Correctifs
- 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
Mises à jour de V23.2
Fonctionnalités
- 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).
Correctifs
- 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
Mises à jour de V23.1
Fonctionnalités
- 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.
Correctifs
- JSON value is missing when a sheet is empty.
- JsonSaveOptions.SkipEmptyRows is not...
Released: Dec 9, 2022
Mises à jour de V22.12
Fonctionnalités
- Added support for Microsoft .NET 7.
- Added support applying custom chart templates in CRTX files.
Correctifs
- Images are distorted in Excel to PDF/HTML rendering.
- Image rotation effect is not displayed correctly in PDF/HTML.
- The rectangular box rotation effect in the graphics group is not displayed correctly in PDF/HTML.
- Some shapes are changed after converting Excel file to PDF.
- Boxes changed when converting XLSX document to PDF.
- Drawing shapes not rendered fine in HTML.
- The...
Released: Nov 10, 2022
Mises à jour de V22.11
Fonctionnalités
- Added support for copying timelines.
- Distinguish or differentiate between 'CSE' legacy array formulas and normal array formulas.
- Added support for disabling merged table cells when saving to HTML from XLSX.
- Added support for parsing collapsed properties when converting from HTML to Microsoft Excel.
Correctifs
- XLSX to PDF: Content misalignment.
- XLS to PDF: Content misalignment in cells.
- XLSX to PDF: Shapes missing/Layout collapse.
- Character printing and spacing in the figures of...
Released: Oct 11, 2022
Mises à jour de V22.10
Fonctionnalités
- Added support for CRTX files.
- PivotTable Timeline Filter now disappears after loading and updating Microsoft Excel documents.
- You can now translate legend labels in accordance with locale/regional settings.
Correctifs
- MAXIFS formulas take long time to be calculated.
- It’s not allowed to push non-empty cells off the end of the worksheet error when using Cells.InsertRows method.
- External Link of Pivot table got deleted when converting XLS file to XLSM.
- XLSX file with PivotTable file...
Released: Sep 8, 2022
Mises à jour de V22.9
Fonctionnalités
- Added support for discrete grouping of data in XLS files.
- Added support for preset settings for gradient fill.
- Added support for setting table formula in datatable.
- Added support for converting OZM to LBM using the CONVERT function.
- Improved the recognition of user’s input for 'Style.Custom'.
- Added support for multiple tables in a worksheet of .Numbers files.
- Added support for exporting empty cells as null to JSON.
- Improved the ability to detect whether the first row is header...