Released: Feb 11, 2022

Updates in V22.2

Funktionen

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

Fehlerkorrekturen

• 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

Updates in V22.1

Funktionen

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

Fehlerkorrekturen

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

Released: Dec 8, 2021

Updates in V21.12

Funktionen

• 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

Updates in V21.11

Funktionen

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

Fehlerkorrekturen

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

Released: Oct 14, 2021

Updates in V21.10

Funktionen

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

Fehlerkorrekturen

• 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

Updates in V21.9

Funktionen

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

Fehlerkorrekturen

• Excel document is not...

Released: Aug 12, 2021

Updates in V21.8

Funktionen

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

Fehlerkorrekturen

• 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

Updates in V21.7

Funktionen

• 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

Updates in V21.6

Funktionen

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

Fehlerkorrekturen

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

Released: May 14, 2021

Updates in V21.5

Funktionen

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