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

2024-11-05 02:20:41 Computer

696

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
? Gantt chart is not rendered in the output PDF file format
? Issue with the returned values of parameters in calculating custom function
? Custom function involving Excel formula (INDIRECT) fails
? Issue with the value received in a CustomFunction
? Issue with RefferedArea as result of parameter's calculation
? When instantiating a Workbook with a corrupted Excel document and LoadOptions, hang occurs
? Problem with AutoFilters on formulas
? Conditional format with number format does not work for XLS
? Style.isDateTime returns false for a cell formatted as Date
? Left border appearing when it shouldn't for a cell that has adjacent hidden column
? Formulas are not updated correctly after insert rows
? Dynamic print area broken when save as / print PDF
? Some Hebrew characters in the textbox missing in the output PDF file
? The value axis and category axis labels in the chart are blacked out (Excel to PDF conversion)
? Text is too large and expanding beyond the margin
? Bold text characters overlap with each other while converting worksheet to image
? The text outside of the page break is rendered in PDF as wrapped text
? Issue with page break, fonts rendering and margins in Excel to PDF rendering
? Aspose.Cells: cut off text in original cell is showed fully when converted to PDF
? Page Layout issue (RTL) rendering
? Footer is mess up in the generated PDF file
? A small dot appears at the center of Pie Chart while saving it to image
? Chart used to be able to accept a series formula with empty values but now it throws exception
? Rendering problems while converting chart to image
? Issue with chart axis labels' width when converting Excel worksheet to image
? Chart Data Label properties issue
? Pie Chart percentage problem

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

- Demos of Aspose.Cells for Android: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Android Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Android blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

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