Configure Font Sources for Rendering Spreadsheets & Recursive Formulas Calculation using Aspose.Cells for Android 9.0.0

It provides support configuring fonts for rendering spreadsheets. It also supports recursive calculation of formulas, Set Class Identifier for OleObjects, Control Chart’s Data Source while Copying Rows. It has enhanced support for creating new Excel charts as well manipulating existing ones, hide the legend entry’s text by setting the fill color to none, comments for an Excel Table or ListObject, insert and/or manipulate existing ActiveX controls and many more.

Lane Cove, Australia, October 12, 2016 --( What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v9.0.0. This release includes a number of new features, enhancements and bug fixes that further improve the overall stability and usability of the API. Aspose.Cells for Android API has exposed a number of new classes as well as an enumeration to configure font sources for rendering spreadsheets to image formats and PDF. The most important class is the FontConfigs which has many useful factory methods to either set the font sources or set the font substitution along with some inspection APIs to retrieve the list of specified font sources as well as font substitutions. Aspose.Cells APIs search the operating system’s default font directory for the required fonts. In case the required fonts are not available in the system’s font directory then the APIs search through the custom (user defined) directories. It also provides the ability to set user defined font substitutions for rendering purposes. This mechanism is helpful when a required font is not available on the machine where conversion has to take place. Users can provide a list of font names as alternative to the originally required font. The APIs have also provided means to gather information on what sources and substitutions have been set. It has exposed the Boolean type CalculationOptions.Recursive property. Setting the property to true and passing the object to calculateFormula method directs the Aspose.Cells APIs to calculate the dependent cells recursively when calculating cells which depends on other cells. It has exposed the OleObject.ClassIdentifier property which can be used to retrieve or set the class identifier for an OleObject. Please note, the class identifier decides which application is required to load the embedded resource/OleObject and how. for instance, a PPT (presentation) file can be embedded in a spreadsheet with 2 different views, that is; presentation view or slide view, whereas both views have different class identifier values. It has exposed the Boolean type property along with an overload of Cells.copyRows method in order to facilitate the copy rows operation when rows to be copied also contain a chart and its data source. Users can make use of these new APIs to point the chart’s data source to the source or destination worksheets. It allows get/set the IFilePathProvider for exporting worksheets to separate HTML files. These new APIs are helpful in scenarios where hyperlinks in one worksheet points to a location in another worksheet, where application requirement is to render each worksheet to separate HTML file. Implementing the IFilePathProvider allows to keep the aforementioned hyperlinks intact regardless of the fact that they are pointing to a location in a separate resultant HTML file. Aspose.Cells for Android API has exposed the Shape.TextOptions property which can be used to control all aspects of the shape’s textual contents such as font style, color, font weight and so on. This release includes plenty of improved features and bug fixes as listed below:

• Calculation time has increased with recent API revisions
• User configurable fonts substitution mechanism is required
• Calculation time has increased with recent API revisions
• Ability to detect if a DataPoint is in Pie or Bar
• Workbook.calculateFormula() method never terminates for the source Excel file
• Spreadsheet takes more than 3 minutes to calculate formulas by Workbook.calculateFormula() method
• Unable to catch image resource while rendering spreadsheet to HTML with IStreamProvider
• Problem with rendering checkboxes to HTML
• Issue with getDisplayStringValue() for Date formatted values
• Using Light Cells APIs to process an XLS file, the first cell of the first sheet is always processed

Other most recent bug fixes are also included in this release.

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android:

- Download Aspose.Cells for Android:

- Online documentation of Aspose.Cells for Android:

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465
Sher Azam