Win a copy of Secure Financial Transactions with Ansible, Terraform, and OpenSCAP this week in the Cloud/Virtualization 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

Optimized Memory Usage for Worksheets & Corrupt Excel Files Identification in Android

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?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 7.0.0 . Aspose.Cells for Android provided memory optimization settings for newly created worksheets by exposing the setMemorySetting method for the Workbook.Settings class. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Microsoft Excel spreadsheets containing huge datasets. With release 7.0.0, we have enhanced this feature for existing worksheets by exposing a similar method for the Cells class. Now you may use setMemorySetting method provided by the Cells class to cope with the memory issues for situations where large data sets have to be built in memory. The setMemorySetting method accepts a parameter of type MemorySetting with the default value NORMAL. In order to properly utilize this newly introduced feature, memory optimization settings have to be explicitly specified for existing worksheets. Please check the detailed technical article on how to optimize the memory while working with large data sets from our documentation. We have also enhanced the CellsException class to identify potentially damaged or corrupted files when loaded with the Workbook constructor. With the new enhancements integrated, Aspose.Cells for Android API now throws an error of type CellsException whenever it encounters a damaged file. Aspose.Cells for Android 7.0.0 has also provided fixes for several important issues. For example, problems with converting Excel files to PDF format, rendering & manipulating charts, retrieving & removing OLE objects. Moreover, we have improved the overall performance as well as the accuracy of results for the formula calculation engine when working with Excel formulas. This release includes plenty of improved features and bug fixes as listed below

- How to identify corrupt excel files (2007)
- Search license according to cells jar or application jar's position
- Missing characters resolved when converting from XLSX to PDF
Calculation formulas
- Picture format changes to default values after opening and saving xlsm file
- setCreateCalcChain(true) – Cells are now updated
- Border and wrap text issue is fixed
- .PPT converted to empty Pdf by Aspose.Cells
- OleObjectCollection.removeAt() now properly remove the OLE object
- Text is grabbling fixed in resultant PDF when text overflows a cell
- Memory issues are resolved when using Aspose.Cells
- Legend of chart and title of Y axis are now corrected in the output image
- hashCode calculation issues are fixed and does match for the cells

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.

- Optimizing Memory Usage while Working with Big Files having Large Datasets
- 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
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
Willie Smits increased rainfall 25% in three years by planting trees. Tiny ad:
SKIP - a book about connecting industrious people with elderly land owners
    Bookmark Topic Watch Topic
  • New Topic