Show Excel Cell Range as Data Labels & Saving ODS File to ODF 1.2 in Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.3.1. Aspose.Cells APIs have extended its support for the OpenDocument Format. Now users can save the ODS (OpenDocument Spreadsheets) in conformance to ODF 1.2 specifications. Aspose.Cells APIs have exposed the methods isStrictSchema11 & setStrictSchema11 for the OdsSaveOptions class to support this feature. The default value of the setStrictSchema11 property is false, which means that from version 8.3.1 of Aspose.Cells, ODS files will be saved as ODF format version 1.2 by default. For more details, please check the article Save ODS file in ODF 1.1 and 1.2 Specifications. Normally, you add values inside the ListObject/Table using the Cell.putValue method, however, the putValue method must be associated with an instance of a Cell to identify the correct location where value has to be inserted. This mechanism is not usable when you need to add values inside the ListObject using the row and column offsets. Aspose.Cells for Android 8.3.1 has exposed the methods Cell.getTable & ListObject.putCellValue methods to facilitate the users in Accessing the ListObject from a Cell and Add Values using the Row and Column Offsets. Aspose.Cells APIs have exposed the SparklineCollection.add(String dataRange, int row, int column) method to Specify the Data Range and Location of Sparkline Group. Aspose.Cells provides the DataLabels.setShowCellRange attribute to select or clear the option Label Contains – Value From Cells. For more details, please see the article Showing Cell Range as the Data Labels. Aspose.Cells for Android 8.3.1 has provided fixes and other enhancements for several important issues, such as, reading/writing Microsoft Excel files, calculating formulas, manipulating charts and shapes, sheet to image, chart to image and Excel to PDF bugs, etc. This release includes plenty of improved features and bug fixes as listed below

• Specify the location & data source for the Sparkline group
• Support for ODS version 1.2
• Opening and saving xlsb makes it corrupt
• "Excel found unreadable content...." error when re-saving a template XLSB file
• Columns and Rows of Pivot Table don't match after converting Excel to PDF
• Resaving a template XLSM produces a corrupted file
• Text is not aligned in side the shape when XLS is rendered to PDF
• Textbox Fill IsVisible property is not correct
• Copy rows/columns does not remove old condition format
• MemorySetting.MEMORY_PREFERENCE gives buggy cell iterators
• Remove rows changes the link style in the output file
• Opening and saving the xls file changes the cells color
• Problem of reading conditionally formatted values with DisplayStringValue
• Vertical text in merged cells appear as ## while rendering to PDF format
• Difference in Aspose.Cells Generated PDF as compared to MS Excel's Generated PDF
• Chart Title with Underline is not converting to PDF
• Copying the coloumns does not copy the Sparklines
• [CELLRANGE] is showing instead of correct data labels inside the chart image
• Sparkline.toImage generated blank images for some cases
• Chart Legends are getting messed up
• Wrong values retrieved for Chart's points information
• Anti-aliasing is no effect in sparkline to image
• Copying the Workbook and rendering the Chart to Image changes the Legend and Plot Area

Other most recent bug fixes are also included in this release.
Overview: Aspose.Cells for Android
Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

• Homepage of Aspose.Cells for Android
• DownloadAspose.Cells for Android

Retrieve Workbook State & Get Equation Text of Chart Trendline in Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.3.0. This release contains some useful features and other improvements. Aspose.Cells allows you to retrieve the equation text of a chart trendline. Aspose.Cells provides the Trendline.getDataLabels().getText() method which returns the equation text of a chart’s trendline. To make use of this property, first call the Chart.calculate() method. Please see the detailed article on retrieving the equation text of a chart trendline in the documentation section. This new release has added several useful get/set methods that can enable the developers to track & manipulate the Workbook file’s state.  Aspose.Cells for Android 8.3.0 has provided fixes and other enhancements for several important issues, such as, reading/writing Microsoft Excel files, calculating formulas, manipulating charts and shapes, sheet to image, chart to image and Excel to PDF bugs, etc. This release includes plenty of improved features and bug fixes as listed below

• Increase performance by caching the prepared MessageFormat object
• Remove or cache MessageFormat/DecimalFormat.format() to improve performance
• Remove XLA references
• Fixed Chart bars issues for the negative values loses color when spreadsheet is saved by Aspose.Cells
• Fixed: error in calculating cells - exception on calculating formula
• Fixed: formatted number is rendered as blank
• Textbox text issue is fixed and now included inside the chart image
• Excel function NOW() was not working in Russian setting is now fixed
• Color.getBlack().equals(Color.getEmpty()) was returns true. It is fixed
• DateTime value is fixed and now read in correct format
• Fixed issue: XLA reference was not removed correctly by ExternalLink.setDataSource
• XLSX file is corrupted after re-saving the file via Aspose.Cells APIs is now fixed
• Chart axis steps broke after copying worksheet is now fixed
• Changing the Workbook Color Pallet while saving the XLSX to XLS causes the MS Excel to open the resultant spreadsheet in protected view is now fixed
• Losing quotes for certain Named Ranges is now fixed
• Cells.copyRows() method is fixed &  now copying sparklines in the XLSX file format.
• Text formatting issue is resolved while reading the cells' styles
• Getting #VALUE! error when using RATE function is now fixed
• Hidden series inside the legend appears again after copying worksheet is fixed.
• Chart axis steps broke when workbook re-saved is now resolved
• Copy Pasted Picture issues is fixed and now Rendering in the PDF
• Fixed: Aspose.Cells generated PDF does not pass the PDF/A-1b compliance test
• Aspose.Cells Generated PD/ A-1b document fails the Preflight validation is fixed
• PDF document is broken and cannot be opened in Acrobat Reader after converting from Excel template file is now corrected
• ClipArt’s do not appear in pdf is now fixed
• Compliance PDF/A-1b failed with Adobe Preflight
• User-defined Chart Series Names are empty
• Charts Titles are messed up
• Data Separator of Stacked Column Chart has different thickness while rendering Spreadsheet to PDF format
• Columns of the chart are overlapping with bottom axis while rendering spreadsheet to PDF format
• Bar Chart has extra vertical lines on right of the bars when rendered as PDF
• Chart's Data Label is Trimmed Off in the rendered PDF
• Chart's Axis Labels & Legend are Overlapping in the rendered PDF
• Text boxes are lost from the chart

Other most recent bug fixes are also included in this release.

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

• Homepage of Aspose.Cells for Android
• DownloadAspose.Cells for Android