Released: Jun 8, 2017

Mises à jour de V17.5.0

Fonctionnalités

• Added GetPaperWidth and GetPaperHeight methods to the PageSetup class.
• Added support for Gradient Fill in WordArt while converting spreadsheets to HTML.
• Added support Excel 2016 TreeMap and Waterfall Charts.
• Added support for converting text to columns.
• Support for DBNum (custom pattern) formatting.
• Added options to embed hyperlinks in an Excel cell.

Correctifs

• Gridlines behind Shapes are not exported when converted to HTML.
• Some CSS rules ignored when importing HTML.
• Contents are striked through in the converted HTML.
• Text style of some cells is wrong when saved to HTML.
• DataBar wrong when cell has background color set.
• Chart picture is not getting saved when EMF or SVG format is used.
• HtrmlSaveOptions.ExportGridLines does not seem to be working for a particular spreadsheet.
• Recalculating a number of formulas using Aspose Cells APIs results in "#NUM!" error.
• Date format problem while importing CSV with ICustomParser.
• Name.getRanges() API produces unexpected results.
• Unable to access the instance variable m_LoadDataFilterOptions while overriding the startSheet method of LoadFilter class.
• Cell string value & rounding problem based on different JDK versions.
• Right-to-left and left-to-right control characters are not rendered correctly in PDF when conversion is done on Linux.
• Hebrew - In the table the word wrapped lines are aligned to the right in PDF while they should be centered as in Excel.
• Wrong conversion of Arabic worksheet to SVG.
• Hebrew - Wrapped text is not right-aligned in PDF as in Excel.
• Hebrew - Series labels when there is a word wrap the characters are not displayed in the right sequence.
• Shape to image Error while rendering 02.xls to PDF.
• Chart image in the HTML is wrong.
• Uneven lines' thickness at intersections while rendering spreadsheet with diagram to PDF.
• Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF file.
• Angle of x-axis labels is incorrect in Chart's PDF.
• Incorrect rendering of bar charts while rendering spreadsheet to HTML.
• Setting formula referring to external workbook creates 3d formula.
• Unreadable content error in Excel 2007 after resaving a spreadsheet.
• Conditional format expression changes on deleting rows.
• Cell.getFormula() returns broken formula for a cell.
• Output file gets corrupt after executing DataLabels.setPosition() method.
• Conditional format priority order changes on Cells.deleteRows() method.
• Vba module is lost while re-saving an XLSM file on Linux.
• API adds extra apostrophes to the modified formula.
• Dynamic formula in designer spreadsheet using {-1} {-2} return Invalid formula error.
• Transparency of the shapes is reset to 0 while converting XLS to XLSB.
• Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML.
• Save as PDF does not preserve formatting.
• Excel formula is not working and shown as "#DIV/0!".
• Concurrent save issue.
• Top and bottom borders of cells are gone while converting to HTML.
• Excel formula is not working properly.
• List data validation drop down does not close when reloading data.
• PageSetup.BlackAndWhite does not seem to work.
• Waterfall chart, when calculate() is called, chart series colors are reverted.
• Logarithmic scale bug in Excel causes Aspose.Cells to hang.
• Vertical axis bound values changed while rendering spreadsheet to PDF.
• Horizontal & vertical axis bound values changed while rendering Chart to EMF.
• Hebrew - Space character is missing in PDF.
• Chart is vertically suppressed while rendering to image.
• DataTable series are missing while exporting chart to image.
• Missing underline in title when chart is converted into image.
• Background image in chart is wrong.
• The space b/w chart's axis (hebrew) labels/legend is missing in the output PDF file.
• Contents of the rectangle shape do not render while converting spreadsheet to HTML.
• Chart has been changed while converting spreadsheet to HTML.
• Formula in chart has changed position while converting spreadsheet to HTML.
• Excel to PDF conversion - Arabic text is reversed.
• Sheet name gets upper-cased on inserting formula.
• Call to updateSelectedValue changes activeSheetIndex.
• Protected view after re-saving an XLS file.
• Copying a workbook changes the standardHeight.
• Formula in custom validation gets missing when workbook is saved in XLS format.
• Excel needs to recover file after simple save through Aspose.Cells.
• Spreadsheet becomes corrupted after changing the font for the shapes.
• Not able to change the font for a few shapes in the collection.
• Password protected Excel file is throwing exception on loading.
• The size of the destination workbook is almost double the size of the source workbook.
• Copying sheets across workbooks changes the formula.
• Unable to read the CheckBox's text value.
• GetNames() method is not returning all the names.
• The pages of the PDF generated by Aspose.Cells are all black.
• Dotted borders from the spreadsheet have not rendered to HTML.
• Formula calculation is wrong with Aspose.Cells generated Excel file.
• Comments (at the end) are vertically cut when generated PDF via Aspose.Cells.
• Series dash lines for charts are not rendered correctly in the output PDF.
• Category axis labels displayed in two lines after converting chart to image.
• Waterfall chart, the line from the total bar and the bar right before it is missing.
• Subtask - Category axis labels displayed in two lines after converting chart to image.
• The exported chart has x-axis labels different from the one in the Excel.
• Chart is wrong on opening and saving the source Excel file.
• Font has been changed after simply loading and re-saving the XLSM.
• Formatting of the resulting file is messed up in the re-saved file.
• Waterfall chart, Total series looks wrong.
• Radar chart image is not generated.
• Input string format error on loading an HTML.
• An additional align attribute is generated on converting XLSX to HTML.
• Export XLSX to HTML - Hash symbols are generated in place of actual Cell values.
• HTML is not rightly converted to Excel file.
• Some of DataBar conditional formatting is missing in the output HTML.
• Background image should be in SVG format but it is in PNG format.
• Dependent cell value causes an error in XLS.
• Sum is not correct after workbook calculation.
• GridWebServlet?acw_ajax_call error occurs while loading GridWeb.
• Excel to PDF - Square looks like Rectangle.
• Excel to PDF - Circle looks like Oval Shape.
• The image file "x1.png" has an extra top border and missing bottom border.
• Performance issue on exporting an XLS to PDF.
• Excel to HTML - Text alignment in chart Y-axis label is wrong.
• Radar chart's points xy px return 0.
• Bound Values of Y-Axis of Bubble Chart changes when AxisScalingValuesIssue-2.xlsx is converted to PDF.
• Compilation error if code contains definition of variable with type CommandBar.
• Excel to PDF - Brackets are coming in next line.
• Saving XLSM file as XLS takes away macro action from button.
• Upgrade the code - Applying 3D Format to Chart.
• Unable to set shape input range.
• Issue with sorting Comments.
• Critical Regression with Custom Controls.
• Issue with setting Page Layout View for XLSB files.
• After accessing VbaModule via Aspose API, the resulting Excel file has broken vba project.
• Font unintentionally is changing its size in comment with a CR embedded in it.
• NullPointerException occurs when the filter exists outside of the named range.
• Copying a worksheet unhides filtered rows in the output HTML file.
• Contents are shown differently (some text is missing) in non IE browsers (e.g Google chrome) - Excel to HTML rendering.
• Conditional formatting is lost when refreshing PivotTable in the spreadsheet.
• Conditional formatting style is broken.
• Excel formula is not working properly - it is shown as 6 instead of 0.
• Saving XLS file with graphs uses 100% CPU.
• Title is obscured by the trend labels in the output PDF.
• Workbook.getFonts() shows additional fonts after reload the same spreadsheet.
• Merging/Copying to Excel sheets - Spaces in the beginning of the cells are not getting retained.
• Invalid string in the file - error occurs on opening an Excel file.
• Names of some public methods parameters changed in the newer version.
• Worksheet.autoFitColumns() does not work well with the cells having line breaks.
• Sorting the Excel file containing comments corrupts the output Excel file.
• Sorting comments causes "Excel found unreadable content...." error when opening the output file into MS Excel.
• Subscript and superscript issues in OpenOffice ODS file when converting to HTML or PDF.
• NullPointerException when opening a large sized Excel file.
• Shape to image error - in rendering an Excel file.
• Exception: java.lang.ArrayIndexOutOfBoundsException on Workbook.save() method.
• Invalid column index exception on rendering Excel.
• Invalid formula exception for the last cell.
• NullPointerException at Workbook ctor while loading an HTML.
• CellsException: Invalid hole size: it must be between 10 and 90.
• Exception: "java.lang.IndexOutOfBoundsException" when loading an XLSX file format.
• Exception - ReadElementString only could be called - occurred on opening workbook.
• Exception occurs on inserting rows.
• Exception: "java.lang.NullPointerException" when rendering a chart to image.
• Exception: "java.lang.IndexOutOfBoundsException: Index: 12, Size: 12" when saving to HTML file format.
• Exception: "java.lang.StringIndexOutOfBoundsException: String index out of range: 0" when loading an XLSX file.