Calculate Page Setup Scaling Factor & Strategize Calculation Precision in Android Apps

LANE COVE, Australia - July 23, 2015 - PRLog -- What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.5.0. This release contains many useful features and improvements. Aspose.Cells uses some third party libraries. For example, there is one thrid-party library which Aspose.Cells uses. That is used for AES encryption supported by MS Excel 2010. Sometimes, when using multiple components in an Android project, you might encounter “Unable to execute DX” error which means the total number of methods in the project should not exceed 65536. Now we put the third party lib(s) to an APK (aspose-cells-x.x.x-libs.apk) file. This way, the methods in the third party lib are not needed to be counted any more. Now we only have our Aspose.Cells lib so, the long list of third party library methods are reduced as these run in the same process of the component’s main jar. It has exposed the CalculationOptions class, CalculationPrecisionStrategy enumeration and a set of new CalculateFormula methods in order to add more flexibility & extensibility to the formula calculation engine. These new APIs were added to facilitate the user who wish to strategize the calculation precision handling on their own according to the application requirements. Aspose.Cells APIs have exposed the PasteType.ROW_HEIGHTS enumeration field for the purpose of copying the row heights while copying the ranges. Upon setting the PasteOptions.PasteType property to PasteType.ROW_HEIGHTS the heights of all the rows inside the source range will be copied to the destination range. Microsoft Excel calculates the page setup scaling factor while using the “Fit to n page(s) wide by m tall” option. Aspose.Cells for Android 8.5.0 has exposed the SheetRender.PageScale property to mimic the aforesaid feature of Excel application. This property returns a double value which can be converted to percentage for scaling notation. With this revision, the API has exposed the Cell.getStringValue method along with an enumeration CellValueFormatStrategy that can be used to extract the cell value with or without formatting applied. The newly exposed Cell.getStringValue() method can be used to get the string value of the cell with or without any formatting. Suppose, you have a cell with value 0.012345 and you have formatted it to display two decimal places only. It will then display as 0.01 in Excel. You can retrieve string values both as 0.01 and as 0.012345 using the Cell.getStringValue() method. Since the code base of Aspose.Cells for Android matches the code of relevant .NET and Java versions, so most of the changes, enhancements and fixes are also included in the release. This release includes plenty of improved features and bug fixes as listed below

·         Enhance the PasteOptions/PasteType mechanism to allow copying of Row heights while copying Ranges

·         Recalculating the Page Setup scaling factor

·         HYPERLINK formula/function - Allow user to process parameters of hyperlink

·         Wrong background color is returned by Aspose.Cells

·         Spreadsheet corrupted after opening and saving the template XLSX file

·         Conversion to HTML appends # string at the end of values for a column

·         Numbers in the Text boxes are not displayed inside

·         The smart arts' placement/alignment in the PDF is not matching with the source Excel file

·         Bottom line is way longer that the original in template file

·         Data shifted to the right in template file

·         Text is overlapped with white background in template file

·         Cell alignment is to left instead of right in template file

·         Text and text alignment is messed up in template file

·         JavaScript error when export to HTML

·         Loss of text in template file

·         Loss of text in template file

·         Failed conversions from XLS to PDF with Aspose.Cells APIs

·         Converting Excel file containing hyperlinks to HTML - Cell referenced hyperlinks don't work

·         Issue with the formatting of an Arrow shape / object - Excel to PDF rendering

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.

 -  Calculate Page Setup Scaling Factor: http://www.aspose.com/docs/display/cellsandroid/Calculate+Page+Setup+Scaling+Factor

 - Get Cell String Value with and without Formatting: http://www.aspose.com/docs/display/cellsandroid/Get+Cell+String+Value+with+and+without+Formatting

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: http://www.aspose.com/android/excel-component.aspx

-  Download Aspose.Cells for Android:  http://www.aspose.com/community/files/74/android-components/aspose.cells-for-android/default.aspx

- 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