Rilasci di Aspose.Cells for Python via .NET

Released: Sep 15, 2023

Aggiornamenti in V23.9

Funzionalità

  • Added support for calculating LAMBDA, MAP and SCAN functions.
  • Added support for parsing and calculating formulas with user defined custom function and definition.
  • Added support for excluding specific data when exporting data to DataTable.
  • Added localization support to GridDesktop.
  • Added support for picture click event to GridDesktop.
  • You can now auto extend empty rows/columns when scrolling down/right like Microsoft Excel.
  • Added support for selecting text within a textbox control...

Released: Aug 23, 2023

Aggiornamenti in V23.8

Funzionalità

  • Improved UI display for dropdowns with long lists of data.
  • Added support for preserving padding space in formulas.
  • Conditional formatting formulas can now be ignored when saving to XLSB format.

Correzioni

  • CHAR function returns error value when calling CalculateFormula.
  • DataSorter does not clear old data when new data is blank.
  • Incorrect result of calculating NUMBERVALUE Formula.
  • Function’s calculated value changes from “#REF!” to “#VALUE!” after changing file format from xlsx to xls...

Released: Jul 19, 2023

Aggiornamenti in V23.7

Funzionalità

  • Added support for rendering background color and border in GridWeb Textbox control.
  • Added support for Microsoft Visio file type detection.
  • Added support for Microsoft OneNote package file type detection.
  • Added support for XAdES signatures for CSharp X509Certificate2.
  • Added support for Workbook digital signatures in Blazor Web Assembly.
  • Added support for VBA signatures in Blazor Web Assembly.
  • Added support for encrypting/decrypting ODS in Blazor Web Assembly.

Correzioni

  • Aspose.Cells...

Released: Jun 16, 2023

Aggiornamenti in V23.6

Funzionalità

  • Added support for traversing row/cell in reverse order.
  • Added support for refreshing multiple consolidation ranges in a pivot table.
  • Added support for extending rows when setting a total formula.
  • Improved detection of Gzip files.

Correzioni

  • Row with no data should be taken as blank and removed by Cells.DeleteBlankRows() even if there is merged cells intersect with it.
  • Chart does not get updated when writing new lines to a listobject with Aspose.Cells.
  • Arrow Shapes placed incorrectly...

Released: Jun 2, 2023

Aggiornamenti in V23.5

Funzionalità

  • Added support for updating external sheet data references when removing external links.
  • You can now render a checkbox as a control and not as a static picture.
  • Added the ability to set image dimension and keep aspect ratio while converting a workbook to an image.
  • You can now 'AutoFit' rows for rendering.
  • Added support for getting 'PivotArea' and 'PivotFormat'.

Correzioni

  • The file size of generated PDF is too large while converting to PDF.
  • 'Invalid column index.' on saving PDF.
  • Tick...

Released: Apr 17, 2023

Aggiornamenti in V23.4

Funzionalità

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

Released: Apr 1, 2023

Aggiornamenti in V23.3

Funzionalità

  • Added support for setting, reading and saving 'ENCODEURL' and 'LET' functions.
  • Changed System.Drawing.Common dependency to 6.0.0 for Microsoft .NET 6 and .NET 7.
  • Updated calculated column formula when copying.

Correzioni

  • Fixed issue where double/float value was inserted as integer.
  • 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...

Released: Mar 7, 2023

Aggiornamenti in V23.2

Funzionalità

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

Correzioni

  • 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

Aggiornamenti in V23.1

Funzionalità

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

Correzioni

  • JSON value is missing when a sheet is empty.
  • JsonSaveOptions.SkipEmptyRows is not...

Released: Nov 14, 2022

Aggiornamenti in V22.11

Funzionalità

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

Correzioni

  • Re-saving an XLSM file having ActiveX controls corrupted the macros in the file.
  • XLSX to PDF: Content misalignment.
  • XLS to PDF: Content misalignment in cells.
  • XLSX to PDF...