• 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

Object Filtering for Loading Templates & XML Map Data Export to Disc are Enhanced in Java Apps

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 16.12.0 has been released. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. Sometimes, application requirement could be to load just a particular type of objects while loading existing spreadsheets in Aspose.Cells’ object model. For instance, users may require loading only the cells along with formulas & formatting or just the document properties. Aspose.Cells APIs now provide a flexible yet comprehensive mechanism to achieve such requirements by exposing the LoadFilter class. The LoadFilter class along with LoadOptions.LoadFilter property can control the type of data/objects to be loaded while initializing an instance of Workbook from a template file. The constructor of the LoadFilter class can accept constant(s) from the LoadDataFilterOptions enumeration that specifies the type of objects to be loaded. The LoadFilter class also allows customizing the loading process as per the properties of the Worksheet. In order to customize the loading process, one has to override the LoadFilter.startSheet method. Please note, there are just a few properties that can be used for a given worksheet object in this scenario because most of the data and properties have not been loaded yet. This release has enhanced its core for more stability as well as fixed a few critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API. A few of the worth mentioning enhancements are ability to export XML map data to disc, support for ScaleCrop and LinksUpToDate built-in document properties, enhanced PDF rendering engine for font substitution while converting charts to PDF format and handled a few exceptions such as ArrayIndexOutOfBoundsException & CellsException. This release includes several enhanced features and bug fixes as listed below

- Specify Chart points' positions
- XLSM becomes corrupted after re-save operation
- DataBar width is not correct while converting spreadsheet to HTML
- Orange Row is not included in the SUM of Pivot Table
- Chart is missing while converting spreadsheet to HTML
- Row height is not correct while converting XLSX to HTML
- DCOUNTA Excel formula is not evaluated fine by Aspose.Cells formula calculation engine
- Issue with DataBar conditional formatting when saving an XLSM file as PDF
- The space between certain characters gets removed at a few places in the output PDF file
- Chart labels are not displayed/rendered the same (as per the original Excel file) in the output PDF file
- Issue with font attributes of TextBox in the output PDF
- TextBox's content color & size is changed while converting worksheet to EMF
- TextBox's content color & size is changed while converting spreadsheet to PDF
- Hebrew words are not rendered correctly when converting an Excel file to PDF file format
- Content in TextBox is clipped while rendering spreadsheet to PDF
- Arrowed lines are misplaced while rendering spreadsheet to PDF
- Issue with the SVG image of the chart in the rendered HTML file
- Font substitution does not seem to take effect for Chart legend while using Chart.toPdf()
- Legend overlapping with text in Chart's PDF
- Incorrect ChartPoint's ShapeXPx & ShapeYPx values
- Incomplete rendering of the Rectangle shape while converting XLS to HTML
- Text is getting truncated while converting spreadsheet to PDF file format
- Extra pages are added due to some pages are not rendered completely in one PDF page
- SheetRender - Invalid column index
- Extending Excel Table modifies data
- Opening and saving the file while using SheetRender corrupts the output Excel file
- Setting the shape text changes the text style
- Text of some cells like C2 and C3 get unbold
- Worksheet.autoFitColumns method does not seem to take effect when required font is not present in Linux
- Unexpected background color applied to TextBoxes while rendering spreadsheet to PDF

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.

- Filter Objects while loading Workbook or Worksheet
- Export Xml Data linked to Xml Map insde the Workbook

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
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic