• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

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

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

The long awaited version of Aspose.Cells for Java 8.6.1 has been released. 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

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic