• 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

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

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 8.7.1 has been released. 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
- 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
- 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
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic