Create Custom Subtotal Labels & Add Glow, 3D Effects for Shapes in Worksheet using Aspose.Cells for Android 16.12.0

It added support for creating custom subtotal labels allowing application developers to customize labels according to the region or personal preferences. It supports Rendering Custom Other Label for Pie Chart and Improved Object Filtering for Loading Templates. It also supports reflection effects, shadow effects, glow effects, 3-D Formats & WordArt built-in styles. It also enhanced automatically propagating the formula to next rows of a List Object, insert XML map to workbook & more.

Lane Cove, Australia, January 12, 2017 --( What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v16.12.0. This release includes a number of new features, enhancements and bug fixes that further improve the overall stability and usability of the API. It has added the support for the creation of custom subtotal labels allowing the application developers to customize the labels according to the region or personal preferences. In order to provide this feature, the latest version of the Aspose.Cells for Android has exposed the GlobalizationSettings class offering the following 2 methods which can be overridden in a custom class to get desired labels for the Subtotals. The GlobalizationSettings class also offers the getOtherName method which is useful to give the “Other” label of Pie charts a custom value. Sometimes, application requirement could be to load just a particular type of objects while loading existing spreadsheets in Aspose.Cells’ object model. For instance, users may require to load only the cells along with formulas & formatting or just the document properties. Aspose.Cells APIs now provide a flexible yet comprehensive mechanism to achieve such requirements by exposing the LoadFilter class. The LoadFilter class along with LoadOptions.LoadFilter property can control the type of data/objects to be loaded while initializing an instance of Workbook from a template file. The constructor of the LoadFilter class can accept constant(s) from the LoadDataFilterOptions enumeration that specifies the type of objects to be loaded. It has added the support for reflection effects for a Shape object as Excel provides it via Effects tab under Format Shape dialog as shown on the blog announcement page. It has also added the support for Shadow Effects for a Shape object as Excel provides it via Effects tab under Format Shape dialog. It also supports the Glow Effects for a Shape object and 3-D Formats for Shape objects as Excel provides it via Effects tab under Format Shape dialog. Aspose.Cells for Android APIs now supports to add WordArt objects with built-in styles. In order to provide this feature, it has exposed the ShapeCollection.AddWordArt method along with PresetWordArtStyle enumeration which together allows to add preset WordArt objects since Excel 2007. It has fixed a few critical bugs as well as enhanced its core for more stability. This release includes plenty of improved features and bug fixes as listed below:

• Support Subtotal/Total labels in other languages
• Specify Chart points' positions
• Refreshing PivotTable is not working in the rendered PDF file
• XLSM becomes corrupted by simple load and save operation
• Hyperlinks are not working as expected after converting spreadsheet to HTML
• Some characters do not render in the output PDF
• Order of chart legend changed in Chart's PDF
• Z order of high-low lines is not correct in PDF
• Spreadsheet becomes corrupted after re-saving with Aspose.Cells
• Formula is changed after inserting to a cell
• Strange behaviour with simple bean using Smart Markers
• Cell's text overflows to next cell
• CalculateFormula has issue to recalculate cells with reference to cells with formulas
• Hebrew control characters are not rendered correctly in PDF
• XLS to PDF conversion is taking too much time
• Layout problem when converting spreadsheet to PDF
• X-axis labels are overlapping with Legend when rendered to PDF
• Picture does not scale well and its SVG file is not correct
• Incorrect rendering of Chart while converting spreadsheet to HTML
• Spaces are omitted from text in PNG output of Chart
• Selection or check state not saved when saving to PDF
• Text and text alignment is messed up in the file
• Extending MS Excel table/ list object changes cells formatting
• Adding Arc to a new Workbook generates a potentially unsafe spreadsheet
• Table column resolving broken if containing '['
• Issue with extending Excel Table/List Object content regarding formulas
• Incorrect formula returned from a worksheet cell
• XLSM becomes corrupted after re-save operation
• DataBar width is not correct while converting spreadsheet to HTML
• Orange Row is not included in the Sum of Pivot Table
• Image is cut off in the output HTML
• Chart is missing while converting spreadsheet to HTML
• Row height is not correct while converting XLSX to HTML

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.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android:

- Download Aspose.Cells for Android:

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465
Sher Azam