Convert DataBars to Images & Modify VBA Code Inside Spreadsheets Using Aspose.Cells for Android 8.4.0
It allows manipulate VBA codes embedded inside the spreadsheets and DataBars to Images conversion. Another worth mentioning feature is the support for Pivot Table removal and different Pivot Table layouts support same like Microsoft Excel. Adding custom properties for the document information panel and issues related to reading/writing and rendering Microsoft Excel files, calculating formulas, manipulating charts and shapes, sheet to image and Excel to PDF are also part of this release.
Lane Cove, Australia, April 01, 2015 --(PR.com)-- What’s new in this release?
Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.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 deleting 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 8.3.1.5
• 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 users 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 users briefly how to use Aspose.Cells for performing different tasks like the following:
- Modifying VBA or Macro Code using Aspose.Cells: http://www.aspose.com/docs/display/cellsandroid/Modifying+VBA+or+Macro+Code+using+Aspose.Cells
- Adding Custom Properties visible inside Document Information Panel: http://www.aspose.com/docs/display/cellsandroid/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: 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
- Post technical questions/queries to Aspose.Cells for Android Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Android blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.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 deleting 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 8.3.1.5
• 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 users 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 users briefly how to use Aspose.Cells for performing different tasks like the following:
- Modifying VBA or Macro Code using Aspose.Cells: http://www.aspose.com/docs/display/cellsandroid/Modifying+VBA+or+Macro+Code+using+Aspose.Cells
- Adding Custom Properties visible inside Document Information Panel: http://www.aspose.com/docs/display/cellsandroid/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: 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
- Post technical questions/queries to Aspose.Cells for Android Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Android blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories