Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android Apps

LANE COVE, Australia - Jan. 28, 2019 - PRLog -- What's new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.12. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in "pt" which works in many cases. However there can be case where this fixed size may not be required. For example if container panel width is 600px where this HTML page is being displayed. In this case users may get horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation. Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self-closing tags were not supported however now this support is provided. Now users can load any HTML with self-closing tags and convert it to Excel file. Named regions can have English formulae and this file can be used in environments where systems are configured to German Locale. There is need to translate these English formulae completely to German language for correct usage in Excel configured for German language. This feature is fully functional and can be used without any extra coding. Excel provides custom filters like filter rows which begins with and ends with some specific string.  Aspose.Cells provides rich features to manage shapes in the spreadsheet. Sometimes there is needed to get the connection points of a shape for aligning or placing the shapes at appropriate place. For this purpose all the connection points are required. Pivot tables are very common reports which are present in the workbooks. These reports are updated time by time and it is important to know the last time when report was updated for better decision making. Aspose.Cells has provided this feature by introducing property RefreshDate. Similarly name of the person who updated the pivot table is also provided as property RefreshedByWho.  Smart art is used for better representation of information however earlier the text in the smart art shapes was fixed. This limitation is gone now as now smart art text can be updated. For this purpose shape.setText() function is introduced which sets new text in the smart art shape. Data validation is done in variety of ways to control the input in the Excel file. Like limit can be defined for a cell within which some number can be entered, otherwise error message is raised. Issues were faced for validation of large numbers like 12345678901 etc. in the past but now this much large numbers are supported by Aspose.Cells. Aspose.Cells has introduced rendering active worksheet in a workbook to SVG.  This release includes plenty of improved features and bug fixes as listed below

·         Change returned value for getting Connection points
·         Provide ability to export range as HTML
·         Data bars are missing when XLSX is converted to HTML
·         Value still exists when XLSX is converted to HTML
·         Convert left right ribbon shape to image
·         Wrong count of validation values is read from XLSX
·         Issue while treating consecutive delimiters as distinct
·         Date format is incorrect for Japanese locale
·         LightCells API fails to load huge file
·         An exception(StackOverFlow) raises when saving to PDF output
·         Wrong value calculated by ROUNDUP()
·         Copy a range with PasteType.ALL (Paste options) not copying row heights properly
·         Hyperlink text formatting lost when new text is set
·         Invalid Russian date format output
·         Issue with SheetRender fonts
·         Performance degradation when using conditional formatting
·         Chart line is missing in XLSX->PNG conversion
·         Problem with getActualChartSize method
·         SmartArt doesn't copy when workbook is copied
·         Text formatting is missing in HTML output of excel range
·         Icon Sets become misaligned when XLSX is converted to HTML

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.

 -  Recognize self-closing tags: https://docs.aspose.com/display/cellsjava/Recognise+self+closing+tags

 -  Get Connection points from shape: https://docs.aspose.com/display/cellsjava/Get+Connection+points+from+shape

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: https://products.aspose.com/cells/android-java

-  Download Aspose.Cells for Android:  http://downloads.aspose.com/cells/android

- Online documentation of Aspose.Cells for Android: www.aspose.com/docs/display/cellsandroid/Home

Contact Information

Aspose Pty Ltd,

Suite 163, 79 Longueville Road

Lane Cove, NSW, 2066

Australia

http://www.aspose.com/

sales@aspose.com

Phone: 888.277.6734

Fax: 866.810.9465