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

It has exposed an enumeration along with a new property that allows setting the target type for the links in spreadsheet while conversion to HTML format. The API now provides easy to use mechanism to access the format related properties of each chars
By: Aspose
 
LANE COVE, Australia - Nov. 16, 2015 - PRLog -- 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

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: http://www.aspose.com/docs/display/cellsjava/Change+the+HTML+Link+Target+Type

 - Access and Update the Portions of Rich Text of Cell: http://www.aspose.com/docs/display/cellsjava/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.

-  Homepage of Aspose.Cells for Java: http://www.aspose.com/java/excel-component.aspx

-  Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

-  Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

Contact Information

Aspose Pty Ltd,

Suite 163, 79 Longueville Road

Lane Cove, NSW, 2066

Australia

http://www.aspose.com/

sales@aspose.com


Phone: 888.277.6734

Fax: 866.810.9465

Contact
Aspose
***@aspose.com
End
Source:Aspose
Email:***@aspose.com Email Verified
Tags:Update Rich Text Portion, Detect If VbaProject Signed, Java Excel Component
Industry:Software
Location:Lane Cove - New South Wales - Australia
Account Email Address Verified     Account Phone Number Verified     Disclaimer     Report Abuse
Aspose Pty Ltd. PRs
Trending News
Most Viewed
Top Daily News



Like PRLog?
9K2K1K
Click to Share