Released: Sep 14, 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 an exception “java.lang.NullPointerException” when loading XLT file.
• Fixed an issue with an exception “com.aspose.cells.CellsException: formula data should have been corrupted….” when loading an XLS file.
• Fixed an issue with an exception “java.lang.IllegalStateException: Invalid encoding: null” when loading an XLS file.
• Fixed an issue with an exception “java.lang.ArrayIndexOutOfBoundsException” when retrieving picture’s data.
• Fixed an issue with data before 2014 is not read from Pivot Table.
• Fixed an issue with wrong value #Value read by Aspose.Cells.
• Fixed an issue with being unable to transform XLSM file to PDF.
• Fixed an issue with adding formula reference to different sheet results in corrupted Excel workbook.
• Fixed ROUNDUP function issue.
• Fixed an issue where formula could not be retrieved while changing formula of neighboring cell.
• Fixed an issue where printing XLSX to XPS loses background formatting.
• Fixed issue while printing to a physical printer.
• Fixed problem with Line Height and Border while creating image from Excel area.
• Fixed an issue where setRepeatFormulaWithSubtotal(true) is not generating expected results while using SmartMarkers.
• Fixed an issue where Aspose.Cells 20.6 is not working fine with form controls on Office 365 (version 2005 Build 12827.20268).
• Fixed an issue when translating XLS to XLSX it produces a broken XLSX file.
• Fixed an issue with XLS to XLSX conversion - font boldness and positioning is changed for the shape.
• Fixed an issue where generated XLS file is in protected view.
• Fixed an issue with error in output file after replacements.
• Fixed an issue where one of the style tags found outside the Head tag.
• Fixed an issue where customized data series color is not preserved when creating a Waterfall chart.
• Fixed an issue with unintended line breaks in shapes/objects when converting Excel to PDF.
• Fixed performance issue on Excel to PDF conversion.
• Fixed an issue where expanded label cells are not merged in SmartMarker.
• Fixed an issue with saving the file using OoxmlSaveOptions after replacing text in SmartArt converts XLS to XLSX.
• 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 table.
• Fixed an issue where the result XLSB file is corrupt when saving file to XLSB.
• Fixed filter issue after refreshing a pivot table.
• Fixed an issue with filter options after PivotTable.refreshData().
• Fixed an issue where values are not fetched properly using getStringValue().
• Fixed an issue where Grid content is not visible.
• Fixed font problem on PDF conversion.
• Fixed printing issues while using physical printers, XPS and PDF printer.
• Fixed an issue with font difference while converting spreadsheet to image.
• Fixed an issue where Java version does not support loading font from current user fonts folder by default.
• Fixed an issue with Excel to TIFF rendering - some of the values are replaced with " #” chars.
• Fixed an issue with com.aspose.cells.CellsException: Error for ZipFile.
• Fixed a problem with height width ratio.
• Fixed an issue where combo chart is not displayed correctly after converting Excel file to PDF.
• Fixed line break issues while converting XLSX to PDF.
• Fixed an issue with SmartMarker: when using group:merge with Number Format Percentage, the expanding result is wrong.
• Fixed an issue with being unable to load XLSX file.
• Fixed an issue with content duplication when copying worksheet.
• Fixed an issue with WaterFall Chart not preserving SetAsTotal Property.
• Fixed an issue where adding autofilter corrupts the workbook.
• Fixed an issue where processing does not return when saving XML Spreadsheet 2003 file in MS Excel workbook format.
• Fixed an issue with an exception “java.lang.NullPointerException” when retrieving string value from the cell.
• Fixed an issue with an exception while loading XLSM file with option setKeepUnparsedData(false).
• Fixed an issue where calculation fails with NPE (java.lang.NullPointerException).
• Fixed an issue with an exception “java.lang.NegativeArraySizeException” on saving to HTML.
• Fixed an issue with an CellsException on calculateFormula method.
• Fixed an issue with an exception “java.lang.NullPointerException” when calculating pivot table in the sheet.