Lançamentos do Aspose.Cells for .NET
Released: May 9, 2023
Atualizações na V23.5
Recursos
- 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'.
Correções
- The file size of generated PDF is too large while converting to PDF.
- 'Invalid column index.' on saving PDF...
Released: Apr 11, 2023
Atualizações na V23.4
Recursos
- 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...
Released: Mar 7, 2023
Atualizações na V23.3
Recursos
- 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.
Correções
- 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 Formula...
Released: Feb 8, 2023
Atualizações na V23.2
Recursos
- 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).
Correções
- 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 wrong...
Released: Jan 10, 2023
Atualizações na V23.1
Recursos
- 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.
Correções
- JSON value is missing when a sheet is empty.
- JsonSaveOptions.SkipEmptyRows is not working...
Released: Dec 9, 2022
Atualizações na V22.12
Recursos
- Added support for Microsoft .NET 7.
- Added support applying custom chart templates in CRTX files.
Correções
- 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 defined name...
Released: Nov 10, 2022
Atualizações na V22.11
Recursos
- 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.
Correções
- 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 Excel is...
Released: Oct 11, 2022
Atualizações na V22.10
Recursos
- 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.
Correções
- 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 is...
Released: Sep 8, 2022
Atualizações na V22.9
Recursos
- 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 row...
Released: Aug 4, 2022
Atualizações na V22.8
Recursos
- Added support for expand/collapse button style for PivotTable.
- Added the ability to convert threaded comments to HTML.
- Added the ability to copy row height when processing smart markers of a table.
- Added the ability to delete grouped shapes from a group.
Correções
- Wrong vertical alignment of cell text on convert to PDF from Excel file with pivot table.
- Shared formulas were copied incorrectly for different file formats.
- Wrong word wrapping on converting to PDF from Excel file with pivot...