Released: May 21, 2020

V20.5 での更新項目

不具合の修正

• When the group field has a null value, the result of subtotalN loses the subtotal for the null group.
• Microsoft Excel to HTML rendering - the conversion process takes a long time.
• HTML to Excel conversion not retaining rich text format in the output.
• Rotated text is not rendered well in XLSX to HTML conversion.
• Rich text formatting lost when exporting to HTML.
• String "20TT1" replaced with number 43850 during CSV to XLSB conversion.
• After rendering a chart to an image, data labels are not...

Released: Apr 17, 2020

V20.4 での更新項目

機能

• Added the ability to display a waterfall chart legend in Turkish, similar to Microsoft Excel.
• Improved Excel to HTML rendering.
• Improved Excel to PDF rendering.

Released: Mar 20, 2020

V20.3 での更新項目

機能

• Added the ability to process sheets in a specific order.
• Added ThreadedComment.CreatedTime property.

Released: Feb 21, 2020

V20.2 での更新項目

不具合の修正

• Set image type EMF in rendered HTML file.
• Conversion to PDF - java.lang.NumberFormatException: For input string.
• Conversion to PDF - Invalid formula:"'APRIL''12'.A1:'APRIL''12'.I23".
• Conversion to PDF - hex is not a valid hex number.
• Conversion to PDF - java.lang.NumberFormatException: For input string: "341,403,811.74".
• Exception "Unexpected image type" raised while rendering worksheet to HTML.
• Program hangs while converting Excel file to HTML.
• Conversion to PDF - com.aspose.cells...

Released: Jan 17, 2020

V20.1 での更新項目

不具合の修正

• Cell.getValidation method returns null for ODS.
• XLSX to PDF, Difference in PDF output when using Oracle JDK vs Open JDK.
• Opacity is not applied to column charts.
• %of, %of Row, %of ParentRowTotal, %ParentTotal, etc. are not working in pivot output.
• Cell’s default background color is wrong in output HTML.
• SheetRender.toImage() output is incorrect.
• calculateFormula() does not calculate value.
• Percent Format Style is applied incorrectly under Norwegian Locale.
• Smaller font rendered in each...

Released: Dec 20, 2019

V19.12 での更新項目

機能

• Add tooltip text to cells when exporting to HTML.
• Added option to disable OLE object loading while opening a workbook.

Released: Nov 19, 2019

V19.11 での更新項目

機能

• Added Validation.addArea (CellArea cellArea, boolean skipArea) and Validation.setAreas() methods.
• Added the ability to read OData connection details.
• Export a print area range to HTML without implicitly changing the state of a workbook.

Released: Oct 21, 2019

V19.10 での更新項目

機能

• Added support for custom data sorting in pivot table reports.

不具合の修正

• Performance issue with calculateFormula().
• Pivot table data coloring and formatting is not rendering properly.
• PDF is not generated as expected.
• Cell.getStyle.getCustom returns wrong format for German locale.
• ArrayIndexOutOfBoundsException while loading the Microsoft Excel file.

Released: Sep 23, 2019

V19.9 での更新項目

不具合の修正

• Hidden rows are displayed while converting Excel file to HTML when AutoFilter exists.
• CalculateFormula() fails with large formula strings.
• CalculateFormula() corrupts the Excel file.
• Formatting issues while converting Excel file to PDF.
• Text overlapping after converting Chinese XLSX file to PDF.
• Workbook.setRecalculateOnOpen(false) not working for newer Excel versions.
• Data labels based on formulas are not correctly rendered in PDF.
• Exception raised while converting XLSM to image.
• "Column...

Released: Aug 21, 2019

V19.8 での更新項目

機能

• Added support for ECDSA and RSA algorithms.
• Read total page count before converting to a PDF or image.
• Insert SVG files into worksheets.
• Added support Java 12.
• Improved CPU and memory consumption during Excel to PDF conversions.