Released: Sep 26, 2017

Updates in V17.9

Features

• Added a property to indicate whether to output an empty page or not when there is nothing to print.
• Support for an Advanced Filter to display records that meet a complex criteria.
• Implementing a Named Destination when rendering to PDF.

Fixes

• Cell width shown in the resulted PDF is not the same as in the Excel file when using the "Show formula" feature.
• ResultSet imports zero instead of null value in XLSX file.
• CellsHelper.setSignificantDigits() should not be (global) static function.
• InterruptMonitor takes more time to interrupt the Workbook saving process for a large file having PivotTable.
• Formula is not displayed in the resulted PDF.
• WEEKDAY formula returns wrong value on workbook formula calculation.
• Have to enumerate all shapes to set the Z-Order of the shape properly.
• Set name of ActiveX Control (ListBox).
• PivotTable issues(missing rows, pivot field headers printed twice, Date converted to numeric values, etc.) for HTML rendering.
• Extra characters present in HTML output of Excel file.
• Image does not get displayed in the output HTML when HtmlSaveOptions.setExportHiddenWorksheet is set to false.
• HTML could not be converted to Excel file properly.
• Issue with HTML table to Excel rendering.
• Issue with calculating Print Area when specifying formulas.
• Chart does not get updated if it exists in separate sheet.
• Cell value is appended at the start when we click on an existing cell (having some value).
• When XLSX is saved as PDF, the words are mirrored.
• Extra characters present in output PDF/image of Excel file.
• Bars are missing in Bar chart's PDF output.
• Chart image is wrong in the output HTML.
• Image of the chart is incorrect in the output HTML.
• Content is missing when Excel Chart is converted to PDF.
• Chart's PDF has wrong date format of x-axis labels.
• Incorrect Y-axis scaling in the output PDF.
• Style/formatting is wrong when save to HTML.
• Option to compress images is not preserved on opening and saving the Excel file.
• Background color of cells in File1 gets changed on opening and saving Workbook.
• Excel formula cell becomes non-formula cell when setting text for the shape.
• Workbook.getFonts() shows additional font after reloading the same spreadsheet.
• Some shapes are distorted and changed in Excel to PDF rendering.
• Mdashes and ndashes inserted into TextBoxes in charts are not rendered properly in chart's PDF.
• Wrong results when using SUMIFS formulas.
• Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheet.
• Weird result when converting from Excel to PDF or PDF/A using threads.
• Changes to comment author field are not preserved.
• Wrong IconSet returned.
• Chart's background is missing after setting a picture's data.
• Aspose.Cells is not able to convert the HTML file correctly while MS-Excel is able to convert it properly.
• For Number 39 MS Excel formats negative value with '-' instead of '()' for Italy.
• Label text is displaced for the Pie chart.
• Various styles of the Waterfall chart don't render properly.
• The Waterfall chart always shows connection lines.
• Shape is not updated with correct value.
• Excel to PDF conversion hanged for an XLSX file.
• Unable to import XLSB file (by Aspose.Cells APIs) into MS-Access database.
• HTML output of Excel document contains hash values instead of actual values.
• Saving "2.2 CompleteEmail.html" to Xlsx format generates corrupt file.
• Loading "2.1 CompleteEmail.html" in Workbook object throws NullPointerException.
• Workbook Calculation is wrong for Lookup Excel formula.
• Array formula in the sheet is calculated differently via Aspose.Cells.
• Incorrect Hyperlinks and PDF content.
• Rendering - Chart image is not correct.
• Category axis labels are missing when converting Excel to Pdf.
• Color of Negative Bars is not correct when Excel is converted to Pdf.
• Bar color changed while converting Excel to PDF when using setCrossAt().
• Value of major units of axis in the chart is returned wrong.
• Datalabels from cell range are not coming when exported to Pdf.
• Missing Datalabels for a Series which is having Bar Values as 100.
• Chart is Blank in the output PNG.
• Chart is Blank in the output PDF.
• Character references parsed incorrectly by Aspose Cells.
• Copying workbook and then saving corrupts the output Excel file.
• Exception "com.aspose.cells.CellsException: unknown excel content!" on instantiating an encrypted Excel file.
• Exception: "The row index should not be inside the pivottable report" occurred when rendering to HTML file format.
• Exception: "Row index cannot be negative" occurred if a PivotTable exists in the worksheet to be converted to HTML file format.
• An exception is thrown when trying to open Workbook.
• Exception: "java.lang.NullPointerException" when opening an ODS file via Aspose.Cells APIs.
• NullPointerException on creating Workbook instance from source Excel file.
• Exception in thread "Thread-2" java.lang.OutOfMemoryError: GC overhead limit exceeded.
• Exception "Error for ZipFile" is thrown when using OutputFileStream.
• com.aspose.cells.CellsException: Invalid password on opening the Excel file.
• Exception occurs when saving an Excel file into HTML format.