Win a copy of Micro Frontends in Action this week in the Server-Side JavaScript and NodeJS 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
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Grouping/Sorting Data in Smart Markers, Better Conditional Formatting

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 7.0.2 has been released. It includes several enhancements, including improvements to the Sheet-to-Image and Excel-to-PDF features whish was demanded by most of our users. We have also fixed number of user issues. It also added support for group and sort data in Smart Markers feature. users can now place dynamic rows for sub-totals, totals etc. in between the sections of data while grouping data for your scenarios. Moreover it also included support for JDK1.7 and LightCells APIs for saving XLSX files. This release includes plenty of improved features as listed below

- Support LightCellsDataProvider for saving XLSX files
- Synchronize value type of the property Cells.StandardHeightPixels
- Support to set worksheet as hidden at runtime even if it is the only sheet in the workbook
- Support Grouping Data feature in Smart Markers
- Support Sorting Data feature in Smart Markers
- Include more format condition types (for Conditional Formatting feature) while saving XLS file
- Support encryption type: RC4, Microsoft Enhanced Cryptographic Provider 1.0 128-bit
- Support J2SE7.0 version
- Enhancements are made for Sheet-to-Image feature
- Enhancements are made for Excel-to-PDF feature
- Exception resolved when using scientific values for Validation's formula
- Improved reading encrypted Excel2007 template file
- Enhanced saving XLSX with LightCells APIs
- Picture issues is resolved in XLS-to-PDF feature
- Image creation is fixed for Pyramid Chart
- Invalid PDF file generation is resolved by XLS-to-PDF feature
- Text alignment issues are resolved in the resultant PDF file
- Textbox Content rendering is fixed in PDF file
- MROUND formula now calculate correctly
- ROUND formula now calculate correctly

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.

- Configuring Alignment Settings
- Adding Hyperlinks to Link Data in Excel files

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
Every plan is a little cooler if you have a blimp. And a tiny ad.
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic