Render Cell Comments in PDF & Modify SQL Database Connection Settings using Java

[sherazam khan]

What is new in this release?

The long awaited version of Aspose.Cells for Java 8.4.1 has been released. Starting with this release, Aspose.Cells for Java has dropped the support for Java versions prior to v6 and has moved its codebase to Java 6 (Java 7 and 8 are also supported). Reason being, Sun/Oracle has discontinued the support for all JDK revisions prior to 1.6. Now the Aspose.Cells for Java package contains a single Jar that works well with Java 6, 7 & 8. Microsoft Excel application allows to create the database connection so that the data could be fetched and loaded in the spreadsheets to refresh Pivot Tables, Charts or just the worksheet. The external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, query, and access the external data source. Aspose.Cells for Java API does not allow to create a database connection yet, however, some revisions back, the API had exposed the ExternalConnection class that contains the method & properties that could be used to inspect the database connection details stored in a spreadsheet. Most of the properties associated with ExternalConnection class were read-only until the release of Aspose.Cells for Java 8.4.1. With this release, the API has provided the support to manipulate the database connection settings. Another worth mentioning feature is the support for setting desired image dimensions while exporting spreadsheets & charts to image formats. Aspose.Cells for Java 8.4.1 has exposed the ImageOrPrintOptions.setDesiredSize method to set the dimensions of the resultant image while exporting spreadsheets & charts to images. The setDesiredSize method accepts two integer type parameters, where first is the desired width and second parameter is the desired height. The code snippet given on blog post page shows how to set the desired dimensions while exporting Worksheet to PNG. Please note, similar mechanism can also be used to set the image dimensions while converting Charts to image formats. The API has recently exposed the DataLabels.characters method to retrieve an instance of FontSetting class that corresponds to the sub-string of a ChartPoints.DataLabels. In turn, the instance of FontSetting class can be used to format the sub-string of the Data Labels with different font settings & color. Aspose.Cells for Java 8.4.1 has exposed the Workbook.isLicensed which could be of great help in determining if the license has been successfully loaded or not. If you access this property before setting the license, it will return false and true for a properly set valid license. Aspose.Cells for Java 8.4.1 has fixed a number of issues and enhanced the core to accommodate many customer requested features. This release includes plenty of improved features and bug fixes as listed below

- Gridweb :setting diffrent border through web operation
- Moved main codebase to Java 6 (Java 7 and 8 are also supported). Dropped support for Java 5 and 1.4.
- Support RenderToSize API for Worksheet Image
- Support Bullets while using SmartMarkers or Cell.setHtmlString method
- Aspose.Cells does not generate individual HTMs and CSS file for the sheets in Excel to HTML conversion
- SheetRender.toImage renders the image with "(blank)" labels on x-axis of the chart
- Issue with Cells.insertRange() as the merged area is not shifted fine
- Text in Arial font getting trimmed from top while rendering the spreadsheet to PDF
- PAPER_A_2 does not work as expected when saving as PDF
- When series category data has comma then PIE chart legends does not show correctly
- Overlapping of the Legend Entries while converting Chart to Image
- Dotted Line is missing in Chart 1
- Horizontal Gridlines are missing in Growth Chart
- Setting the Name.setRefersTo and recalculating formulas result in incorrect value while converting spreadsheet to HTML
- Loading & saving the XLSX with Aspose.Cells make the resultant spreadsheet corrupt
- Custom button becomes picture and caption disappears in the output xlsx
- Microsoft Excel crashes when the output xlsx file is opened
- Dropdown disappears in the output xlsx file
- Multi-byte characters in the data validation list are changed to "??" when selecting it in the FireFox
- Cannot unhide, select or increase the height of the hidden row in GridWeb
- Navigation is wrong when moving from C1 --> C3 cell using Arrow keys
- Some conditional formatting rules cannot be used or partially used in the template file when imported to GridWeb

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.

- Modify existing SQL Data Connection using Aspose.Cells
- Export Worksheet or Chart into Image with Desired Width and Height

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

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