Set Link Target Type for HTML Conversion, Access & Update Portion of Rich Text in Cell using Java

This new release enables Java developers to Set Link Target Type for HTML Conversion, Detect If VBA Project is Signed. Access & Update Portion of Rich Text

Online PR News – 16-November-2015 – Lane Cove, NSW, 2066 – What’s new in this release?

We are pleased to announce the new release of Aspose.Cells for Java 8.6.1. Aspose.Cells APIs are capable of converting all supported spreadsheet formats to HTML with highest fidelity. The conversion process is efficient as well as configurable, that is; users can customize the HTML generation process as per their application requirement. Aspose.Cells APIs have exposed the HtmlSaveOptions class that is mainly responsible for the conversion process and provides a vast array of features to influence the HTML generation. This release of Aspose.Cells for Java API has exposed an enumeration namely HtmlLinkTargetType along with a new property HtmlSaveOptions.LinkTargetType that together allows to set the target type for the links in spreadsheet while conversion to HTML format. Aspose.Cells for Java API provides easy to use mechanism to access the format related properties of each character from a cell containing Rich Text. The API has exposed the getCharacters & setCharacters methods for the Cell class that allows to access & update the portion of the Rich Text in a cell. The Cell.getCharacters method returns an array of FontSetting objects where each object represents the styling of an individual character. The Cell.setCharacters method also accepts an array of FontSetting objects to set the styling for individual characters of a cell. Aspose.Cells for Java 8.6.1 has exposed the the VbaProject.isSigned property that can be used to test if a VbaProject in a Workbook is signed or not. Boolean type property returns true if the project is signed. The most notable enhancements in this release includes he PDF & image rendering engines to properly handle the long hyphens, Provided support for WebQuery type of external data source, Handled calculation problem while calculating formula based on Named Range, Improved the chart rendering for PDF & imag and several other. This release includes several enhanced features and bug fixes as listed below

• XLSB becomes corrupted after re-saving with Aspose.Cells
• Cell reference hyperlinks do not work in resultant HTML
• Calculating the named range formula results in #NAME?
• Acrobat Reader shows There was an error processing a page. There was a problem reading this document (135) error, while loading Aspose.Cells generated PDF
• Data Label is overlapping the Data Point while rendering Chart to PDF
• Aspose.Cells is unable to convert the excel file having a chart into pdf
• Y-axis value is missing in the rendered chart image when converting to PDF file format
• X-Axis values in the chart are inappropriate in the output PDF/ image
• Chart border breaks at few locations in the output PDF/Image file
• Words appear to be concatenated in PDF/Image output of excel chart
• Long hyphens don't display appropriately in PDF/Image output of excel chart
• Less Chart Points returned than Points
• Chart's Axis Linked Source property is reset while converting XLSX to XLS
• Font Size is not preserved while converting XML Spreadsheet 2003 to other formats
• Ruby is not copied with Range.copy()
• Loss of custom bin and metadata information during Workbook.copy()
• ActiveXControl text alignment is swapped
• Range does not update after inserting rows
• Conditionalformatting copy issue
• Calculation problem while calculating formula based on Named Range
• Incorrect RadioButon height is returned
• Drop down validation not getting applied to more than one region when spreadsheet is saved as XLS
• Macro code replacement crushes an XLS file if it contains cyrillic names
• Column widths change after re-save with Display set to 125%
• Contents of the xl/drawings/vmlDrawing.vml file changed after re-saving the spreadsheet
• Horizontal alignment issue when loading a file
• Some extra formatted cells in column W of the PDF file
• Some extra formatted cells at the bottom of column P and Q in the PDF
• Output PDF has formatting applied that is not present in Excel
• Changing the font of the cell or part of the text in a cell does not take effect
• List menu move to incorrect position
• Horizontal scroll bar does not move

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.

- Change the HTML Link Target Type:

- Access and Update the Portions of Rich Text of Cell:

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
Phone: 888.277.6734
Fax: 866.810.9465