• 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 ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

Get Connection Points from Shapes in Spreadsheet & Handle Self Closing Tags in HTML 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 18.10 has been released. This release contains several important new feature, enhancements and bug fixes. Aspose team put effort to greater extent to make our product easy to use and error free by working hard on all the issues which are reported by the vast developer’s community. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be case where this fixed size may not be required. For example if container panel width is 600px where this HTML page is being displayed. In this case you may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self-closing tags were not supported however now this support is provided. Now you can load any HTML with self-closing tags and convert it to Excel file. Named regions can have English formulae and this file can be used in environments where  systems are configured to German Locale. There is need to translate these English formulae completely to German language for correct usage in Excel configured for German language. This feature is fully functional and can be used without any extra coding. Excel provides custom filters like filter rows which begins with and ends with some specific string. This feature is available in Aspose.Cells and demonstrated by providing working examples.  Aspose.Cells provides rich features to manage shapes in the spreadsheet. Sometimes there is need to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Following code can be used to get the list of connection points of a shape where Shape.GetConnectionPoints() function is used. There are some other enhancements and exceptions handled in this new release, such as Convert left right ribbon shape to image, An exception(StackOverFlow) raises when saving to PDF output, Copy a range with PasteType.ALL (Paste options) not copying row heights properly, Invalid Russian date format output, Exception “java.lang.OutOfMemoryError: Java heap space” when rendering MS Excel file to PDF, Quotes appear in formula when retrieving the cell formula via Aspose.Cells and Performance degradation when using conditional formatting. Below are some important new features, enhancement and bug fixes part of this release.

- Convert left right ribbon shape to image
- Aspose.Cells for Java JavaDocs - missing package-list file
- Font is not a valid HTML5 and self-closing tag and web browsers misrepresent its contents
- An exception(StackOverFlow) raises when saving to PDF output
- Wrong value calculated by ROUNDUP()
- Copy a range with PasteType.ALL (Paste options) not copying row heights properly
- Hyperlink text formatting lost when new text is set
- Invalid Russian date format output
- Issue with SheetRender fonts
- Exception "java.lang.OutOfMemoryError: Java heap space" when rendering - MS Excel file to PDF
- Quotes appear in formula when retrieving the cell formula via Aspose.Cells
- Performance degradation when using conditional formatting
- An exception(StackOverFlow) raises when saving to PDF output

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 users briefly how to use Aspose.Cells for performing different tasks like the followings.

- Support for German Locale in Named Range Formulae
- Get Connection points from shape

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
Australia
Aspose - The .NET and Java component publisher
[email]sales@aspose.com[/email]
Phone: 888.277.6734
Fax: 866.810.9465
 
To do a great right, do a little wrong - shakepeare. twisted little ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic