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

2024-10-29 10:26:10 Computer

775

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: 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.

More about Aspose.Cells for Java

- 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

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Java Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

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