Create Custom Subtotal Labels & Add Glow, 3D Effects for Shapes in Worksheet inside Android Apps

2024-11-01 09:19:20 Computer

1245

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
? DCOUNTA Excel formula is not evaluated fine by Aspose.Cells formula calculation engine
? Issue with DataBar Conditional Formatting when Saving an XLSM file as PDF
? The space between certain characters gets removed at a few places in the output PDF file
? Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF file
? Issue with font attributes of TextBox in the output PDF
? TextBox's content color & size is changed while converting worksheet to EMF
? TextBox's content color & size is changed while converting spreadsheet to PDF
? Hebrew words are not rendered correctly when converting an Excel file to PDF file format
? Content in TextBox is clipped while rendering spreadsheet to PDF
? Arrowed lines are misplaced while rendering spreadsheet to PDF
? Issue with the SVG image of the Chart in the rendered HTML file
? Font substitution does not seem to take effect for Chart legend while using Chart.toPdf
? Legend overlapping with text in Chart's PDF
? Incorrect ChartPoint's ShapeXPx & ShapeYPx values
? Incomplete rendering of the Rectangle shape while converting XLS to HTML
? Text is getting truncated while converting spreadsheet to PDF file format
? Extra pages are added due to some pages are not rendered completely in one PDF page
? SheetRender - Invalid column index
? Extending Excel Table modifies data
? Opening and saving the file while using SheetRender corrupts the output Excel file
? Setting the shape text changes the text style
? Text of some cells like C2 and C3 gets unbold
? Worksheet.autoFitColumns method does not seem to take effect when required font is not present in Linux
? Unexpected background color applied to TextBoxes while rendering spreadsheet to PDF

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

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Android documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Filtering Objects while Loading Template Spreadsheets: http://www.aspose.com/docs/display/cellsandroid/Filtering+Objects+while+Loading+Template+Spreadsheets

- Managing Reflection Effects for Shapes: http://www.aspose.com/docs/display/cellsandroid/Managing+Reflection+Effects+for+Shapes

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: http://www.aspose.com/products/cells/android

- Download Aspose.Cells for Android: http://www.aspose.com/downloads/cells/android

- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home

- Demos of Aspose.Cells for Android: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Android Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Android blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465