Aspose.Cells for Android via Java 17.5 Release Notes

Contents
[ ]
Key Summary Category
CELLSJAVA-42132 GetPaperWidth and GetPaperHeight methods added in PageSetup class New Feature 
CELLSJAVA-41950 Support Gradient Fill for the WordArt while converting spreadsheets to HTML New Feature 
CELLSJAVA-42009 Support MS Excel 2016 TreeMap Chart New Feature 
CELLSJAVA-42008 Support MS Excel 2016 Waterfall Chart New Feature 
CELLSJAVA-41521 Support Converting Text to Columns MS Excel feature New Feature 
CELLSJAVA-42205 Setting formula with long string literal results in corrupt Excel file Enhancement 
CELLSJAVA-41975 Support DBNum (custom pattern) formatting New Feature 
CELLSJAVA-42237 Accessing the cell creates HTML with blank rows Enhancement 
CELLSJAVA-42236 Performance issue with multi-threading environment Enhancement 
CELLSJAVA-42226 Limit to a folder and its sub-folders to use fonts in rendering images/PDF Enhancement 
CELLSJAVA-41130 Change the language of the predefined words for Pivot Table Enhancement 
CELLSJAVA-42272 Options to embed the hyperlink in an Excel cell Enhancement 
CELLSJAVA-42129 Saving to HTML is wrong Bug
CELLSJAVA-42125 Gridlines behind Shapes are not exported when converted to HTML  Bug 
CELLSJAVA-42110 Some CSS rules ignored when importing HTML Bug 
CELLSJAVA-42094 Contents are striked through in the converted HTML Bug 
CELLSJAVA-42091 Text style of some cells is wrong when saved to HTML  Bug 
CELLSJAVA-42088 DataBar wrong when cell has background color set  Bug 
CELLSJAVA-42018 Chart picture is not getting saved when EMF or SVG format is used Bug 
CELLSJAVA-41980 HtrmlSaveOptions.ExportGridLines does not seem to be working for a particular spreadsheet Bug 
CELLSJAVA-42131 Recalculating a number of formulas using Aspose Cells APIs results in “#NUM!” error Bug 
CELLSJAVA-42124 Date format problem while importing CSV with ICustomParser Bug 
CELLSJAVA-42118 Name.getRanges() API produces unexpected results Bug 
CELLSJAVA-42117 Unable to access the instance variable m_LoadDataFilterOptions while overriding the startSheet method of LoadFilter class Bug 
CELLSJAVA-41882 Cell string value & rounding problem based on different JDK versions Bug 
CELLSJAVA-42142 Right-to-left and left-to-right control characters are not rendered correctly in PDF when conversion is done on Linux Bug 
CELLSJAVA-42136 Hebrew - In the table the word wrapped lines are aligned to the right in PDF while they should be centered as in Excel Bug 
CELLSJAVA-42113 Wrong conversion of Arabic worksheet to SVG Bug 
CELLSJAVA-42135 Hebrew - Wrapped text is not right-aligned in PDF as in Excel Bug 
CELLSJAVA-42134 Hebrew - Series labels when there is a word wrap the characters are not displayed in the right sequence Bug 
CELLSJAVA-42127 Shape to image Error while rendering 03.xls to PDF  Bug 
CELLSJAVA-42126 Shape to image Error while rendering 02.xls to PDF  Bug 
CELLSJAVA-42087 Chart image in the HTML is wrong Bug 
CELLSJAVA-42079 Uneven lines' thickness at intersections while rendering spreadsheet with diagram to PDF Bug 
CELLSJAVA-42078 Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF file Bug 
CELLSJAVA-42076 Angle of x-axis labels is incorrect in Chart’s PDF Bug 
CELLSJAVA-42065 Incorrect rendering of bar charts while rendering spreadsheet to HTML Bug 
CELLSJAVA-42152 Setting formula referring to external workbook creates 3d formula Bug 
CELLSJAVA-42146 Unreadable content error in Excel 2007 after resaving a spreadsheet Bug 
CELLSJAVA-42121 Conditional format expression changes on deleting rows Bug 
CELLSJAVA-42114 Cell.getFormula() returns broken formula for a cell Bug 
CELLSJAVA-42112 Output file gets corrupt after executing DataLabels.setPosition() method Bug 
CELLSJAVA-42108 Conditional format priority order changes on Cells.deleteRows() method Bug 
CELLSJAVA-42069 Vba module is lost while re-saving an XLSM file on Linux Bug 
CELLSJAVA-42025 API adds extra apostrophes to the modified formula Bug 
CELLSJAVA-41984 Dynamic formula in designer spreadsheet using {-1} {-2} return Invalid formula error Bug 
CELLSJAVA-41739 Transparency of the shapes is reset to 0 while converting XLS to XLSB Bug 
CELLSJAVA-42165 Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML Bug 
CELLSJAVA-42164 Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - II Bug 
CELLSJAVA-42162 Data loss while copying range with hidden rows & columns to new workbook and converting it to HTML - III Bug 
CELLSJAVA-40251 Save as PDF does not preserve formatting Bug 
CELLSJAVA-42187 Excel formula is not working and shown as “#DIV/0!” Bug 
CELLSJAVA-42184 Concurrent save issue  Bug 
CELLSJAVA-42156 Top and bottom borders of cells are gone while converting to HTML Bug 
CELLSJAVA-42147 Excel formula is not working properly Bug 
CELLSJAVA-41565 List data validation drop down does not close when reloading data Bug 
CELLSJAVA-42159 PageSetup.BlackAndWhite does not seem to work Bug 
CELLSJAVA-42189 Waterfall chart, when calculate() is called, chart series colors are reverted  Bug 
CELLSJAVA-42160 Logarithmic scale bug in Excel causes Aspose.Cells to hang Bug 
CELLSJAVA-42158 Vertical axis bound values changed while rendering spreadsheet to PDF Bug 
CELLSJAVA-42157 Horizontal & vertical axis bound values changed while rendering Chart to EMF Bug 
CELLSJAVA-42133 Hebrew - Space character is missing in PDF Bug 
CELLSJAVA-42107 Chart is vertically suppressed while rendering to image Bug 
CELLSJAVA-42105 DataTable series are missing while exporting chart to image Bug 
CELLSJAVA-42090 Missing underline in title when chart is converted into image Bug 
CELLSJAVA-42086 Background image in chart is wrong Bug 
CELLSJAVA-42084 The space b/w chart’s axis (hebrew) labels/legend is missing in the output PDF file Bug 
CELLSJAVA-41831 Contents of the rectangle shape do not render while converting spreadsheet to HTML Bug 
CELLSJAVA-42095 Chart has been changed while converting spreadsheet to HTML Bug 
CELLSJAVA-42096 Formula in chart has changed position while converting spreadsheet to HTML Bug 
CELLSJAVA-42169 Excel to PDF conversion - Arabic text is reversed Bug 
CELLSJAVA-42193 Sheet name gets upper-cased on inserting formula Bug 
CELLSJAVA-42191 Call to updateSelectedValue changes activeSheetIndex Bug 
CELLSJAVA-42181 Protected view after re-saving an XLS file Bug 
CELLSJAVA-42180 Copying a workbook changes the standardHeight Bug 
CELLSJAVA-42177 Formula in custom validation gets missing when workbook is saved in XLS format Bug 
CELLSJAVA-42173 Excel needs to recover file after simple save through Aspose.Cells Bug 
CELLSJAVA-42171 Spreadsheet becomes corrupted after changing the font for the shapes Bug 
CELLSJAVA-42168 Not able to change the font for a few shapes in the collection Bug 
CELLSJAVA-42166 Password protected Excel file is throwing exception on loading Bug 
CELLSJAVA-42163 The size of the destination workbook is almost double the size of the source workbook Bug 
CELLSJAVA-42161 Copying sheets across workbooks changes the formula Bug 
CELLSJAVA-42154 Unable to read the CheckBox’s text value Bug 
CELLSJAVA-42150 GetNames() method is not returning all the names Bug 
CELLSJAVA-40511 The pages of the PDF generated by Aspose.Cells are all black Bug 
CELLSJAVA-42204 Dotted borders from the spreadsheet have not rendered to HTML Bug 
CELLSJAVA-42198 Formula calculation is wrong with Aspose.Cells generated Excel file Bug 
CELLSJAVA-42208 Comments (at the end) are vertically cut when generated PDF via Aspose.Cells Bug 
CELLSJAVA-42206 Series dash lines for charts are not rendered correctly in the output PDF Bug 
CELLSJAVA-42167 Category axis labels displayed in two lines after converting chart to image Bug 
CELLSJAVA-42199 Waterfall chart, the line from the total bar and the bar right before it is missing  Bug 
CELLSJAVA-42201 Subtask - Category axis labels displayed in two lines after converting chart to image Bug 
CELLSJAVA-42155 The exported chart has x-axis labels different from the one in the Excel Bug 
CELLSJAVA-42128 Chart is wrong on opening and saving the source Excel file Bug 
CELLSJAVA-42203 Font has been changed after simply loading and re-saving the XLSM Bug 
CELLSJAVA-42196 Formatting of the resulting file is messed up in the re-saved file Bug 
CELLSJAVA-42195 Waterfall chart, Total series looks wrong  Bug 
CELLSJAVA-42045 Radar chart image is not generated Bug 
CELLSJAVA-42239 Input string format error on loading an HTML Bug 
CELLSJAVA-42230 An additional align attribute is generated on converting XLSX to HTML Bug 
CELLSJAVA-42229 Export XLSX to HTML - Hash symbols are generated in place of actual Cell values Bug 
CELLSJAVA-42218 HTML is not rightly converted to Excel file Bug 
CELLSJAVA-42210 Some of DataBar conditional formatting is missing in the output HTML Bug 
CELLSJAVA-41783 Background image should be in SVG format but it is in PNG format Bug 
CELLSJAVA-42253 Dependent cell value causes an error in XLS Bug 
CELLSJAVA-42222 Sum is not correct after workbook calculation Bug 
CELLSJAVA-42254 GridWebServlet?acw_ajax_call error occurs while loading GridWeb Bug 
CELLSJAVA-42243 Excel to PDF - Square looks like Rectangle Bug 
CELLSJAVA-42242 Excel to PDF - Circle looks like Oval Shape Bug 
CELLSJAVA-42227 The image file “x1.png” has an extra top border and missing bottom border Bug 
CELLSJAVA-42212 Performance issue on exporting an XLS to PDF Bug 
CELLSJAVA-42246 Excel to HTML - Text alignment in chart Y-axis label is wrong Bug 
CELLSJAVA-42223 Radar chart’s points xy px return 0 Bug 
CELLSJAVA-42216 Bound Values of Y-Axis of Bubble Chart changes when AxisScalingValuesIssue-2.xlsx is converted to PDF  Bug 
CELLSJAVA-42250 Compilation error if code contains definition of variable with type CommandBar Bug 
CELLSJAVA-42241 Excel to PDF - Brackets are coming in next line Bug 
CELLSJAVA-42234 Saving XLSM file as XLS takes away macro action from button Bug 
CELLSJAVA-42233 Upgrade the code - Applying 3D Format to Chart Bug 
CELLSJAVA-42225 Unable to set shape input range Bug 
CELLSJAVA-42224 Issue with sorting Comments Bug 
CELLSJAVA-42221 Critical Regression with Custom Controls Bug 
CELLSJAVA-42220 Issue with setting Page Layout View for XLSB files Bug 
CELLSJAVA-42217 After accessing VbaModule via Aspose API, the resulting Excel file has broken vba project Bug 
CELLSJAVA-42213 Font unintentionally is changing its size in comment with a CR embedded in it Bug 
CELLSJAVA-42283 NullPointerException occurs when the filter exists outside of the named range Bug
CELLSJAVA-42282 Copying a worksheet unhides filtered rows in the output HTML file Bug 
CELLSJAVA-42276 Contents are shown differently (some text is missing) in non IE browsers (e.g Google chrome) - Excel to HTML rendering Bug 
CELLSJAVA-42247 Conditional formatting is lost when refreshing PivotTable in the spreadsheet Bug 
CELLSJAVA-42257 Conditional formatting style is broken Bug 
CELLSJAVA-42202 Excel formula is not working properly - it is shown as 6 instead of 0 Bug 
CELLSJAVA-42286 Saving XLS file with graphs uses 100% CPU Bug 
CELLSJAVA-42251 Title is obscured by the trend labels in the output PDF  Bug 
CELLSJAVA-42284 Workbook.getFonts() shows additional fonts after reload the same spreadsheet Bug 
CELLSJAVA-42281 Merging/Copying to Excel sheets - Spaces in the beginning of the cells are not getting retained Bug 
CELLSJAVA-42280 Invalid string in the file - error occurs on opening an Excel file Bug 
CELLSJAVA-42275 Names of some public methods parameters changed in the newer version Bug 
CELLSJAVA-42271 Worksheet.autoFitColumns() does not work well with the cells having line breaks Bug 
CELLSJAVA-42266 Sorting the Excel file containing comments corrupts the output Excel file Bug 
CELLSJAVA-42265 Sorting comments causes “Excel found unreadable content….” error when opening the output file into MS Excel Bug 
CELLSJAVA-42264 Subscript and superscript issues in OpenOffice ODS file when converting to HTML or PDF Bug 
CELLSJAVA-42122 NullPointerException when opening a large sized Excel file Exception 
CELLSJAVA-42123 Shape to image error - in rendering an Excel file Exception 
CELLSJAVA-42144 new Workbook() could throw an exception in Aspose.Cells for Java 16.12.6 Exception 
CELLSJAVA-42143 Exception: java.lang.ArrayIndexOutOfBoundsException on Workbook.save() method Exception 
CELLSJAVA-42137 Invalid column index exception on rendering Excel Exception 
CELLSJAVA-42111 Invalid formula exception for the last cell Exception 
CELLSJAVA-42179 NullPointerException at Workbook ctor while loading an HTML Exception 
CELLSJAVA-42174 NullPointerException at Workbook ctor while loading an HTML - II  Exception 
CELLSJAVA-42192 CellsException: Invalid hole size: it must be between 10 and 90 Exception 
CELLSJAVA-42190 Exception: “java.lang.IndexOutOfBoundsException” when loading an XLSX file format Exception 
CELLSJAVA-42185 Exception - ReadElementString only could be called - occurred on opening workbook Exception 
CELLSJAVA-42231 Exception occurs on inserting rows Exception 
CELLSJAVA-42268 Exception: “java.lang.NullPointerException” when rendering a chart to image Exception 
CELLSJAVA-42278 Exception: “java.lang.IndexOutOfBoundsException: Index: 12, Size: 12” when saving to HTML file format Exception 
CELLSJAVA-42274 Exception: “java.lang.StringIndexOutOfBoundsException: String index out of range: 0” when loading an XLSX file Exception 

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Android via Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds setter for LoadFilter.LoadDataFilterOptions property to replace m_LoadDataFilterOptions variable

