• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

Convert DataBars to Images & Modify VBA Code inside Spreadsheets in Android Apps

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 8.4.0 . This release contains many useful improvements and features including the long awaited feature to manipulate VBA code embedded inside the spreadsheets. Many of the Aspose.Cells users had been waiting for this feature, and now it is available with the release of Aspose.Cells for Android 8.4.0. The latest build of the API has exposed a new package and a few classes to provide the means to access the VBA code embedded inside the macro enabled spreadsheets, and to amend the code as per requirement. Another worth mentioning feature is the support for Pivot Table removal. Aspose.Cells for Android 8.4.0 has provided this feature by exposing two new methods for the PivotTableCollection class that allows to delete a specific PivotTable from the collection depending upon the input parameter. Microsoft Excel has predefined layouts for the Pivot Tables as listed below. Upon choosing any of these layouts, Microsoft Excel formats the Pivot Tables according to Compact Form, Outline Form and tabular Form. Aspose.Cells for Android 8.4.0 provides the same functionality while using the newly exposed methods for the PivotTable class that allows to dynamically set the layouts as discussed above. With the release of v8.4.0, the Aspose.Cells API has provided the DataBar.toImage method to save the conditionally formatted DataBar in image format. Aspose.Cells can be used to add custom properties inside the workbook object which are visible in the Document Information Panel when accessed through Microsoft Excel using the File > Info > Properties > Show Document Panel menu. Aspose.Cells for Android 8.4.0 has provided fixes and other enhancements for several important issues, such as, reading/writing and rendering Microsoft Excel files, calculating formulas, manipulating charts and shapes, sheet to image, chart to image and Excel to PDF bugs, etc. This release includes plenty of improved features and bug fixes as listed below

- Extract Theme Data from Excel Files
- Generating Databar Images
- Remove bogus null attributes in the generated HTML file
- Japanese calendar support
- Pivot table sort field is wrong in XLSX output
- HtmlSaveOptions.setExportHiddenWorksheet(true) is not working properly
- Changes in cross cell text cropping since 8.3.1 to
- Refreshing Pivot Tables generate corrupt workbook
- Bug - Formula contains a defined name ending with number+e
- EMF generated with Aspose.Cells renders differently in different Viewers
- XLSB becomes corrupted after adding a worksheet and a cell value
- API cannot substitute the Arial font with Liberation Fonts
- Error in image conversion when rendering Excel to PDF
- Signing of exported PDF files fails
- Rendering Hints (Anti Aliasing) does not work with SheetRender
- Wingdings Symbols are not rendering properly when worksheet is rendered to image
- Issues with output image rendering from the Chart
- Data labels of pie chart are overlapping in the chart image
- Overlapping of DataLabels of Pie Chart when chart is rendered as image
- Pie Chart's data label overlap in the rendered HTML
- Smooth line is not proper when point color is different
- Display Cell Comments in GridWeb component
- Dragging the row height to 0 causes the GridWeb not to display the value
- Data Validation List does not display in GridWeb
- When borders thick, height increases when delete the cell value in GridWeb
- When borders are thick, Header heights do not match in GridWeb
- Header and cell widths do not match in GridWeb
- Widths of headers for Columns are different from the widths of cells in Chrome/Opera

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.

- Modifying VBA or Macro Code using Aspose.Cells
- Adding Custom Properties visible inside Document Information Panel

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
incandescent light gives off an efficient form of heat. You must be THIS smart to ride this ride. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
    Bookmark Topic Watch Topic
  • New Topic