Aspose.Cells for Android via Java 18.6 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSJAVA-42523 | Use FIPS compliant version of Bouncy Castle in Aspose.Cells APIs | New Feature |
| CELLSJAVA-42550 | The concurrent conversion to PDF while each workbook has his own private (exclusive) set of fonts | New Feature |
| CELLSJAVA-42339 | Implement custom data sorting in Pivot Table report via Aspose.Cells APIs | New Feature |
| CELLSJAVA-42625 | The implementation of the MS Excel feature ‘Watch Window’ | New Feature |
| CELLSJAVA-42612 | Unable to extract the text from the gear type SmartArt | New Feature |
| CELLSJAVA-42572 | Formula should not contain more than 8192 characters | Enhancement |
| CELLSJAVA-42569 | Unable to access horizontal category axis labels items of Chart in XLS | Enhancement |
| CELLSJAVA-42580 | Get/set Language document property | Enhancement |
| CELLSJAVA-42565 | Foreground color vs Background color vs Fill color - Use a single method that takes two arguments | Enhancement |
| CELLSJAVA-42528 | “<Font>” is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents | Enhancement |
| CELLSJAVA-42413 | Insert SVG image type into worksheet cells by Aspose.Cells | Enhancement |
| CELLSJAVA-42594 | Detect LoadFormat and FileFormatType of XLAM | Enhancement |
| CELLSJAVA-42646 | Exception: “FormulaBuild Unknown formula token 0” on Name.getRefersTo() | Enhancement |
| CELLSJAVA-42645 | Exception: “FormulaBuild More than one token in stack….” on Cell.getFormula() | Enhancement |
| CELLSJAVA-42516 | Aspose.Cells accepts and corrects an invalid formula | Enhancement |
| CELLSJAVA-42551 | Some shapes are not correct in the output PDF | Bug |
| CELLSJAVA-42578 | Conditional formatting is lost while saving Excel to HTML | Bug |
| CELLSJAVA-42571 | Output HTML does not match with MS-Excel | Bug |
| CELLSJAVA-42553 | Links to named area are wrong after export to HTML | Bug |
| CELLSJAVA-42530 | Pivot Tables and corresponding Charts do not have correct Date format | Bug |
| CELLSJAVA-42527 | Chart has many values in x-axis and values are overlapping over each other | Bug |
| CELLSJAVA-42581 | Aspose.Cells returns wrong value of cell A2 | Bug |
| CELLSJAVA-42583 | XML map does not create table properly | Bug |
| CELLSJAVA-42577 | Get/extract values (0 for 0 and blank for blank) using DataPoint.getYValue() method for a given chart | Bug |
| CELLSJAVA-42566 | Inversion of subtitles (legend entries) in MS Excel chart | Bug |
| CELLSJAVA-42560 | Arrows are missing in PNG output of Excel Chart | Bug |
| CELLSJAVA-42508 | Java method ‘Shape.toImage’ works differently with the same method in .NET | Bug |
| CELLSJAVA-42573 | Aspose.Cells 18.3 rotation for a TextBox is not working for EXCEL_97_TO_2003 save format | Bug |
| CELLSJAVA-42570 | Blank new line appears inside the TextBox after processing and saving the Excel file | Bug |
| CELLSJAVA-42604 | Pivot Table’s formatting and behavior changed after open/save the template file | Bug |
| CELLSJAVA-41918 | Spreadsheet (XLS) becomes corrupted after simple load & save | Bug |
| CELLSJAVA-42616 | Aspose.Cells breaks iterator interface when calling Iterator.hasnext() twice | Bug |
| CELLSJAVA-42607 | Properties values garbled when extracting document properties | Bug |
| CELLSJAVA-42601 | The workbook is corrupted after adding a watermark | Bug |
| CELLSJAVA-42600 | Same code executes slower in new releases | Bug |
| CELLSJAVA-42598 | Properties are not be extracted in the template file | Bug |
| CELLSJAVA-42589 | NullPointerException when adding HTML to a cell | Bug |
| CELLSJAVA-41414 | Lines disappeared from chart when XLSX file is re-saved | Bug |
| CELLSJAVA-42636 | Some drawing shapes are displaced or rendered wrongly in Excel to HTML rendering | Bug |
| CELLSJAVA-42627 | CELLSJAVA-42619 Unable to extract Smart Art images correctly | Bug |
| CELLSJAVA-42618 | Shape is displaced to cover data in Excel to HTML rendering | Bug |
| CELLSJAVA-42628 | Calculation of formulas are wrong e.g. it generates #DIV/0! errors | Bug |
| CELLSJAVA-42615 | Cell A3 format is not correct in the output HTML | Bug |
| CELLSJAVA-42621 | Poor performance when generating PDF file from an Excel file | Bug |
| CELLSJAVA-42620 | XLSX to TIFF - exception NoClassDefFoundError | Bug |
| CELLSJAVA-42599 | Images are lost when Excel file is converted to Pdf | Bug |
| CELLSJAVA-42630 | Chart.calculate method causes OutOfMemoryError | Bug |
| CELLSJAVA-42623 | Memory increases in rendering Excel file to PDF file format | Bug |
| CELLSJAVA-42592 | Font size changed on Chart Title due to characters() method | Bug |
| CELLSJAVA-41860 | Shadow effect is changed while re-saving XLS | Bug |
| CELLSJAVA-42654 | Excel to PDF conversion - the conversion never completes | Bug |
| CELLSJAVA-42647 | Unable to get or set alternative text for Comment shape | Bug |
| CELLSJAVA-42644 | Aspose.Cells hangs when converting a Spreadsheet ML file (xml) to PDF with self-closing Styles tag | Bug |
| CELLSJAVA-42632 | Unable to set alternative text for SmartArt shape | Bug |
| CELLSJAVA-42631 | getFirstVisibleRow() and getFirstVisibleColumn() returning invalid indices | Bug |
| CELLSJAVA-42624 | Hyperlinks with encoded symbols (such as, “%5c”) decode after re-saving | Bug |
| CELLSJAVA-42563 | Exception “java.lang.NullPointerException” when digital signing an XLSX file | Exception |
| CELLSJAVA-42602 | Exception “IndexOutOfBoundsException” when merging cells in light-weight mode | Exception |
| CELLSJAVA-42610 | Exception “java.lang.IllegalStateException: Invalid encoding: null” when loading an XLS file | Exception |
| CELLSJAVA-42608 | ArrayIndexOutOfBoundsException occurs on opening an Excel file | Exception |
| CELLSJAVA-42596 | “java.lang.ArrayIndexOutOfBoundsException” occurs on opening an Excel file | Exception |
| CELLSJAVA-42595 | “java.io.IOException: File is corrupted” occurs on opening an Excel file | Exception |
| CELLSJAVA-42591 | “com.aspose.cells.CellsException: Invalid formula” on loading an Excel file | Exception |
| CELLSJAVA-42638 | Cell.getDisplayStringValue() throws java.lang.NullPointerException | Exception |
| CELLSJAVA-42652 | java.lang.ArrayIndexOutOfBoundsException occurred on loading an XLS file | Exception |
| CELLSJAVA-42650 | Exception: “Invalid encoding: null” when loading an XLS file | Exception |
| CELLSJAVA-42649 | Exception: “The count of HPageBreaks cannot be larger than 1024” when loading an XLS file | Exception |
| CELLSJAVA-42648 | Exception: “Failed to read image data” on Picture.getData() | 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 new item “CrossHideRight” for HtmlCrossType enum
Displays HTML cross string and hides the right string when the text is overlapped.
Adds new item “TSV” for LoadFormat, SaveFormat and FileFormatType enums
Represents a TSV(Tab-separated values) file, same with the “TabDelimited”.
Adds enum ImageType
Represents the type of the image.
Adds MsoTextFrame.RotateTextWithShape and ShapeTextAlignment.RotateTextWithShape properties
Indicates whether the text rotates with the shape.
Adds OleObject.ImageType and Picture.ImageType properties
Gets the image format of the picture.
Obsoletes OleObject.ImageFormat and Picture.ImageFormat properties
Use OleObject.ImageType and Picture.ImageType properties instead.
Adds an overload AutoFilter.Refresh (System.Boolean) method
Gets all hidden rows’s indexes and refreshes the auto-filter.
Adds overload Cell.GetHtmlString(System.Boolean) method
Gets the HTML string which contains data and some formats in this cell.
Adds BuiltInDocumentPropertyCollection.Language property
Gets and sets the language of the file.
Adds Style.SetPatternColor(Aspose.Cells.BackgroundType,System.Drawing.Color,System.Drawing.Color)
Sets the pattern and color of the cell
Adds ChartPoint.XValueType property
Gets X value type of the chart point.
Adds ChartPoint.YValueType property
Gets Y value type of the chart point.
Adds enum PageLayoutAlignmentType
Represents page layout alignment types.
Adds Chart.ToPdf(System.IO.Stream,System.Single,System.Single,Aspose.Cells.PageLayoutAlignmentType,Aspose.Cells.PageLayoutAlignmentType) method
Creates the chart’s PDF with desired page size and saves it to a stream.
Adds Chart.ToPdf(System.String,System.Single,System.Single,Aspose.Cells.PageLayoutAlignmentType,Aspose.Cells.PageLayoutAlignmentType) method
Creates the chart’s PDF with desired page size and saves it to a file.
Adds PdfSaveOptions.OutputBlankPageWhenNothingToPrint property
Indicates whether to output a blank page when there is nothing to print.
Adds new properties Cell.IsTableFormula/IsArrayFormula to replace Cell.IsInTable/IsInArray
Indicates whether one cell is part of the table formula or array formula. Old names make ambiguity, so we made them obsolete and provide new ones.
Adds IndividualFontConfigs class
Represents Font configs for each workbook object.
Adds LoadOptions.FontConfigs property
Gets and sets individual font configs.
Deletes obsoleted FontSetting.ShapeFont property
Use FontSetting.TextOptions property instead.
Adds OoxmlCompliance enum and WorkbookSettings.Compliance property
Supports Strict Open Xml Spreadsheet.
Adds GroupShape.Ungroup() method
Ungroups shapes.
Adds MsoFormatPicture.Gamma property
Gets and sets the gamma of the picture.
Adds TextOptions.FarEastName and TextOptions.LatinName property
Get and sets the Far East and Latin name of the font.
Adds Slicer, SlicerCollection, SlicerCache, SlicerCacheItem and SlicerCacheItemCollection classes
These APIs are used to create and modify the Slicer in the file.
Adds SlicerCacheItemSortType and SlicerStyleType enums
These APIs are used to create and modify the Slicer in the file.
Adds CellWatchCollection and CellWatch classes, Adds Worksheet.CellWatches property
Adds Cell Watch Item in the ‘watch window’.
Adds CustomXmlShape class and MsoDrawingType.CustomXml enum
Supports keeping custom xml shape.
Adds MsoDrawingType.SmartArt enum
Represents the smart art shape type.
Adds Font.SchemeType property and FontSchemeType enums
Gets and sets the scheme type of the font.
Adds CustomXmlPart.ID property
Gets and sets the Id of custom xml part.
Adds CustomXmlPartCollection.SelectByID() method
Gets Custom xml part by id.
Adds Range.Address, Range.CellCount, EntireColumn, Range.EntireRow and Range.GetOffset(System.Int32,System.Int32)
Enhancement for processing range.
Overloads WorkbookRender.ToImage() method
Renders the workbook to image by the page index.
Adds Legend.LegendEntriesLabels() method
Gets the labels of the legend entries after calling Chart.Calculate() method.
Adds CustomFilter.SetCriteria(FilterOperatorType filterOperator, object criteria) method
Sets the filter criteria.
Provides new APIs for supporting to get/set formulas in locale dependent format (the FormulaLocal function of Microsoft Interop)
Cell.GetFormula(bool isR1C1, bool isLocal) Cell.SetFormula(string formula, bool isR1C1, bool isLocal, object value) Name.GetRefersTo(bool isR1C1, bool isLocal) Name.SetRefersTo(string refersTo, bool isR1C1, bool isLocal) FormatCondition.GetFormula1(bool isR1C1, bool isLocal) FormatCondition.SetFormula1(string formula, bool isR1C1, bool isLocal) FormatCondition.GetFormula2(bool isR1C1, bool isLocal) FormatCondition.SetFormula2(string formula, bool isR1C1, bool isLocal) FormatCondition.GetFormula1(bool isR1C1, bool isLocal, int row, int column) FormatCondition.GetFormula2(bool isR1C1, bool isLocal, int row, int column) GlobalizationSettings.GetTableRowTypeOfHeaders() GlobalizationSettings.GetTableRowTypeOfData() GlobalizationSettings.GetTableRowTypeOfAll() GlobalizationSettings.GetTableRowTypeOfTotals() GlobalizationSettings.GetTableRowTypeOfCurrent() GlobalizationSettings.GetErrorValueString(string err) GlobalizationSettings.GetBooleanValueString(bool bv) GlobalizationSettings.GetLocalFunctionName(string standardName) GlobalizationSettings.GetStandardFunctionName(string localName) GlobalizationSettings.GetLocalBuiltInName(string standardName) GlobalizationSettings.GetStandardBuiltInName(string localName) GlobalizationSettings.ListSeparator GlobalizationSettings.RowSeparatorOfFormulaArray GlobalizationSettings.ColumnSeparatorOfFormulaArray