Load Only Visible Worksheets from Existing Spreadsheets & Create Excel’s Built-in Styles Using Aspose.Cells for Java 8.6.3
It supports loading only the visible worksheets from an existing spreadsheet, where the hidden worksheets will be simply ignored and will not be available in the Aspose.Cells object model for any processing. This release also supports creating Excel’s Built-in Styles. This release has addressed some formatting issues reported for the XML Spreadsheet 2003 to XLSX conversion. It also enhanced the PDF rending engine to maximize the fidelity for the Excel Chart objects.
Lane Cove, Australia, January 13, 2016 --(PR.com)-- What’s new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.6.3. This month’s release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells APIs provide a set of classes for the developers to influence the spreadsheet loading mechanism. While using the LoadOptions & LoadDataOptions classes, the developers can set a number of options such as force the API to load specific worksheets, where the worksheets can be specified via their indices or names. It has exposed another useful property for the LoadDataOptions class which allows to load only the visible worksheets from an existing spreadsheet, where the hidden worksheets will be simply ignored and will not be available in the Aspose.Cells object model for any processing. The newly exposed property is of type Boolean; setting it to true means that the API will ignore the hidden worksheets and load only the visible worksheets for further processing. It has exposed a method that can be used to create an object of the Style class that corresponds to one of the built-in styles offered by the Excel application. The Workbook.createBuiltinStyle method accepts a constant from the enumeration BuiltinStyleType. Please note, with previous releases of the Aspose.Cells APIs, same task could be accomplished via StyleCollection.createBuiltinStyle method but as the recent releases of Aspose.Cells APIs have removed the class from the public API therefore the newly exposed Workbook.createBuiltinStyle method can be considered as an alternative approach to achieve the same goal. This release includes several enhanced features and bug fixes as listed below
• How to create BuiltinStyleType with Workbook.Styles being obsoleted
• Failure in processing upper-case image source tag when converting from HTML to Excel
• Hidden cell is wrongly displayed in output HTML
• Repeat All Item Labels option is not working for the PivotTable
• Text in the Text Box is getting cut-off while rendering the spreadsheet to PDF
• Extra column in the HTML output of Excel document
• Cells.importCSV() not using existing cells' formatting
• API returns #DIV/0! where Excel calculates the value correctly
• Calculated formula values do not match with Excel
• Issue with Cells.inserRange() method which is not inserting range fine
• Formula calculation unexpectedly produces #NAME?
• XLS to PDF Conversion - Font and Font Size are not correctly converted
• DataBar to Image: Right borders are not rendered
• Legends of the graph are formatted with different colors
• Long hyphens don't display appropriately in the output PDF/Image for the chart
• Wrong Chart-Area appears in chart's PDF
• Wrong border color in Chart's PDF using Chart.toPdf
• Small white line appears when generating Chart's PDF with Chart.toPdf
• Vertical rule appears behind other graphics in Chart's PDF using Chart.toPdf
• Wrong X-axis labels appear in Chart's PDF using Chart.toPdf
• X axis scale interval has changed in Chart's PDF while using Chart.toPdf
• Extra label and rule is added on Y-axis and labels of X-axis are lost in Chart's PDF while using Chart.toPdf
• Xaxis line rendered in front of chart content in Chart's PDF while using Chart.toPdf
• All x-axis labels missing in Chart's PDF while using Chart.toPdf
• Legend icon in chart is smaller while rendering spreadsheet to PDF
• Trendline in chart is shorter while rendering spreadsheet to PDF
• Horizontal Grid-Lines of chart are not appearing properly in PDF
• Legend is getting trimmed in chart while converting Chart to PDF
• One image is missing and one is incorrectly rotated in the rendered PDF - Excel to PDF Conversion
• Format of the Chart Data Labels has changed while rendering to PDF
• Unable to change the one of the Data Label's text
• Legend is getting trimmed in chart while converting spreadsheet to PDF
• Axis title has been displaced in chart while converting spreadsheet to PDF
• Hidden formula has been rendered in chart while converting spreadsheet to PDF
Other most recent bug fixes are also included in this release
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: http://www.aspose.com/java/excel-component.aspx
- Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx
- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.6.3. This month’s release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells APIs provide a set of classes for the developers to influence the spreadsheet loading mechanism. While using the LoadOptions & LoadDataOptions classes, the developers can set a number of options such as force the API to load specific worksheets, where the worksheets can be specified via their indices or names. It has exposed another useful property for the LoadDataOptions class which allows to load only the visible worksheets from an existing spreadsheet, where the hidden worksheets will be simply ignored and will not be available in the Aspose.Cells object model for any processing. The newly exposed property is of type Boolean; setting it to true means that the API will ignore the hidden worksheets and load only the visible worksheets for further processing. It has exposed a method that can be used to create an object of the Style class that corresponds to one of the built-in styles offered by the Excel application. The Workbook.createBuiltinStyle method accepts a constant from the enumeration BuiltinStyleType. Please note, with previous releases of the Aspose.Cells APIs, same task could be accomplished via StyleCollection.createBuiltinStyle method but as the recent releases of Aspose.Cells APIs have removed the class from the public API therefore the newly exposed Workbook.createBuiltinStyle method can be considered as an alternative approach to achieve the same goal. This release includes several enhanced features and bug fixes as listed below
• How to create BuiltinStyleType with Workbook.Styles being obsoleted
• Failure in processing upper-case image source tag when converting from HTML to Excel
• Hidden cell is wrongly displayed in output HTML
• Repeat All Item Labels option is not working for the PivotTable
• Text in the Text Box is getting cut-off while rendering the spreadsheet to PDF
• Extra column in the HTML output of Excel document
• Cells.importCSV() not using existing cells' formatting
• API returns #DIV/0! where Excel calculates the value correctly
• Calculated formula values do not match with Excel
• Issue with Cells.inserRange() method which is not inserting range fine
• Formula calculation unexpectedly produces #NAME?
• XLS to PDF Conversion - Font and Font Size are not correctly converted
• DataBar to Image: Right borders are not rendered
• Legends of the graph are formatted with different colors
• Long hyphens don't display appropriately in the output PDF/Image for the chart
• Wrong Chart-Area appears in chart's PDF
• Wrong border color in Chart's PDF using Chart.toPdf
• Small white line appears when generating Chart's PDF with Chart.toPdf
• Vertical rule appears behind other graphics in Chart's PDF using Chart.toPdf
• Wrong X-axis labels appear in Chart's PDF using Chart.toPdf
• X axis scale interval has changed in Chart's PDF while using Chart.toPdf
• Extra label and rule is added on Y-axis and labels of X-axis are lost in Chart's PDF while using Chart.toPdf
• Xaxis line rendered in front of chart content in Chart's PDF while using Chart.toPdf
• All x-axis labels missing in Chart's PDF while using Chart.toPdf
• Legend icon in chart is smaller while rendering spreadsheet to PDF
• Trendline in chart is shorter while rendering spreadsheet to PDF
• Horizontal Grid-Lines of chart are not appearing properly in PDF
• Legend is getting trimmed in chart while converting Chart to PDF
• One image is missing and one is incorrectly rotated in the rendered PDF - Excel to PDF Conversion
• Format of the Chart Data Labels has changed while rendering to PDF
• Unable to change the one of the Data Label's text
• Legend is getting trimmed in chart while converting spreadsheet to PDF
• Axis title has been displaced in chart while converting spreadsheet to PDF
• Hidden formula has been rendered in chart while converting spreadsheet to PDF
Other most recent bug fixes are also included in this release
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: http://www.aspose.com/java/excel-component.aspx
- Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx
- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories