PR.com: Business Directory, Press Releases, Jobs, Products, Services, Articles
 
Businesses Articles Press Releases Follow @PRcom
Press Release Pricing | News by Category | News by Country | News by US Region | Recent News | PR.com News on Your Site
 

Press Releases

 
Aspose Pty Ltd

Press Release


Receive press releases from Aspose Pty Ltd: By Email RSS Feeds:

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
Contact Information
Aspose
Sher Azam
888.277.6734
Contact
http://www.aspose.com/

Click here to view the list of recent Press Releases from Aspose Pty Ltd
Promote Your Business