Specifying Formula Fields while Importing Data to Worksheet & Controling External Resources using Java

Aspose's picture
Printer-friendly versionPrinter-friendly version

It enables Java developers to Set Margins of Comment or Shape inside a Worksheet. Users can specify formula fields when importing 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. It provides a new property that can be used to specify the maximum rows of the shared formula. This release allows users to filter defined names while loading Workbook.


Lane Cove, NSW, 2066 Australia, March 4, 2018 - (PressReleasePoint) -

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

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

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

Contact Information

Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Australia
Aspose - The .NET and Java component publisher
sales@aspose.com
Phone: 888.277 6734
Fax: 866.810 9465


Press Contact:
David
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Australia
888.277.6734
*********.*****@*s**s*.com
Email partially hidden to block spam. Please use the contact form here.
Contact David
Email the contact person for this press release. Do not send spam or irrelevant message.
2 + 4 =


Copy this html code to your website/blog to embed this press release.

Comments

Post new comment

10 + 10 =

To prevent automated spam submissions leave this field empty.