Search Cells Based on Original Values & Enhanced Formula Calculation Engine Using Aspose.Cells for Java 8.7.1
It supports the Find or Search Data feature for spreadsheets in order to find some particular piece of contents in cell value & formula. It also exposed the boolean type properties for accessing query table. Aspose.Cells APIs have enhanced the formula calculation engine with this release. It enhanced the image rendering engine for SVG file format & Chart2Image module to avoid overlapping of chart objects.
Lane Cove, Australia, March 16, 2016 --(PR.com)-- What’s new in this release?
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.7.1. This month’s release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells APIs already support the Find or Search Data feature for spreadsheets in order to find some particular piece of contents in cell value & formula. However, this feature was lacking the aspect of formatting applied onto the cell that may change the appearance as well as the value of the cell, consequently making the content unsearchable using the original value. With this release of Aspose.Cells for Java API, another constant by the name LookInType.ORIGINAL_VALUES has been exposed to the public API which allows to overcome the situation as discussed above. Aspose.Cells for Java 8.7.1 has exposed the boolean type QueryTable.PreserveFormatting & QueryTable.AdjustColumnWidth properties in order to mimic the Excel’s features of preserving cell formatting & adjusting column widths while working with External Data Range of type Query Table. Please note, Excel application provides these options to influence the formatting of the data where the options can be accessed on Excel interface from Data tab by clicking the Properties button. Aspose.Cells APIs have enhanced the formula calculation engine with this release where the most worth mentioning enhancements are Support for Array Formulas of Data Tables, Support for FORMULATEXT Function, Enhanced the image rendering engine for SVG file format, Enhanced Chart2Image module to avoid overlapping of chart objects and Enhanced the HTML rendering engine to handle cases involving missing columns. This release includes several enhanced features and bug fixes as listed below:
• Support to calculate FORMULATEXT function
• Extra columns are added in the output HTML file
• Columns get missing from HTML output
• Saving image in SVG while converting spreadsheet to HTML results in incorrect image file extension
• Incorrect rendering of text in a shape while converting spreadsheet to HTML
• Infinite loop issue when save to HTML
• Cell.getStringValue for DateTime type is giving undesired value
• Chart header extends beyond the chart's border while using Chart.toImage
• Data Labels are overlapping with Chart Area in Chart's Image format
• Data Labels are overlapping with Chart Area in Chart's PDF file format
• Bottom and right borders are missing in Chart's PDF file format
• Incorrect Colors are rendered in Bar Chart's PDF
• Acrobat Reader shows error while loading Aspose.Cells' generated PDF
• Series is fully opaque in SVG opposed to original chart in spreadsheet
• SVG image is different than original chart in spreadsheet
• DataLabel's picture or texture fill effect hasn't rendered to SVG
• Resultant SVG file is of 0KB in size
• Picture to SVG renders blank/wrong image
• Graphic title is missing in the output pdf
• FileFormatUtil.loadFormatToExtension returns .ODS for .ODP file
• Unreadable content in Excel 2007 after re-saving PerformanceReport.xlsb
• Shape formula does not refresh while saving XLS to XLSB
• cell.getFormula returns the formula with sheet name in square brackets and path to spreadsheet file
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
Phone: 888.277.6734
Fax: 866.810.9465
Aspose team is pleased to announce the new release of Aspose.Cells for Java 8.7.1. This month’s release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells APIs already support the Find or Search Data feature for spreadsheets in order to find some particular piece of contents in cell value & formula. However, this feature was lacking the aspect of formatting applied onto the cell that may change the appearance as well as the value of the cell, consequently making the content unsearchable using the original value. With this release of Aspose.Cells for Java API, another constant by the name LookInType.ORIGINAL_VALUES has been exposed to the public API which allows to overcome the situation as discussed above. Aspose.Cells for Java 8.7.1 has exposed the boolean type QueryTable.PreserveFormatting & QueryTable.AdjustColumnWidth properties in order to mimic the Excel’s features of preserving cell formatting & adjusting column widths while working with External Data Range of type Query Table. Please note, Excel application provides these options to influence the formatting of the data where the options can be accessed on Excel interface from Data tab by clicking the Properties button. Aspose.Cells APIs have enhanced the formula calculation engine with this release where the most worth mentioning enhancements are Support for Array Formulas of Data Tables, Support for FORMULATEXT Function, Enhanced the image rendering engine for SVG file format, Enhanced Chart2Image module to avoid overlapping of chart objects and Enhanced the HTML rendering engine to handle cases involving missing columns. This release includes several enhanced features and bug fixes as listed below:
• Support to calculate FORMULATEXT function
• Extra columns are added in the output HTML file
• Columns get missing from HTML output
• Saving image in SVG while converting spreadsheet to HTML results in incorrect image file extension
• Incorrect rendering of text in a shape while converting spreadsheet to HTML
• Infinite loop issue when save to HTML
• Cell.getStringValue for DateTime type is giving undesired value
• Chart header extends beyond the chart's border while using Chart.toImage
• Data Labels are overlapping with Chart Area in Chart's Image format
• Data Labels are overlapping with Chart Area in Chart's PDF file format
• Bottom and right borders are missing in Chart's PDF file format
• Incorrect Colors are rendered in Bar Chart's PDF
• Acrobat Reader shows error while loading Aspose.Cells' generated PDF
• Series is fully opaque in SVG opposed to original chart in spreadsheet
• SVG image is different than original chart in spreadsheet
• DataLabel's picture or texture fill effect hasn't rendered to SVG
• Resultant SVG file is of 0KB in size
• Picture to SVG renders blank/wrong image
• Graphic title is missing in the output pdf
• FileFormatUtil.loadFormatToExtension returns .ODS for .ODP file
• Unreadable content in Excel 2007 after re-saving PerformanceReport.xlsb
• Shape formula does not refresh while saving XLS to XLSB
• cell.getFormula returns the formula with sheet name in square brackets and path to spreadsheet file
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
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