Set Link Target Type for HTML Conversion, Access & Update Portion of Rich Text in Cell Using Aspose.Cells for Java 8.6.1
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 character from a cell containing Rich Text. This release has exposed new methods that allow to access & update the portion of the Rich Text in a cell. It adds a new property that can be used to test if a VbaProject in a Workbook is signed or not.
Lane Cove, Australia, November 18, 2015 --(PR.com)-- What’s new in this release?
Aspose team is 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
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
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465
Aspose team is 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
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
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories