Specify Formula Fields while Importing Data to Worksheet & Control External Resources
What is new in this release?
The long awaited version of Aspose.Cells for Java 16.2.0 has been released. 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
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.
- Set Margins of Comment or Shape inside the Worksheet
- Specify Maximum Rows of Shared Formula
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
Australia
Aspose - The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465
