Follow on Google News News By Tag Industry News News By Place Country(s) Industry News
Follow on Google News |  Search Cells Based on Original Values & Implement Custom Calculation Engine in Android AppsIt enables Android developers to add custom XML parts to spreadsheets, search cells based on original values & implement custom calculation engine inside Android Apps. It also control conversion of large numeric value to exponential notification
By: Aspose Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.8.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 APIs have powerful calculation engine that can calculate almost all of the Microsoft Excel functions with precision. However, sometimes the application requirement demands to override any Excel formula in order to get desired results, such as return 3 for function =SUM(1,1), which isn't possible with default Aspose.Cells calculation engine. The recent revision of Aspose.Cells for Android allows to extend the default calculation engine to get desired results. By implementing custom calculation engine, users can override all Excel's native functions with more flexibility. Aspose.Cells APIs already support the Find or Search Data feature for spreadsheets in order to find some particular piece of contents in cell value & formula. However, this feature was lacking the aspect of formatting applied onto the cell that may change the appearance as well as the value of the cell, consequently making the content unsearchable using the original value. It has been exposed an constant to the public API which allows to overcome the situation as discussed above. As per default behaviour, if a numeric value is larger than the threshold, the API converts such values to exponential notation while importing HTML segment/files to Aspose.Cells object model. In past, we could use the property to control the conversion of textual values to numeric data, however, this approach has its own drawbacks. For instance, if there are more than one columns containing the numeric values, setting the HTMLLoadOptions.ConvertNumericData property to false will direct the Aspose.Cells APIs to keep all values in textual format. In such case, all formatting from the numeric values will be lost. In order to handle the situations where users wish to retain the format of all numeric values as well as keep the data in its original state, the Aspose.Cells for Android 8.8.0 has exposed the HTMLLoadOptions.KeepPrecision property. The Boolean type property allows to control the conversion of large numeric values to exponential notation. When set to true, the numeric values larger than 15 digits will be imported as it is. Custom XML parts are the XML based data files stored by different applications like SharePoint inside the spreadsheet files. This data is consumed by different applications, however, Microsoft Excel application does not make use of this data so there is no GUI to add such data in the spreadsheets. One can view this data by extracting the contents of the spreadsheet (XLSX) using applications such as WinRar, and inspect the contents of the customXml folder. It has exposed the Style.QuotePrefix property to detect if the cell value starts with single quote mark. With previous revisions of Aspose.Cells APIs, it was not possible to distinguish between the text values such as sample and 'sample. Aspose.Cells for Android has exposed the HTMLLoadOptions.DeleteRedundantSpaces property to control the preservation of redundant spaces after the line break tag (<BR> tag) in HTML. If the aforementioned property is set to true the API will delete all the redundant spaces while importing the HTML in Aspose.Cells object mode. This release includes plenty of improved features and bug fixes as listed below · Support to calculate FORMULATEXT function · HYPERLINK formula/ function - Extend the Worksheet's Hyperlink collection to get the object · Image Markers are not supported while Grouping Data in Smart Markers · Extra columns are added in the output HTML file · Columns get missing from HTML output · Saving image in SVG while converting spreadsheet to HTML results in incorrect image file extension · Incorrect rendering of text in a shape while converting spreadsheet to HTML · Infinite loop issue when save to HTML · Cell.getStringValue for DateTime type is giving undesired value · Chart header extends beyond the chart's border while using Chart.toImage · Data Labels are overlapping with Chart Area in Chart's Image format · Data Labels are overlapping with Chart Area in Chart's PDF file format Other most recent bug fixes are also included in this release. Newly added documentation pages and articles - Using Custom Xml Parts in Aspose.Cells: - Search Data using Original Values: http://www.aspose.com/ 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/ - Download Aspose.Cells for Android: http://www.aspose.com/ 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 End
|
| ||||||||||||||||||||||||||||||||||||||||||||||||
Account Phone Number