David Zondray

David Zondray

  • NA
  • 0
  • 67.3k

Create/Edit Worksheet Scenarios & HTML Rendering in Android

Jul 25 2014 3:03 AM

What's new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.1.1. 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. Aspose.Cells for Android has provided support for scenarios to allow you to create, manipulate and remove scenarios without the need of Microsoft Excel. Aspose.Cells for Android has exposed many useful classes. The class HtmlSaveOptions has been enhanced further to render HTML results with better layout and presentation. The feature is now available through the Boolean PresentationPreference property which can be set to true when exporting spreadsheets to HTML format to get a better presentation layout. For further elaboration on this topic, please check the detailed article on using the PresentationPreference option. Aspose.Cells for Android 8.1.1 has provided fixes and other enhancements for several important issues, such as, reading Microsoft Excel files, manipulating styles and calculating formulas, manipulating charts and shapes, rendering & manipulating conditional formatting, fonts related issues while rendering to PDF files, Sheet to image bugs and localized formulas formats etc. 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 Android 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: http://www.aspose.com/docs/display/cellsandroid/Create,+Manipulate+or+Remove+Scenarios+from+Worksheets

 

-   Create Transparent Image of Excel Worksheet: http://www.aspose.com/docs/display/cellsandroid/Create+Transparent+Image+of+Excel+Worksheet

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android: http://www.aspose.com/android/excel-component.aspx

-  Download Aspose.Cells for Android:  http://www.aspose.com/community/files/74/android-components/aspose.cells-for-android/default.aspx

- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home

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

Contact Information

Aspose Pty Ltd,

Suite 163, 79 Longueville Road

Lane Cove, NSW, 2066

Australia

http://www.aspose.com/

[email protected]

Phone: 888.277.6734

Fax: 866.810.9465