Released: May 14, 2021

Mises à jour de V21.5

Fonctionnalités

• Added support for binding Slicer Reports with pivot tables and pivot charts.
• Added support for importing free HTML with SVG images.
• Added support for referring to spill range with #.
• Added support for moving existing columns in GridWeb.
• Added support for exporting all worksheets to CSV.
• Improved ArgumentException on CalculateFormula method.
• Improved support for ELSE function when converting XLS to XLSX.
• Added support for setting global PageOrientationType.
• Improved performance...

Released: Apr 14, 2021

Mises à jour de V21.4

Fonctionnalités

• Added support for getting display style with cache enabled.
• Added the ability to render data with cell coordinates when converting Microsoft Excel to HTML.
• Added support for Crypto with BouncyCastle API.
• Added support for XML maps by XSD.
• Added the ability to group data with Horizontal Smart Markers and a nested data sources.
• Added support for collapsible rows along with Smart markers.
• Added support for adding WebP images to XLSX files.

Correctifs

• HTML style tag consumes 4Gb...

Released: Mar 11, 2021

Mises à jour de V21.3

Fonctionnalités

• Added the ability to clear all merge areas on a sheet.
• Added the ability to digitally sign Microsoft Signature Lines in Microsoft Excel spreadsheets.
• Added Digest algorithm.
• Added the ability to convert a Signature Line to an image.
• Added support for copying QueryTable when copying workbooks.

Correctifs

• Native chart color palette is not preserved.
• Workbook.Settings.RemovePersonalInformation is not effective.
• The generated file is corrupted when saving xls file with embedded word...

Released: Feb 5, 2021

Mises à jour de V21.2

Fonctionnalités

• Added support for column percentage display to PivotTable.
• You can now use LightCells API with XLSB files.
• Updated data source when changing Waterfall chart to Column chart.
• Added support for updating display icons in embedded JPG, ZIP and MSG objects.

Correctifs

• Hang on CalculateFormula.
• Cells.DeleteBlankRows never finishes (infinite loop) on a particular worksheet.
• Loading xlsb results with OOM exception.
• Wrong position of some polylines when saving .html files.
• Arrow position...

Released: Jan 15, 2021

Mises à jour de V21.1

Fonctionnalités

• Added support for Microsoft .NET 5.0.
• Added the ability to switch row/column data series.
• Added OleObject.SetEmbeddedObject() method.
• Added the ability to get the data source range of the chart.

Correctifs

• SmartArt shapes are not rendered fine in Excel to PDF conversion.
• Shapes are not positioned correctly in Excel to PDF conversions.
• Arrow graph is incomplete.
• Diagram blocks are shifted when converting to HTML.
• Invalid CSS and HTML markup when converting XLSX to HTML.
• Unencoded...

Released: Dec 17, 2020

Mises à jour de V20.12

Fonctionnalités

• IFS formulas can now be wrapped with curly braces after saving.
• Added support for formulas with Sheet() function.
• Reduced output size when converting to HTML.
• Added the ability to display additional columns when text is overlapping next cells.
• Added the ability to remove ODS macros in Workbook.RemoveMacro.
• Added support for h1 tag when setting Cell.HtmlString.

Correctifs

• New worksheet is missing mc:Ignorable="x14ac xr xr2 xr3”.
• Conversion complex XLSM to HTML takes a lot of time...

Released: Nov 12, 2020

Mises à jour de V20.11

Fonctionnalités

• Improved support for locale-dependent formatting pattern “aaaa” for year in Spain region.

Correctifs

• Warning raised while adding 29 sheets and opening the output XLS file in Microsoft Excel.
• Text was cut when rendering PDF.
• An image becomes all white and some text corruption in other images/shapes.
• Slicer on different table generates corrupted file.
• XLSB file is corrupted after load and save.
• Chart field containing dates has different format in PDF format.
• Aspose.Cells generates...

Released: Sep 10, 2020

Mises à jour de V20.9

Fonctionnalités

• Added support for getting and setting slicer shape properties.
• GridWeb client API now supports adding and removing comments.
• Added new properties to the public API.
• Improved support for freezing and splitting worksheets.

Correctifs

• Fixed an issue where chart does not allow treating #N/A as empty cells when saving as PDF.
• Fixed an issue where Kaiti font is not properly rendered.
• Fixed an issue where query tables are not loaded from ODS file.
• Fixed an issue where macros should be...

Released: Aug 13, 2020

Mises à jour de V20.8

Fonctionnalités

• Added support for slicers in Microsoft Excel tables.
• Added client API for direct font setting in GridWeb.
• Added client API for adding/removing hyperlinks in GridWeb.
• Added ShowAddButton property to support the adding/deleting of worksheets in GridWeb.
• Added support for OTF font types for rendering purposes.
• Added support to convert workbooks into PPTX in which slides are pictures.
• Added support to convert workbooks into DOCX in which pages are pictures.
• Added support for tables...

Released: Jul 15, 2020

Mises à jour de V20.7

Fonctionnalités

• Added support for FilterString() criteria.
• Added the ability to loop over all PivotFields with a regular "for each" loop.
• Added the ability to check whether the struct or window of the workbook is protected with a password.