Control Conversion of Large Numeric Value to Exponential Notation in Spreadsheets using .NET

2024-11-02 11:23:01 Computer

902

We are pleased to announce the new release of Aspose.Cells for .NET 8.8.0. This release contains some valuable features along with critical bug fixes and other enhancements. 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 HTMLLoadOptions.ConvertNumericData 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 .NET 8.8.0 has exposed the HTMLLoadOptions.KeepPrecision property. The Boolean property allows controlling 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. A simple usage scenario demonstrating the usage of HTMLLoadOptions.KeepPrecision property to avoid the conversion of large numbers to exponential notation while importing data from Html is provided on blog announcement page. It 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. The HTMLLoadOptions.DeleteRedundantSpaces property has the default value as false, that means, all the redundant spaces are preserved in the resultant spreadsheet. The most notable other enhancements in this release includes, Ability to use image markers while grouping data in smart markers, ability to find Query Tables and List Objects related to external data connections and improved PDF rendering engine for chart objects. This release includes several enhanced features and bug fixes as listed below

Provide the ability to prohibit the conversion of long numeric values to exponential notation while importing from HTML
Detecting leading single quote mark in the cell
Get target or output cell address for an ExternalConnection
Support for localization (German) of client side validation
Formula for WordArt does not react to argument change while converting XLS to XLSB
Process seems to hang with 100% CPU usage for converting single page spreadsheet to PDF
XLSM becomes corrupted after re-populating the data and refreshing the Pivot Table
Line breaks are lost while importing HTML and exporting to spreadsheet
Borders are lost while importing HTML and exporting to spreadsheet
Sample1.xlsx is getting corrupted after getting opened and refreshed
Incorrect encoding with the target (CSV) file
Million number formatting issue while converting Excel to PDF
API renders two PDF pages for one worksheet regardless of setting OnePagePerSheet to true
Text is getting trimmed while rendering spreadsheet
Chart is not generated correctly in the output Excel file
Alignment issue with bulleted list (shape) in the rendered image
Style of the bulleted list (shape) is different in the output image
Part of X-axis labels is getting rendered in horizontal orientation while converting chart to image
Excel file with embedded documents gets corrupt on saving
#Ref! after copying cells containing references to named cells from one workbook to another
Removing the password from a protected spreadsheet changes the embedded object name
Number gets rounded off when converting HTML to spreadsheet format
Bug We have also handled a few exceptions regarding reading/writing MS Excel files, rendering Excel files to PDF and refreshing Pivot Tables.
Add session timeout alert for GridWeb
500 Internal Error: "Error in Cell: Invalid Formula" by inserting invalid formula in GridWeb UI
Clicking on a cell changes the formatted text to its HTML source
GridWeb changes content of data validation List/dropdown
Context menu grows up when rows or columns are added through it
Adding rows and columns through context menu is not working

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 .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Avoid exponential notation of large numbers while importing from Html: http://www.aspose.com/docs/display/cellsnet/Avoid+exponential+notation+of+large+numbers+while+importing+from+Html

- Find if the cell value starts with single quote mark: http://www.aspose.com/docs/display/cellsnet/Find+if+the+cell+value+starts+with+single+quote+mark

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET: http://www.aspose.com/.net/excel-component.aspx

- Download Aspose.Cells for .NET: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home

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

- Post your technical questions/queries to Aspose.Cells for .NET 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 .NET 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