Encrypt/Decrypt ODS File, Change Cells Alignment & Keep Existing Formatting using Jav

What is new in this release?

The long awaited version of Aspose.Cells for Java 18.7 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. It is quite often that Aspose team 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 users desired range of cells. The following 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, Users 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. There are some other enhancements included and a few exceptions handled in the new release for the users. There are some worth mentioning features and other improvements are part of this release, such as support multiple values when using class style, Correction in Smart Art Image extraction, resolve hyperlinks issue when viewing the output Excel file in MS Excel Japanese version, Handled “Getting #NUM for a cell having IRR function” , HTML to XLS – CSS style ignored, Handled “java.lang.NullPointerException” while calculating formula and more. In Aspose.Cells 18.7, we fixed several important bugs and other issues. For example, issues around Workbooks with XL4 macros (XLSM), fetching comment text instead of alternative text, handling exceptions like “IndexOutOfBoundsException” while calling Chart.calculate() and “Invalid encoding: null” while loading the XLS file. Below are some important new features, enhancement and bug fixes part of this release.

- Support multiple values when using class style (Linked to: CELLSJAVA-42635)
- Unable to extract Smart Art images correctly - Shape to image conversion (CELLSJAVA-42619)
- The output PDF document is too big
- Hyperlinks issue when viewing the output Excel file in MS Excel Japanese version
- Getting '#NUM!' for a cell having IRR function
- Workbooks with XL4 macros (XLSM) become corrupt after save
- AlternativeText returns value of the comment Text
- HTML to XLS - CSS style ignored
- Exception "java.lang.NumberFormatException" when loading an Excel file
- Exception "java.lang.NullPointerException" when calculating formulas in the workbook
- Chart.calculate() throws IndexOutOfBoundsException
- Exception: "Invalid encoding: null" when loading an XLS file – II

Other most recent bug fixes are also included in this release

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java

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