File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Blatant Advertising and the fly likes Read Password Protected Excel 2013 Files & Print Excel Comments in Java Apps Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "Read Password Protected Excel 2013 Files & Print Excel Comments in Java Apps" Watch "Read Password Protected Excel 2013 Files & Print Excel Comments in Java Apps" New topic
Author

Read Password Protected Excel 2013 Files & Print Excel Comments in Java Apps

sherazam khan
Ranch Hand

Joined: Mar 10, 2010
Posts: 287
What is new in this release?

The long awaited version of Aspose.Cells for Java 7.7.2 has been released. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.setJustifyDistributed() method so you can apply the justify distributed setting while applying text alignment settings on cells. We also provide support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType. We have enhanced the unhiding rows/columns feature in this release. While making a hidden column or row visible, if you want to restore it to previously assigned width/height or to its original width/height, you can unhide the column or row with a negative width/height. We have added a number of enhancements and fixes in the new release. For example, you can now print comments in a Microsoft Excel document while rendering to PDF.We have improved the chart to image and sheet to image modules and fixed issues with manipulating charts and shapes. Several other important issues have also been addressed. Issues to do with exporting Excel workbooks to PDF format have been resolved. A few other improvements are also made to Aspose.Cells for Java’s formula calculation engine. We have fixed a few exceptions when reading and writing Microsoft Excel file formats too. This release includes plenty of improved features and bug fixes as listed below

- Support opening password protected MS Excel 2013 files
- Print comments on an Excel document
- Support Justify Distributed Alignment Setting
- Remove hardcode usage of com.sun.image.codec.jpeg.JPEGCodec
- Unhide Row with previously assigned height
- Axis.setTickLabelSpacing() is now working for XLS version
- Cell borders were rendered on opaque cells
- Problem with wildcard parsing in formula calculation is fixed
- Some columns are narrow to contain text properly is now fixed
- IStreamProvider.setCustomPath now have effect to file tabstrip.htm
- Extracting formatted Chinese Date issue is resolved
- getStringValue() returns #VALUE!
- Validation now working after converting to XLS format
- XLSX to PDF: Underline below the hyperlink is getting spread out to adjacent character positions is now fixed

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 Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Configuring Alignment Settings
- Converting Excel to PDF Files

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
- Demos of Aspose.Cells for Java
- Post your technical questions/queries to Aspose.Cells for Java Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email]sales@aspose.com[/email]
Phone: 888.277.6734
Fax: 866.810.9465
 
 
subject: Read Password Protected Excel 2013 Files & Print Excel Comments in Java Apps