Control Conversion of Large Numeric Value to Exponential Notation in Spreadsheets Using Aspose.Cells for .NET 8.8.0
It controls the conversion of large numeric value to exponential notation while importing from HTML. It has exposed a new property to control the preservation of redundant spaces after the line break tag in HTML and detect if cell value starts with single quote mark. It enhanced the ability to use image markers while grouping data in smart markers as well as improved PDF rendering engine for chart objects.
Lane Cove, Australia, May 07, 2016 --(PR.com)-- What is new in this release?
Aspose team is 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, users 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 (<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. 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
• It has 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
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. Users 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. Users 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
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
Aspose team is 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, users 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 (<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. 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
• It has 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
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. Users 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. Users 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
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
Contact
Aspose
Sher Azam
888.277.6734
http://www.aspose.com/
Sher Azam
888.277.6734
http://www.aspose.com/
Contact
Categories