Released: Mar 12, 2021

V21.3 での更新項目

機能

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

不具合の修正

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

Released: Feb 5, 2021

V21.2 での更新項目

不具合の修正

• 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

V21.1 での更新項目

機能

• Added the ability to validate VBA project passwords.

不具合の修正

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

Released: Dec 18, 2020

V20.12 での更新項目

機能

• Added support for calculating ISFORMULA function.

不具合の修正

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

Released: Nov 13, 2020

V20.11 での更新項目

機能

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

不具合の修正

• 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

V20.10 での更新項目

不具合の修正

• 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

V20.9 での更新項目

機能

• Added new properties to the public API.

不具合の修正

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

Released: Aug 14, 2020

V20.8 での更新項目

不具合の修正

• 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

V20.7 での更新項目

機能

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

Released: Jun 15, 2020

V20.6 での更新項目

機能

• Added the ability to calculate the grand total for every row in several expanded columns.
• Added support for handing scenarios when specifying incorrect font types.