• 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 ...
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

Get Spreadsheet’s Application Version & Worksheet Instance from a Chart Using Java

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?

The long awaited version of Aspose.Cells for Java 8.2.2 has been released. Microsoft Excel application allows the user to save spreadsheets to different formats corresponding to the application versions such as Microsoft Excel version 2003, 2007, 2010 and 2013. This information is embedded in the spreadsheet, and can be used for version identification. Aspose.Cells for Java now provides the means to get and set this information with the BuiltInDocumentPropertyCollection.Version property. Check the detailed article on Getting the Version Number of the Application that Created the Excel Document. Before the release of Aspose.Cells for Java 8.2.2, retrieving the Worksheet instance from the Chart object was not possible. The latest version has made this possible by exposing the Worksheet property for the Chart class. Please check the usage scenario below and the detailed article on Getting Worksheet of a Chart. The latest release of Aspose.Cells for Java 8.2.2 has fixed numerous problems, and the most notable of these includes, enhanced the overall performance of the Aspose.Cells API, tweaked the Worksheet2Image & Chart2Image rendering mechanisms, improved the Formula Engine to correct issues related to AVERAGEID, SUMPRODUCT & INDIRECT functions and several others. This release includes plenty of improved features and bug fixes as listed below

- AppVersion xml tag found inside the docProps/app.xml is needed
- Get Worksheet of a Chart
- Aspose.Cells hangs while loading a particular file
- Performance - improve reading phase of workbook to load it more quickly
- Fixed: Image gets cut when shape is rendered
- Named range issue - MS Excel prompts "Excel found unreadable content..." error when opening the output file into it is now fixed
- XLS File format - Extract Excel integer as String to avoid ".0"
- Workbook.calculateFormula() - Number rounding problem is now resolved
- Incorrect value is corrected for AverageIf after calling Workbook.calculateFormula() method
- Combining workbooks into a single workbook corrupts the output workbook is fixed in this release.
- Hyperlink to a file with space in filename does not work
- Pdf Ole Object becomes image after combining workbooks is now fixed
- SUMPRODUCT with Multiple INDIRECT Functions calculates the Formula as #VALUE is fixed
- Problem with Sparkline is resolved when merging two workbooks
- Incorrect formula value is fixed after calling Workbook.calculateFormula
- External Hyperlink issues is fixed and now work for XLSX format
- Formulas are now calculated correctly by Aspose.Cells
- Transition formula evaluation issue is resolved
- Workbook is broken after save is now fixed
- Row.getHeight now gives correct value with hidden column
- Issue due to input value more than 32K in a cell is now fixed
- Graphlines for chart datapoints are now connected in rendered PDF
- Chart's footnotes appearance is resolved after resaving workbook
- Unwanted Chart Axis values rendered in the PDF is fixed
- Incorrect rendering of long lines are fixed in chart legend
- Chart's series marks/ data labels issue is resolved when rendering to an image file
- Pie chart section lines issue is fixed and nowvmeet correctly in the middle
- Missing elements are resolved when extracting complex charts

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.

- Get the Version Number of the Application that Created the Excel Document
- Get Worksheet of the Chart

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
- Demos 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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic