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.

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.