Released: Mar 10, 2022

Mises à jour de V22.3

Fonctionnalités

• Added support for sorting PivotFields using the values in a selected row/column.
• Added support for re-calculating cells that reference a defined name.
• Added SaveFormat.Ots and SaveFormat.Xlt enums.
• Added support for setting range borders.

Correctifs

• Pivot table not sorting on refresh.
• Deleting worksheet deletes Slicers.
• Regression: After copying range of cells formulas are lost.
• Conditionally formatted fields are not colored in the right color.
• Formulas were not calculated...

Released: Feb 11, 2022

Mises à jour de V22.2

Fonctionnalités

• Added the ability to extract all the NameCollections of a particular worksheet.
• Added StandardHeightInch property to Cells class.

Correctifs

• Various formatting and other shapes rendering issues in PDF and HTML of Excel file.
• Some shapes are not rendered properly in Excel to PDF conversion.
• Invalid value for external reference in DataSource field of Pivot Table.
• Regression: CSV to PDF conversion not working.
• Empty CellsArea array returned for CSV/TSV files.
• Finnish language...

Released: Jan 7, 2022

Mises à jour de V22.1

Fonctionnalités

• Added support for returning original indices of sorted rows/columns.
• Added the ability to set print job name, with PrinterSettings, while rendering to printer.
• Added the ability to ignore hidden rows and columns when getting Cells.MaxDisplayRange.

Correctifs

• Incorrect result for calculating FREQUENCY function in array formula.
• Unsupported function: CUBESET.
• Different behavior about collapsing and expanding multi level groups.
• BMP image files don’t display in header/footer.
• XLS to...

Released: Dec 8, 2021

Mises à jour de V21.12

Fonctionnalités

• Added support for converting Microsoft Excel to SQL scripts.
• Added support for converting Excel to XML data.
• Added support for importing XML data.
• Updated priorities when adding new format conditions.
• Sorting with DataSorter now affects table formatting.
• FormatConditionCollection.AddCondition() now gives different behavior for the formula.
• Added filter option for revision logs while creating workbook from template file.
• Added the ability to ignore 3D references for conditional...

Released: Nov 8, 2021

Mises à jour de V21.11

Fonctionnalités

• Added support for XLOOKUP formula/function.
• Added support for saving images with workbook.Save() method.
• Added support for saving as a JSON file.
• Added the ability to retrieve formatted cell values against certain cells.
• Added the ability to clear defined names when clearing worksheets.
• Improved performance when converting Microsoft Excel to HTML.

Correctifs

• 3D, the shape of the cloud changed.
• Bug of saving external NamedRange which references to range of multiple sheets.
• Single...

Released: Oct 14, 2021

Mises à jour de V21.10

Fonctionnalités

• Added the ability to open files with HTML tables as XLS files.
• Added support for the Range.CurrentRegion property.
• Updated hyperlink(Sheet1!A1) when changing the name of the worksheet.
• Improved support for autofill range with fill type.
• Added the ability to remove invisible shapes when rendering HTML.

Correctifs

• Conditional formatting of ODS is lost in Microsoft Excel if type is “Contains Text”.
• Issue with retrieving Ranges (RefersTo) with an offset function.
• Application halts...

Released: Sep 15, 2021

Mises à jour de V21.9

Fonctionnalités

• Added support for rendering Microsoft Excel 2016 Box and Whisker charts to an image.
• Added the ability to delete pivot tables while preserving data.
• Added support for named range of whole row/column for ODS files.
• Added support for setting the transparency of pictures in XLSX files.
• Improved the changing of a threaded comment’s author.
• Improved cell iterator access when rendering GridDesktop.
• Improved performance when writing ODS files.

Correctifs

• Excel document is not converted...

Released: Aug 12, 2021

Mises à jour de V21.8

Fonctionnalités

• Added support for scaling worksheet pages when exporting to HTML.
• Added support for XML maps.
• Added support for reading the latest Apple .numbers file format.
• Added auto-fill (pattern) for numbers, text or dates.
• You can now merge more empty spaces in output HTML.

Correctifs

• License is not working in release version of MVC application when deployed on IIS server.
• Hang on save to HTML for the XLSB file.
• Object with rotation is distorted.
• Shift in the texts in the diagram shapes...

Released: Jul 13, 2021

Mises à jour de V21.7

Fonctionnalités

• Added the option to apply conditional formatting on Pivot Tables.
• Added the ability to create conditional formatting on PivotTable via PivotField in row area, column area and data area.
• GridWeb - You can now run formulas similar to GridDesktop feature.
• Added GridWeb rows and columns grouping feature.
• Added the ability to preserve text formatting while converting from HTML to XLSX.
• Added the ability to show cell comments (rich text) exactly as in Microsoft Excel.
• Added support for...

Released: Jun 16, 2021

Mises à jour de V21.6

Fonctionnalités

• Added the ability to get the value of SlicerCacheItem in the Slicer.SlicerCache.SlicerCacheItems collection.
• Added support for custom Slicer styles in XLSB.
• Added the ability to set user defined formulas as array-formulas and at the same time provide values as calculated results for those formulas.
• Added the ability to embed fonts with ANSI encoding.
• Added the ability to check if a worksheet is empty.

Correctifs

• Deep copy of Workbook after calculation with CreateCalcChain setting...