Encrypt/Decrypt ODS Files, Change Excel Cells Alignment & Keep Existing Formatting in Android Apps

LANE COVE, Australia - Oct. 15, 2018 - PRLog -- What's new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.9. This release includes some new features, enhancements and other bug fixes that further improve the overall stability and usability of the API. It is quite often that we need to change the alignment of multiple cells but at the same time need to maintain the existing formatting as well. StyleFlag.Alignments property is provided by Aspose.Cells to achieve this functionality. Please note, StyleFlag object is passed as a parameter to Range.applyStyle() method which actually applies the formatting to a desired range of cells. The sample code loads the sample Excel file, creates the range and center aligns it horizontally and vertically and keeps the existing formatting intact.  For users information, there are different number of rows and columns supported by different MS Excel file formats. For example, XLS supports up to 65536 rows and 256 columns while XLSX supports 1048576 rows and 16384 columns. If users want to know how many rows and columns are supported by a given format, user can use Workbook.getSettings().getMaxRow() and Workbook.getSettings().getMaxColumn() methods. Users can specify author name while write protecting a workbook using Aspose.Cells API. Please use Workbook.getSettings().getWriteProtection().setAuthor() method for this purpose.  Aspose.Cells allows users to encrypt and decrypt an ODS file. Decrypted ODS file can be opened both in MS Excel and OpenOffice, however encrypted ODS file can only be opened by OpenOffice after providing the password. Excel cannot open the encrypted ODS file and may raise warning message. For encrypting an ODS file, load the file and set the WorkbookSettings.Password value to the actual password before saving it. It is very common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment. This option allows screen reader software to utilize the text within the PDF file for reading.  Users can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved  using Aspose.Cells for Java now.  Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organizations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating them. For this purpose Excel provides feature to disable pivot table ribbon and same is provided by Aspose.Cells i.e. developer can disable the ribbon which contain controls to modify these reports. Reliability and efficiency is basic requirement by the users for any software product. If some conversion takes too long, sometimes it is required to interrupt this process to return control to the user. This feature is already present but got some performance issues, however It has further improved it and now can be used without any trouble.   While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste option was available in contrast to Excel where variety of options are available when it paste data somewhere in Excel. Now Aspose.Cells has provided this feature and users can paste data with multiple options. Many documents can have custom properties which were not made part of the PDFs earlier.

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://downloads.aspose.com/cells/android

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

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