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

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

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.