User may change the LoadDataFilterOptions property in their implementation of LoadFilter to change the behavior of loading workbook.

Adds CellsHelper.SignificantDigits property.

Gets and sets the number of significant digits.

Adds GlowEffect.Color property.

Gets the color of the glow effect.

Adds PageSetup.PaperWidth property.

Represents the width in inches of the paper, considered page orientation.

Adds PageSetup.PaperHeight property.

Represents the height in inches of the paper, considered page orientation.

Adds WorkbookSettings.CheckCustomNumberFormat property.

Indicates whether checking custom number format when setting Style.Custom.

Adds some chart types.

Adds more chart types for MS Office 2016.

Adds DisplayUnitType.Percentage enum.

Represents values on the chart shall be divided by 0.01.

Adds HTMLLoadOptions.AutoFitColsAndRows property.

Indicates whether auto-fit columns and rows. The default value is false.

Adds WorkbookSettings.WarningCallback and LoadOptions.WarningCallback property.

Gets and sets the warning callback.

Adds Cells.TextToColumns() method.

Converts Text to Columns.

Adds Workbook.GetFonts() method.

Get a List of Fonts used in a Spreadsheet.

Adds TxtSaveOptions.TrimLeadingBlankRowAndColumn property.

Indicates whether leading blank rows and columns should be trimmed like what MS Excel does.

