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

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. Now users have provided this feature to maintain the precious information through custom properties by exporting them to the PDF files. These properties can be observed in Adobe Acrobat Reader by clicking on File and then Custom tab page in properties sheet. XML data can be imported to worksheets where sometimes XML path is required from the ListObjects of the worksheet. This feature is available in Excel by using expression like Sheet1.ListObjects(1).XmlMap.DataBinding. We are glad to share that this feature is available now in Aspose.Cells as well. Sometimes there is a need of assigning the sheet name at runtime. In this scenario, there may be sheet names which may contain some additional characters like +(?”. There is a need to replace any such character, which is not allowed as a sheet name with some preset character provided by user. Similarly the length may increase to more than 31 characters which needs to be truncated. Apache POI provides certain features of creating safe names, hence similar feature is provided by Aspose.Cells to handle all these issues.It have increased the range of auto filters like filtering based on fill color, date, dynamic date, number and texts. These filters were already part of our previous releases. Need was felt to add filters like blank/non-blank and custom filters with contains and not-contains. This time these filters are added along with sample files so that these features can be tested easily. QueryTable represents a worksheet table built from data returned from an external data source, such as an sql server or a Microsoft access database. Aspose.Cells provides option to read the address i.e. result range of cells for a query table. This release includes plenty of improved features and bug fixes as listed below

• Use FIPS compliant version of Bouncy Castle in Aspose.Cells APIs
• The concurrent conversion to PDF while each workbook has his own private (exclusive) set of fonts
• Implement custom data sorting in Pivot Table report via Aspose.Cells APIs
• The implementation of the MS Excel feature 'Watch Window'
• Unable to extract the text from the gear type SmartArt
• Formula should not contain more than 8192 characters
• Unable to access horizontal category axis labels items of Chart in XLS
• Get/set Language document property
• Foreground color vs Background color vs Fill color - Use a single method that takes two arguments
• "" is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents
• Insert SVG image type into worksheet cells by Aspose.Cells
• Detect LoadFormat and FileFormatType of XLAM
• Exception: "FormulaBuildUnknown formula token0" on Name.getRefersTo()
• Exception: "FormulaBuildMore than one token in stack...." on Cell.getFormula()
• Aspose.Cells accepts and corrects an invalid formula
• Some shapes are not correct in the output PDF
• Conditional formatting is lost while saving Excel to HTML
• Output HTML does not match with MS-Excel
• Links to named area are wrong after export to HTML
• Pivot Tables and corresponding Charts do not have correct Date format
• Chart has many values in x-axis and values are overlapping over each other
• Aspose.Cells returns wrong value of cell A2
• XML map does not create table properly
• Get/extract values (0 for 0 and blank for blank) using DataPoint.getYValue() method for a given chart
• Inversion of subtitles (legend entries) in MS Excel chart
• Arrows are missing in PNG output of Excel Chart
• Java method 'Shape.toImage' works differently with the same method in .NET
• Aspose.Cells 18.3 rotation for a TextBox is not working for EXCEL_97_TO_2003 save format
• Blank new line appears inside the TextBox after processing and saving the Excel file
• Pivot Table's formatting and behavior changed after open/save the template file
• Spreadsheet (XLS) becomes corrupted after simple load & save
• Aspose.Cells breaks iterator interface when calling Iterator.hasnext() twice
• Properties values garbled when extracting document properties
• The workbook is corrupted after adding a watermark
• Same code executes slower in new releases
• Properties are not be extracted in the template file
• NullPointerException when adding HTML to a cell
• Lines disappeared from chart when XLSX file is re-saved
• Some drawing shapes are displaced or rendered wrongly in Excel to HTML rendering
• CELLSJAVA-42619 Unable to extract Smart Art images correctly
• Shape is displaced to cover data in Excel to HTML rendering
• Calculation of formulas are wrong e.g. it generates #DIV/0! errors
• Cell A3 format is not correct in the output HTML
• Poor performance when generating PDF file from an Excel file
• XLSX to TIFF - exception NoClassDefFoundError
• Images are lost when Excel file is converted to Pdf
• Chart.calculate method causes OutOfMemoryError
• Memory increases in rendering Excel file to PDF file format
• Font size changed on Chart Title due to characters() method
• Shadow effect is changed while re-saving XLS
• Excel to PDF conversion - the conversion never completes
• Unable to get or set alternative text for Comment shape
• Aspose.Cells hangs when converting a Spreadsheet ML file (xml) to PDF with self-closing Styles tag
• Unable to set alternative text for SmartArt shape
• getFirstVisibleRow() and getFirstVisibleColumn() returning invalid indices
• Hyperlinks with encoded symbols (such as, "%5c") decode after re-saving

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: 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

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.