Released: Apr 15, 2021

Updates in V21.4

Features

• Added the ability to access data in batch mode with improved performance.
• Added the ability to process the leading single quote of cell’s value when exporting/importing CSV/TSV files.
• Added the ability to override the default rules of string comparison.

Fixes

• Sorting is not working when data contains non alpha numeric characters.
• Text placement shifted to the left when saving as HTML.
• Escape and line break chars not correctly rendered when converting HTML to Excel.
• Conditional Format...

Released: Mar 12, 2021

Updates in V21.3

Features

• Added support for UNIQUE() function.
• Added the ability to read chart sub titles.
• Added support for Japanese unified formatting results.

Fixes

• Conditional formatting is not rendered properly in ODS to HTML conversion.
• The output file is corrupt after copying workbook.
• Issues while converting HTML to Excel.
• CalculateFormula() creates lot of error type values #VALUE.
• Percentage issue for labels when printing charts.
• Percentages issue for some labels when rendering to PDF and printing...

Released: Feb 5, 2021

Updates in V21.2

Fixes

• Copy produces corrupted workbook.
• Issue when saving chart having image in the marker to image.
• Workbook/Worksheet Password Protection settings lost when saving as XLSB file format.
• Copying sheet produces corrupt workbook.
• Exporting single sheet to HTML raises Exception.

Released: Jan 15, 2021

Updates in V21.1

Features

• Added the ability to validate VBA project passwords.

Fixes

• XLSX to PDF conversion hangs.
• Different diagrams on Excel to PDF.
• Images placement issues while converting Excel to HTML.
• DAYS function calculation error.
• Combo chart can't display correctly in Excel to PDF.
• Percentages was not showed at the small histograms.
• Error with form controls or ActiveX controls when saving as EXCEL_97_TO_2003.
• Corrupted file created while converting ODS to XLSX.
• Display as blank changes from true to...

Released: Dec 18, 2020

Updates in V20.12

Features

• Added support for calculating ISFORMULA function.

Fixes

• Difference in output while converting Excel file to PDF.
• Output file is corrupt when adding more than 12 fields in the pivot table page filters.
• Background colour of header table is not right while converting to PDF.
• Text is missing while HTML to Excel conversion.
• Extra empty columns while exporting CSV with LightCellsDataProvider.
• Excel file converted to PDF produces an issue of large numbers.
• Image is misplaced while converting...

Released: Nov 13, 2020

Updates in V20.11

Features

• Added new Shape.getWorksheet() property which gets the worksheet which contains a shape.
• Added the ability to handle scenarios with incorrect font types.

Fixes

• Issue of getting cell value with formula.
• Issue after resaving XLSB file - corrupted file.
• Images and text positioning wrong when rendering Microsoft Excel as HTML.
• AutoFilter issue - blank rows are displayed.
• Deadlock occurred while calculating formulas on workbook.
• Chart label changes its position when printed.
• 0/100% line not...

Released: Oct 19, 2020

Updates in V20.10

Fixes

• Fixed an issue where the arrow direction has changed in the resultant PDF.
• Fixed an issue where Refresh pivot not working and corrupts the output file.
• Fixed Aspose.Cells conflicts with HtmlHiddenRowDisplayType.REMOVE settings.
• Fixed issue with getting Cells value.
• Fixed an issue with HTML to Excel conversion with wrapText property.
• Fixed cell value issue after pivot table refresh.
• Fixed issue with getting the Cell value.
• Fixed an issue where chart not printed while using Aspose.Cells for...

Released: Sep 11, 2020

Updates in V20.9

Features

• Added new properties to the public API.

Fixes

• Fixed an issue where pivot table is not created for ODS file.
• Fixed an issue with a SmartMarker problem when a cell is set fill color and conditional formatting.
• Fixed an issue with not being able to get value from pivot sheet.
• Fixed an issue where image shrinks after setting width scalable.
• Fixed filter issue after the pivot table refresh.
• Fixed refresh pivot table issue.
• Fixed an issue where static filters are lost after refreshing the...

Released: Aug 14, 2020

Updates in V20.8

Fixes

• Style tag found outside Head tag.
• Customized data series color is not preserved when creating Waterfall chart.
• Unintended line breaks in shapes/objects when converting Excel to PDF.
• Performance issue on Excel to PDF conversion.
• Expanded label cells are not merged in SmartMarker.
• Saving file using OoxmlSaveOptions after replacing text in SmartArt converts XLS to XLSX.
• CellsException on calculateFormula method.

Released: Jul 15, 2020

Updates in V20.7

Features

• Added Cells.RemoveDuplicates() method - Overloaded method of Cells.RemoveDuplicates(...) for user's convenience to remove duplicated rows in the whole sheet.
• Added TickLabels.DisplayNumberFormat property - Gets and sets the display number format for tick labels.
• Added Cells.GetViewRowHeight() and Cells.GetViewRowHeightInch() methods - Gets the view row height.
• Added enum SheetType.InternationalMacro - Adds new sheet type: international macro.
• Added PivotFieldCollection.iterator() method...