Adds BuiltInDocumentPropertyCollection.Revision property and obsoletes BuiltInDocumentPropertyCollection.RevisionNumber property.

Please use BuiltInDocumentPropertyCollection.Revision property instead.

Adds Shape.TextShapeType property.

Gets and sets the preset text shape type.

Adds ExportTableOptions.RenameStrategy property and RenameStrategy enum.

Renames strategy when columns contains the duplicate names.

Adds GlobalizationSettings.GetPivotTotalName() method.

Gets the name of “Total” label in the PivotTable. You need to override this method when the PivotTable contains two or more PivotFields in the data area.

Adds GlobalizationSettings.GetPivotGrandTotalName() method.

Gets the name of “Grand Total” label in the PivotTable.

Adds GlobalizationSettings.GetMultipleItemsName() method.

Gets the name of “(Multiple Items)” label in the PivotTable.

Adds GlobalizationSettings.GetAllName() method.

Gets the name of “(All)” label in the PivotTable.

Adds GlobalizationSettings.GetColumnLablesName() method.

Gets the name of “Column Labels” label in the PivotTable.

Adds GlobalizationSettings.GetRowLablesName() method.

Gets the name of “Row Labels” label in the PivotTable.

Adds GlobalizationSettings.GetEmptyDataName() method.

