Search Cells Based on Original Values & Enhanced Formula Calculation Engine using Java

LANE COVE, Australia - March 14, 2016 - PRLog -- What's new in this release?

We are 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

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.

 -  Find or Search Data: http://www.aspose.com/docs/display/cellsjava/Find+or+Search+Data

 - Reading and Writing Query Table of Worksheet: http://www.aspose.com/docs/display/cellsjava/Reading+and+Writing+Query+Table+of+Worksheet

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