Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Create/Edit Worksheet Scenarios & Enhanced Spreadsheets to HTML in Android

 
Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 8.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
- 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
- Download Aspose.Cells for Android
- Online documentation of Aspose.Cells for Android
- Demos of Aspose.Cells for Android

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
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic