We are pleased to announce our next version of Aspose.Cells for .NET v8.8.0. This release contains some valuable features along with critical bug fixes and other enhancements. Please see the release notes in order to get an idea of what is new and what has been fixed with this version of Aspose.Cells for .NET. If you are planning to upgrade the Aspose.Cells for .NET API to the latest revision, we would strongly suggest you to check the complete Public API Changes section to know what APIs are changed so far. We have highlighted some important features and other enhancements here.
Control the Conversion of Large Numeric Value to Exponential Notation
As per default behavior, 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 the past, we could use 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 column 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 a 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.
Here is the 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.
Delete Redundant Spaces in Excel to HTML
Aspose.Cells for .NET 8.8.0 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 is false, which means, all the redundant spaces are preserved in the resultant spreadsheet.
Detect if Cell Value Starts with Single Quote
Aspose.Cells for .NET 8.8.0 has exposed the Style.QuotePrefix property to detect if the cell value starts with a single quote mark. With previous versions of Aspose.Cells APIs, it was not possible to distinguish between the text values, such as sample and ‘sample.
Here is the simple usage scenario of Style.QuotePrefix property to find if the cell value starts with a single quote mark.
Other Enhancements and Fixes
The most notable other enhancements in this release are as follows:
- Ability to use image markers while grouping data in smart markers.
- Ability to find Query Tables and List Objects related to external data connections.
- The improved PDF rendering engine for chart objects.
We have also handled a few exceptions regarding reading/writing MS Excel files, rendering Excel files to PDF and refreshing Pivot Tables.
In this release, several important issues have been addressed. For example, issues around manipulating Microsoft Excel file formats, importing and converting HTML files, manipulating and rendering shapes, rendering images from Excel worksheets, manipulating charts, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The Aspose.Cells formula calculation engine is also enhanced in this release.
Moreover, in the new release, we have added session timeout alert in the web-based grid control provided by Aspose.Cells for .NET. We also fixed a few issues regarding data validations and GridWeb’s context menu.
To see a complete list of enhancements and fixes, and to download Aspose.Cells for .NET 8.8.0, please visit the download page.