Browse our Products
Aspose.Cells for Android via Java 17.5 Release Notes
This page contains release notes for Aspose.Cells for Android via Java 17.5
| 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.
Since the code base of Aspose.Cells for Android via Java matches the code of relevant .NET and Java version(s), most of the changes, enhancements and fixes included in the Aspose.Cells for .NET v17.1.0, Aspose.Cells for .NET v17.2.0, Aspose.Cells for .NET v17.3.0, Aspose.Cells for .NET v17.4.0, Aspose.Cells for .NET v17.5, Aspose.Cells for Java v17.1.0, Aspose.Cells for Java v17.2.0, Aspose.Cells for Java v17.3.0, Aspose.Cells for Java v17.4.0 and Aspose.Cells for Java v17.5 are also included in this Aspose.Cells for Android via Java v17.5.
