Set Margins of a Shape & Parse Pivot Cached Record while Loading Excel File in Andoid

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 18.3.0 . This release includes many new features, enhancements and other bug fixes that further improve the overall stability and usability of the API. Sometimes, one pivot table uses other pivot table as a data source, so it is called a child pivot table or nested pivot table. Developers can find the children pivot tables of a parent pivot table using the PivotTable.getChildren() method. The following sample code finds the children pivot tables of the pivot table using the PivotTable.getChildren() method and then refreshes them one by one. When users create a Pivot Table, Microsoft Excel takes a copy of the source data and stores it in the Pivot Cache. The Pivot Cache is held inside the memory of Microsoft Excel. When Developers load your Excel file inside the Workbook object, you can decide whether users also want to load the records of Pivot Cache or not, using the LoadOptions.ParsingPivotCachedRecords property. The default value of this property is false. If Pivot Cache is quite big, it can increase the performance. When Microsoft Excel file is exported to HTML using Microsoft Excel or Aspose.Cells APIs, it also exports various types of Document, Workbook and Worksheet properties. Microsoft Excel file may contain many unnecessary unused styles. When users export the Excel file to HTML file format, these unused styles are also exported. This could increase the size of HTML. Users can exclude the unused styles during the conversion of Excel file to HTML using the HtmlSaveOptions.ExcludeUnusedStyles property. Early versions of Aspose.Cells were not able to handle automatic units of chart axis properly when chart is rendered to image or pdf. Now, Aspose.Cells supports the handling of automatic units of chart axis. There is no code change. Just convert your chart into image or pdf and it will render chart axis just like Microsoft Excel renders it. Earlier, Aspose.Cells would create PdfBookmarkEntry for normal sheet. But now Aspose.Cells can also create PdfBookmarkEntry for chart sheet. Since, chart sheet does not have any other cell except cell A1, so it will create PdfBookmarkEntry for cell A1 only. Aspose.Cells allows users to set the margins of any shape or comment using the Shape.TextBody.TextAlignment property. This property returns the object of ShapeTextAlignment class which has different properties e.g. TopMarginPt, LeftMarginPt, BottomMarginPt, RightMarginPt etc. that can be used to set the top, left, bottom and right margins. Users can specify formula fields when you import data into your worksheet using the ImportTableOptions.setFormulas() method. This method takes the Boolean array where the value true means the field is a formula field. For example, if the third field is a formula field, then third value in the array will be true. Aspose.Cells provides the Workbook.Settings.MaxRowsOfSharedFormula property that can be used to specify the maximum rows of the shared formula. The shared formula will be split to several shared formulas if the total rows of shared formula is greater than it. Sometime, an Excel file contains external resources e.g. linked images etc. Aspose.Cells allows users to control these external resources using Workbook.Settings.StreamProvider which takes the implementation of IStreamProvider interface. Whenever users will try to render your worksheet containing external resources e.g. linked images, the methods of IStreamProvider interface will be invoked which will enable users to take appropriate actions for their external resources. Aspose.Cells allows users to filter or remove defined names present inside the workbook. Microsoft Excel allows users to group pivot fields in the Pivot Table. When there is large amount of data related to a pivot field, it is better to group them into sections. Aspose.Cells provides this feature via the PivotTable.setManualGroupField() method. This was a long-awaited feature requested by many users. Microsoft Excel also supports dashed border types which are not supported by most web browsers. When users convert such an Excel file into HTML using Aspose.Cells, the borders are removed. However, Aspose.Cells allows users to accomplish the task and supports to display such borders with HtmlSaveOptions.ExportSimilarBorderStyle property. Dialog sheet is an older format that contains a dialog box. You can find if a sheet is dialog or some other type with Worksheet.Type property. If it returns enumeration value SheetType.DIALOG, then it means, you are dealing with Dialog sheet. Microsoft Excel allows users to change the display label of the Ole Object. Users can also access or modify the display label of the Ole object via Aspose.Cells APIs using the OleObject.Label property. When users put some value inside a cell that has leading apostrophe or single quote mark, then Microsoft Excel hides it, but when users select the cell, it displays the leading apostrophe or single quote in a formula bar. Aspose.Cells provides StyleFlag.QuotePrefix property that will handle either preserving the quote or not preserving the quote for their needs. Users can read axis labels of a chart after calculating its values using the Chart.calculate() method. Please use the Axis.AxisLabels property for this purpose that will return the list of axis labels. This release includes plenty of improved features and bug fixes as listed below

- Provide an option to decide whether exporting workbook properties
- Provide an option to decide whether exporting document properties
- Create a PdfBookmarkEntry for a chart sheet
- Add LoadDataFilterOptions.NAMES constant to filter defined names when loading workbook
- PdfSaveOptions.DrawObjectEventHandler is needed just like - ImageOrPrintOptions.DrawObjectEventHandler
- Extract label name that can be set for Package Objects embedded in Excel file
- Observe very slow filtering in Microsoft Excel 2013 and 2016 when filter is applied
- Fix needed for all ActiveX controls
- Exclude unused styles when exporting Excel file to HTML (parent issue id: CELLSJAVA-42471)
- How to identify worksheet shapes via DrawObjectEventHandler
- Unable to access horizontal category axis labels items
- Parts of images are truncated or missing and they do not match with original source images
- Image protrudes from the shape in the output PDF
- Element shape is incorrect in the output HTML
- Excel to Html - Wrapping text is ignored
- XLSB file gets corrupt after opening and saving
- HTML output discrepancy - Issue with spaces
- Irrelevant data included when saving to HTML
- XLSB corrupted after re-saving
- 15 digits numbers do not match what is in MS Excel
- Margins and layout differences when comparing the output PDF (by Aspose.Cells) with the MS Excel generated PDF
Feature does not work in Java - ResultSet
- Sheet1 shapes are lost and Stars in Sheet2 are rounded
- Invalid encoding - Exception occurs on loading the Excel file
- Macro and Dialog sheets are detected as regular worksheets
- MS Excel does not allow to save XLS file again
- Aspose.Cells is not filtering data correctly instead it hides all the rows
- Output HTML does not match with Excel
- Excel files corrupted after open/save by Aspose.Cells APIs
- Extra columns are coming at the end of each row in the output HTML for a range
- Excel file is corrupted and have some cells changed after saving
- Calculation errors are present in the hidden sheet namely KD020
- ImportTableOptions.setInsertRows() is not working while importing the ResultSet to worksheet
- Comments attached to the cells (in the template file) are not shown when importing the Excel file into GridWeb
- Inconsistent cell coordinates reported by ImageOrPrintOptions.DrawObjectEventHandler
- Borders of rows are misaligned in the output PDF
- X-Axis scale is incorrect in PNG output of Excel chart
- Rendering of the chart is not correct in the output PDF
- Chart is replaced with Red X when converting XLSX to ODS
- Images lost when converting ODS to XLSX
- Properties are not extracted from XLS and XLSX files
- Saving XLS to XLSB removes allowEditRanges
- Exception "NullPointerException" occurred when extracting SmartArt shape text
- Article Code - Control External Resources using WorkbookSetting.StreamProvider - does not work for Java
- Article Code - Specify Formula Fields while Importing Data to Worksheet - does not work for Java
- Chinese characters in embedded file name (title) is not well-displayed in notepad

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.

- Export Document Workbook and Worksheet Properties in Excel to HTML conversion
- Parsing Pivot Cached Records while loading Excel file

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
- Online documentation of Aspose.Cells for Android

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465