Released: Sep 16, 2021

Updates in V21.9

Features

• Added the ability to digitally sign VBA code projects with a certificate.
• Added the ability to get external data ranges and details.

Fixes

• Large amount of unused styles being generated into the CSS section.
• Creation date and time and modification date cannot be extracted.
• SheetRender does not render the flow chart correctly.
• Missing text in circle during XLS to HTML conversion.
• When executing SVG to insert Excel under Java, it exits abnormally.
• Percentage data from a Pivot Table is not showing properly in HTML.
• Superscripts and subscripts not formatted correctly when converting an HTML document to a Workbook.
• Incorrect value read using getStringValue() function.
• MDURATION formula issue.
• Creation date and time and update date cannot be extracted.
• Unable to extract BuiltInDocumentProperties.
• Date and time property results are different.
• Equation in a TextBox does not render to PDF.
• Text not centered in the output PDF in Excel to PDF conversion.
• Shapes are not retrieved in the ODS file format.
• PNG output of MS Excel chart has discrepancies.
• Issue with SheetRender.toImage() while using setPrintArea() method.
• Chart points font boldness changes after workbook copy.
• Aspose Cells ignores inverted y-axis in diagram.
• Chart is messed up upon re-saving the Excel file using Aspose.Cells for Java.
• Problem extracting chart series names.
• Shape objects changed while loading and saving XLS file.
• Incorrect comment’s author is retrieved.
• Graphic text values are not displayed when converting XLSX to PDF.
• Text after a “br” tag within an “em” tag is not emphasized when converting an HTML document to a Workbook.
• IllegalArgumentException: Invalid column index.
• Incorrect color when save as HTML.
• Regression: MDURATION formula not calculated properly.
• Power operator “^” is not working for formula calculations.
• Image missing in the Output PDF.
• Default fonts on MacOS Big Sur.
• Axis Labels are not displaying correctly - Right Alignment missing when saving Excel to PDF.
• Chart datatable text is not shown int the output image.
• XLSX to PDF: Incomplete diagram title.
• Apple iWork Support.
• Conversion to PDF - Unsupport file format Number3.5 since 2014.
• Chart with No Data causes XLSX to become corrupt after saving with Aspose Cells.
• AutoFitRow changes worksheet standard height.
• Error when open file in MS Excel saved by Aspose.Cells.
• XLSX to PDF: Shape to image Error.
• Image distortion during Excel to HTML.
• Details changed on Excel to HTML conversion.
• Formatting issues while converting Excel to HTML.
• Text Alignment issue during Excel to HTML conversion.
• Hyperlink function hyperlink is invalid when Excel is converted to HTML.
• When exporting HTML, the length of the data bar is shorter than that in Excel.
• Re-saved XLSM file cause file corruption popup when opening by ms Excel.
• Array formula evaluation problem.
• Databar issue of conditional formatting in the generated PDF.
• Setting the conditional formatting to cell and using DataBar.toImage result in blank picture.
• The font in the cell is not fully displayed When Excel file is converted to PDF.
• Not able to convert complex HTML into CSV.
• Text orientation changed while Excel to PDF conversion.
• Excel to HTML rendering - issue with conditional formatting to hide borders.
• Font is incorrect when setting HtmlLoadOptions for HTML to Excel conversion.
• DataLabels truncation issue When Converting XLSX to PDF.
• Donut chart labels misplaced.
• Vertical axis values and point labels are not rendered properly when rendering Excel file (containing Waterfall chart) to HTML.
• Function RANDBETWEEN(bottom, top) value results are different from Excel results.
• Wrong rendering of HTML after conversion from XLSX.
• HTML to Excel conversion - “mso-ignore: padding” in CSS have no effect.
• Background text formatting changed while merging files.
• MSO Excel (XLS) document cannot be loaded.
• Aspose.Cells for Java NullPointerException.
• Invalid password exception.
• CellsException for reading shape’s macro name: Invalid formula.
• “java.lang.ClassCastException” on reading XLSB file with LightCells.
• NullPointerException when extracting series name of chart.
• Exception “java.lang.NullPointerException” when loading XLSM file.
• ArrayIndexOutOfBoundsException with getStringValue.
• Exception raised while setting value for chart series.
• Exception “Invalid FontUnderlineType string val” when loading an XLSX file.
• Exception “Invalid MsoLineDashStyle string val” when loading an XLSX file.