Search Cells Based on Original Values & Implement Custom Calculation Engine in Android Apps

2024-11-02 09:17:56 Computer

845

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 (
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. Aspose.Cells APIs have enhanced the formula calculation engine with this release where the most worth mentioning enhancements are Support for Array Formulas of Data Tables and Support for FORMULATEXT Function. 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
? Bottom and right borders are missing in Chart's PDF file format
? Incorrect Colors are rendered in Bar Chart's PDF
? Acrobat Reader shows error while loading Aspose.Cells' generated PDF
? Series is fully opaque in SVG opposed to original chart in spreadsheet
? SVG image is different than original chart in spreadsheet
? DataLabel's picture or texture fill effect hasn't rendered to SVG
? Resultant SVG file is of 0KB in size
? Picture to SVG renders blank/wrong image
? Graphic title is missing in the output PDF
? FileFormatUtil.loadFormatToExtension returns .ODS for .ODP file
? Unreadable content in Excel 2007 after re-saving PerformanceReport.xlsb
? Shape formula does not refresh while saving XLS to XLSB
? cell.getFormula returns the formula with sheet name in square brackets and path to spreadsheet file
? 'Start' property of an ordered list is not working properly
? Aspose Cells API not able to convert each content of HTML file to Excel file
? Layout is different while saving spreadsheet to HTML
? Hyperlink pointing to a defined names results in broken link when spreadsheet is converted to HTML
? Wrong calculation on what-if analysis
? Russian month name renders differently in PDF as compared to Excel
? Cell with currency format in BMD is detected as DateTime
? Locale dependent date format changes to fixed custom format while converting SpreadsheetML to XLSX
? Issue with the output XLSB file - XLS to XLSB Conversion
? Excel conversion to PDF is taking forever
? Axis Label overlap when converting spreadsheet to PDF
? Data Labels are overlapping with the Pie Chart while rendering to PDF
? Upper case horizontal/vertical Axis title text appears in sentence case in Chart's PDF format
? Chart alignment problem while rendering Worksheet to image
? Vertical rule missing in Chart's PDF format
? Thickness of horizontal rules is more than thickness in actual chart while rendering to PDF
? SmartArt does not get copied while copying Workbook
? Vertical alignment of the chart's legend has changed while converting ODS to XLSX
? Chart is missing while converting ODS to XLSX
? Conversion to HTML results in empty page
? Vertical alignment of the text in a TextBox changes from middle to top while rendering spreadsheet to Image & PDF
? Font Substitution Warnings not working while converting spreadsheet to HTML format
? Aspose.Cells does not calculate the value of the cell correctly
? Cell.calculate() method is not calculating the values properly
? Space distortion at the end of second page highlighted as red in sample excel file
? Text misaligned in the output PDF
? Aspose.Cells generated PDF mismatch with Excel generated PDF of same spreadsheet
? Category axis tick labels mismatch in output PDF in Excel to PDF rendering
? Angle of chart-labels has changed in Chart's PDF
? Legend entry is getting trimmed while converting chart to PDF
? Red colored bar is missing in Excel but getting displayed in PDF
? Spreadsheet becomes corrupted after copying the Workbook and setting the DataLabel's position
? Error Bar is missing while copying Workbook
? Text in the TextBox is rendered incomplete while converting worksheet to image
? DataLabels missing for a chart in the output image/PDF for the spreadsheet
? Positive valued bars are appearing below the 0-value x-axis rule in Chart's PDF
? Chart's Legend order is reversed while rendering Worksheet to Image
? Aspose.Cells is breaking the Power Pivot Tables upon opening and re-saving the XLSM file format
? Issue with grouped rows when copying ranges in XLSX file
? Issue with grouped rows when copying ranges in XLS file
? Formula for WordArt does not react to argument change after converting XLS to XLSB
? Conditional formatting range is incorrect and does not match with Microsoft Excel
? Exception: "[0]Sheet1!B2-Invalid formula: More than one token in stack" on Workbook.calculateFormula() method

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.

- Using Custom Xml Parts in Aspose.Cells: http://www.aspose.com/docs/display/cellsandroid/Using+Custom+Xml+Parts+in+Aspose.Cells

- Search Data using Original Values: http://www.aspose.com/docs/display/cellsandroid/Search+Data+using+Original+Values

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