Released: Sep 13, 2022

V22.9 での更新項目

機能

• Added support for sorting 'PivotField' via a calculated field.
• Added support for specifying which sheets to output when exporting to PDF/XPS.
• Export formulas to HTML depending on 'HtmlSaveOptions.Exportformula' option.
• Enhanced parsing of HTML strings to cells.

不具合の修正

• Drawing shape is not rendered in Excel to PDF rendering.
• Investigate rules of ms excel to display cell’s border when adjacent column is hidden: cell’s border has not been synchronized.
• Bad conversion to PDF from XLS with Line Callout at the left of the sheet.
• Pivot table calculated fields not getting refreshed on updating data source.
• Cell.getDependents() throws Exception or cannot provide all dependents.
• Issue with border (line) style.
• Border line does not display.
• Issue with Formulas in the output HTML - Excel to HTML conversion.
• When exporting to HTML, the legend in the chart is not the same as MS Excel.
• Text rotation of labels does not match with Excel in the output image of the chart.
• Unable to display Treemap chart with negative value causing execution to keep running.
• The title text of chart(2016) is incorrect when Title.IsAutoText is true.
• Regression: Waterfall chart legend language issue.
• Chart issue during combining files.
• Table styling lost when copying sheet.
• Setting date before 1581 to a cell generated incorrect date string.
• Copy worksheet across workbooks, the cell format is abnormal.
• Aspose.Cells formula calculation engine produces ?#N/A? values for certain cells.
• Bug of formatting 0.9999999999999999 with custom “#” for JDK8 or later versions.
• Data is messed up when opening an Excel document with hidden columns into GridWeb (Java).
• Investigate the row resize issue when resize to very little height.
• Bottom border lost at the last row in the workbook.
• Excessive memory usage on conversion of Excel file to HTML.
• Excel to PDF conversion using Aspose.Cells for Java v22.7 causes garbled characters.
• Line break is not right in the output xlsx after set HTML string into cell.
• Table header row styling lost when copying sheet.
• Issue with character string replacement of textbox placed in Excel spreadsheet.
• Endless saving workbook to HTML format (2892).
• Concurrent loading of workbooks throws spurious “File is corrupted” errors.
• Borders and fewer lines shown in black and white pie slices in chart to image rendering.
• Text rotation of labels does not match with Excel in the output image of the chart.
• Chart labels overlapped in chart to image rendering.
• The display of cell text does not same as in excel in some merged areas.
• Multi pages are output instead of one page as in Excel while converting to PDF.
• Unable to decrease the plot area for the chart.
• MS Word prompts an error “Word found unreadable content in…” when opening the converted DOCX from XLSX file by Aspose.Cells for Java.
• Text color is not applied to different words or part of contents in the output Excel file when using Cell.setHtmlString() method.
• The border is incorrect when the static Excel file is converted to HTML.
• Excel to HTML conversion - Sparkline (mini chart) is not displayed/rendered.
• Some HTML formattings are not working for worksheet cells in an existing Excel file.
• Exception “java.util.zip.ZipException: invalid entry size (expected 0 but got 1053 bytes)” while converting XLSX to PDF.
• Exception “java.lang.IllegalArgumentException: can’t parse argument number: 1:X8” when loading the Excel file using “org.apache.commons.io.input.AutoCloseInputStream”.
• Error when saving as PDF - Investigation required.
• Exception “java.lang.OutOfMemoryError: Java heap space” when converting an XLSX file to PDF.