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