• 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

Spreadsheets to HTML Export, Worksheet Scenarios & GridWeb Component Support

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.1.1 has been released. Our team has been hard at work bringing many useful improvements with the latest edition of Aspose.Cells library. The class HtmlSaveOptions has been enhanced to render HTML results with better layout. The feature is now available through the Boolean type PresentationPreference property which can be set to true while exporting spreadsheets to HTML format to get a better presentation layout. With previous releases of Aspose.Cells for Java API, when a possibly damaged spreadsheet was loaded in an instance of Workbook, the API tended to throw a generic message not mentioning where the problem could be. We have changed this behavior since 8.1.1, so that now the API throws an exception with a meaningful message to point out where (which cell) and what (formula expression) causes the exception when reading the template file. Scenarios are part of a suite of commands called what-if analysis tools provided by Microsoft Excel. What-if analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. They are useful for forecasting and financial models. Microsoft Excel saves a set of values in a scenario, and can automatically substitute these values in the worksheet. With this release of Aspose.Cells for Java, Aspose has provided support for scenarios to allow developers to create, manipulate and remove scenarios without needing Microsoft Excel. Aspose.Cells for Java has exposed many useful classes to make this task possible. Aspose.Cells for Java 8.1.1 has been packaged with the GridWeb component that can be used in Java based web applications to render and visually manipulate spreadsheets on the go. The download package also contains a demo – gridwebdemo.war – that you can deploy on your web server to see the component in action. This release includes plenty of improved features and bug fixes as listed below

- Support GridWeb for Java
- Cell.StringValue/DisplayStringValue returns # for thin columns when - Worksheet.DisplayZeros=false
- Give meaningful messages for CellsException when loading a damaged spreadsheet
- Conditional formatting background colors are now rendered in the PDF
- Setting the ImageOrPrintOptions' Transparency renders the PNG with Black - Background is now fixed
- XLSX to PDF: CellsHelper.setFontDir does not seem to pick the fonts is fixed
- Cell.getType() is detecting number as datetime is now fixed
- Support for localized formats in formulas is now fixed

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.

- Create, Manipulate or Remove Scenarios from Worksheets
- Excel to HTML - Use PresentationPreference Option for Better Layout

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
- Demos 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
Lasagna is spaghetti flvored cake. Just like this tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
    Bookmark Topic Watch Topic
  • New Topic