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