• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

Configure Font Sources for Rendering Spreadsheets & Recursive Formulas Calculation in Android

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 9.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. 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
- Character spacing and break not correct for vertical text while rendering spreadsheet to PDF
- Column widths are different on CentOS than on Windows
- Chart scale has shifted while rendering spreadsheet to PDF
- Alignment problem when rendering an Excel file to PDF
- Formatting of legend entries is disturbed while rendering spreadsheet to PDF
- Horizontal axis labels have not been rendered completely, that is; all labels are missing some contents in the rendered image.
- File is corrupted after formula calculation and save
- Calculation result is not correct
- Array formula is not being calculated properly
- Some values from the Excel file are missing in the output HTML - XLS to HTML conversion
- Cell shading is missing while converting HTML to XLSX
- Workbook to HTML show '#' in cells
- Missing borders, cell shading and images - HTML to Excel rendering
- Cells missing in PDF when multiple print-areas defined in a single sheet
- Right side legend is truncating in the chart image
- Text misplaced at diagram after converted to HTML format
- Chart is changed while converting spreadsheet to HTML
- Incorrect position of vertical line in Chart's PDF
- Autofit does not consider indent level
- Changing the text of an existing WordArt in an Excel file

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 Android documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Configuring Fonts for Rendering Spreadsheets
- Get or Set the Class Identifier of the Embedded OLE Object

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
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
It's fun to be me, and still legal in 9 states! Wanna see my tiny ad?
SKIP - a book about connecting industrious people with elderly land owners
    Bookmark Topic Watch Topic
  • New Topic