Specify Formula Fields while Importing Data to Worksheet & Control External Resources using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.2.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. Aspose.Cells allows users to set the margins of any shape or comment using the Shape.TextBody.TextAlignment property. This property returns the object of ShapeTextAlignment class which has different properties e.g. TopMarginPt, LeftMarginPt, BottomMarginPt, RightMarginPt etc. that can be used to set the top, left, bottom and right margins. The code loads the sample Excel file and accesses its shapes one by one and sets their top, left, bottom and right margins. Users can specify formula fields when import data into their worksheet using the ImportTableOptions.setFormulas() method. This method takes the Boolean array where the value true means the field is a formula field. For example, if the third field is a formula field, then third value in the array will be true. For more detail, please see the following article. Aspose.Cells provides the Workbook.Settings.MaxRowsOfSharedFormula property that can be used to specify the maximum rows of the shared formula. The shared formula will be split to several shared formulas if the total rows of shared formula is greater than it. Sometime, user's Excel file contains external resources e.g. linked images etc. Aspose.Cells allows users to control these external resources using Workbook.Settings.StreamProvider which takes the implementation of IStreamProvider interface. Whenever users will try to render a worksheet containing external resources e.g. linked images, the methods of IStreamProvider interface will be invoked which will enable users to take appropriate actions for external resources. It allows users to filter or remove defined names present inside the workbook. Please use LoadDataFilterOptions.DEFINED_NAMES to load defined names and use ~LoadDataFilterOptions.DEFINED_NAMES to remove them while loading the workbook. Please note, if users will remove defined names, then formulas inside the workbook may break up. Below are some important new features, enhancement and bug fixes part of this release.

• Add LoadDataFilterOptions.NAMES constant to filter defined names when loading workbook
• Observe very slow filtering in Microsoft Excel 2013 and 2016 when filter is applied
• Sheet1 shapes are lost and Stars in Sheet2 are rounded
• Invalid encoding - Exception occurs on loading the Excel file
• Macro and Dialog sheets are detected as regular worksheets
• MS Excel does not allow to save XLS file again
• Aspose.Cells is not filtering data correctly instead it hides all the rows

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/products/cells/java

- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.