Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code 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 ...
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
  • Piet Souris
  • salvin francis
  • fred rosenberger

Add VBA Modules to Excel Spreadsheet & Improved Chart Creation Mechanism using Java

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

The long awaited version of Aspose.Cells for Java 8.4.2 has been released. Starting with this release, Aspose.Cells for Java has provided support for adding VBA modules to the spreadsheets. Aspose.Cells for Java 8.4.2 has exposed the VbaModuleCollection.add method to add a new VBA module to the instance of Workbook. The VbaModuleCollection.add method accepts a parameter of type Worksheet to add a worksheet specific module, whereas the existing VbaModule class contains all the module specific properties. Aspose.Cells for Java 8.4.2 has exposed simplified mechanism to create charts on the fly. Please note, the conventional means of creating charts involves several steps that may include, but not limited to specifying the series and category axis data ranges separately. With new mechanism, all you have to do is to specify the chart’s data range while using the Chart.setChartDataRange method. The setChartDataRange method accepts two parameters, where first parameter is of type String in order to specify the cell area from which to plot the data series. The second parameter is of type Boolean that specifies the plot orientation, that is; whether to plot the chart data series from a range of cell values by row or by columns.Aspose.Cells for Java 8.4.2 has fixed a number of issues and enhanced the core to accommodate many customer requests. Few worth mentioning enhancements & fixes includes, support for IFNA function, added an overloaded version of Cells.copyColumns method that can be used to repeat the source columns onto the destination while copy operation, exposed 2 new fields for the PasteType enumeration in order to mimic the Excel’s ‘All’ & ‘All except borders’ functionality for pasting range of cells, improved the PDF rendering engine to handle cases that involve WordArt, shapes and uppercase characters converted through Excel’s ‘All caps’ functionality, improved Chart2Image functionality for EMF file format to correctly render axis and data labels, addressed a few exceptions related to the spreadsheets loading & saving mechanism of Aspose.Cells for Java API. This release includes plenty of improved features and bug fixes as listed below

- Add VBA Modules to Excel Spreadsheet
- Easy way for Chart setup
- Watermarks are not displayed correctly
- Slicer is removed in Excel 2010/2013 after save
- Uppercase characters created through 'All caps' functionality in Excel is not preserved in PDF
- Rendering of Shapes in Page 5 is not correct
- Shape location is wrong while rendering spreadsheet to PDF format
- Arrow heads are enlarged while converting spreadsheet with drawings to PDF
- WordArt is not rendering fine in the output PDF file
- Horizontal text in the shapes is rendered vertical while converting spreadsheet to PDF
- Drawing is messed up while rendering the spreadsheet to PDF
- Circle shapes convert to ovals while rendering spreadsheet to PDF
- Drawing objects and shapes in Excel template are not rendered fine in the output PDF using Aspose.Cells
- Latest Aspose version fails to save file saved through earlier version
- File gets corrupt when xls is saved into xlsx format
- Workbook.copy() corrupts the output excel file
- Calculation bug with OR function
- Auto-fit columns operation does not take effect with a few cells with ShrinkToFit option on
- Solid lines are showing up as Dotted lines
- Excel to PDF conversion issue - right side cut off
- Some DataLabels are missing in the rendered HTML file when copying workbook
- DataLabels in the chart are not shown in the rendered EMF image
- Missing Chart's Axis labels while converting to EMF
- Hebrew characters in 'smart art' present in excel are mirrored in PDF rendition
- Incorrect Pie Chart Data when rendered through Aspose
- Height of the Chart's Plot Area increases after combining Workbooks
- Rendering only Pie chart results in a blank PDF
- Chart.toImage generates a blank image for Pie Chart
- Two of the Axis labels are missing in the resultant EMF while converting chart to image
- Rendered image of the chart is not right (Chart to Image)
- Chart.calculate() misplaces X and Y axis labels

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 Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Adding VBA Module and Code using Aspose.Cells
- Calculating IFNA function using Aspose.Cells

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java

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
The problems of the world fade way as you eat a piece of pie. This tiny ad has never known problems:
Devious Experiments for a Truly Passive Greenhouse!
    Bookmark Topic Watch Topic
  • New Topic