Gets the name of “(blank)” label in the PivotTable.

Adds GlobalizationSettings.GetSubTotalName(PivotFieldSubtotalType subTotalType) method.

Gets the name of “PivotFieldSubtotalType” type in the PivotTable.

Adds VbaProject.Protect(bool islockedForViewing,string password) method

Protects or unprotects the VBA project.

Adds VbaProject.IsProtected property

Indicates whether the vba project is protected.

Adds VbaProject.IslockedForViewing property

Indicates whether the VBA project is locked for viewing.

Adds CopyOptions.ExtendToAdjacentRange property

Indicates whether extend ranges when copying the range to adjacent range.

Deletes obsoleted Workbook.ValidateFormula(string formula) method

Adds DataSorter.SortAsNumber property

Indicates whether sorting anything that looks like a number.

Adds ExportTableOptions.ExportAsHtmlString property

Exports the HTML string value of the cells to the DataTable.

Adds PageSetup.Copy(PageSetup source,CopyOptions copyOptions) method

Copies the settings of the Page Setup.

Adds ImportTableOptions.ShiftFirstRowDown property

Indicates whether shifting the first row down when inserting table.

Adds PageSetup.CustomPaperSize() method

Sets the custom paper size, in the unit of inches.

Adds PageSetup.PrinterSettings property

Gets and sets the settings of the default printer.

Adds constants PaperSizeType.CUSTOM

Represents the custom paper size.

Adds constants PdfCompliance.PDF_A_1_A

Represents PDF format compatible with PDFA-1a.

Aspose.Cells for Android via Java 17.9 Release Notes