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

Released: Apr 14, 2021

Updates in V21.4

Funktionen

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

Fehlerkorrekturen

• HTML style tag consumes 4Gb...

Released: Mar 11, 2021

Updates in V21.3

Funktionen

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

Fehlerkorrekturen

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

Released: Feb 5, 2021

Updates in V21.2

Funktionen

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

Fehlerkorrekturen

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

Released: Jan 15, 2021

Updates in V21.1

Funktionen

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

Fehlerkorrekturen

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