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

2024-11-02 03:24:38 Computer

793

We are pleased to announce the new release of Aspose.Cells for Java 8.7.1. This months 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 Excels 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

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Java Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

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