• 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

Excel 2010 Advanced Data Validation & Header/Footers Parsing Support

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 7.3.1 has been released. This month’s release provides parsing headers and footers to get strings for different sections. We have also made some valuable enhancements regarding Microsoft Excel 2007/2010′s advanced conditional formatting file formats types that were not supported in the product. Moreover, Microsoft Excel 2010′s advanced data validation is now supported. We have also supported data filters in Pivot Tables. We have made several enhancements regarding redundant temporary files that were created for Excel to PDF feature. We have added support for a new option: “Aspose.Cells.Disable=SunFontManager” to avoid any possible JVM crash. The auto-shapes rendering in the output HTML is further enhanced. We have fixed some bugs and handled exceptions regarding Excel to PDF feature in the latest release. The formula calculation engine has also been improved. This release includes plenty of improved features and bug fixes as listed below

- Parse scripts in Page Setup’s headers/footers
- Conditional formatting - Include DataBar type’s missing fields
- Conditional formatting - Include IconSet type’s missing values
- Conditional formatting - Support - FormatConditionValueType.AutomaticMin/AutomaticMax
- Read conditional formatting rules with cross-sheet formulas
- Support Cells.MinDataColumn and Cells.MinDataRow properties
- Support Cell Background Colors with Conditional Formatting (MS Excel 2010)
- Data Filters of the PivotTable are supported
- Advanced data validation of MS Excel 2010 is supported
- Temporary font files are created more than once when saving to PDF
- Date in Header/Footer has not been formatted accordingly with Workbook's locale settings
- Support new option: Aspose.Cells.Disable=SunFontManager instead of java.awt.headless for JVM crash of Open JDK
- Export auto-shapes for HTML file is improved
- Overlapped text and missed gridlines for saving PDF are fixed
- Extra borders showning when re-saving SpreadsheetML template file as XLS file is fixed
- PDF generation is fixed with specific chart’s data
- Formulas are correctted after inserting range
- The generated PDF from Excel workbook had more number of pages is fixed
- Chart labels became misaligned and overlapped when coping worksheet is fixed

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.

- Converting to PDF Files
- Managing Document Properties

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
- Post your technical questions/queries to Aspose.Cells for Java Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog

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
    Bookmark Topic Watch Topic
  • New Topic