Released: Dec 8, 2021

Updates in V21.12

Features

• 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 formatting when copying to another workbook.
• Added the ability to read data from corrupt XLS files.
• Added support for setting the custom total row formula of a table.

Fixes

• Performance issue with ExportImagesAsBase64 attribute in Excel to HTML conversion.
• RefersTo of defined range is incorrectly escaped.
• Empty cells are still exported as empty XML elements.
• Text is not center aligned with ‘Credit Suisse Type Light’ font while rendering to EMF.
• Words appearing in reverse order for Right-to-Left text in XLSX to PDF rendering.
• XLSX to PDF: Page break is different comparing with Excel generated PDF.
• Characters do not fit on one page and print position is changed in Excel to PDF rendering.
• Cannot view specific XLS file with HTML markup.
• Differences in chart1.xml after saving.
• XLSX to EMF overlapping Tick Marks.
• Chart to PNG dates not converted properly.
• Regression: Issue when converting chart to PNG.
• Overflow error when saving XLS document to XLSX/XSLM.
• Merged Area displays wrong when converting to HTML.
• Excel original grid should not be changed when saving HTML file.
• Picture: FitToCell parameter is not working in image smart markers.
• The header gets wider when combining multiple sheets in Excel spreadsheets.
• Show border of the cells while fit images to the cells using Smart Markers.
• Aspose-generated XLSX files opening with error.
• Add worksheet fail when Hyperlink has a null address.
• Exception when open ODS file.
• Exception when re-saving an XLSX file.
• System.NullReferenceException when copying Workbook.