Control Conversion of Large Numeric Value to Exponential Notation in Spreadsheets Using Aspose.Cells for .NET 8.8.0
Summary
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.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.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 workingOther most recent bug fixes are also included in this releaseOverview: Aspose.Cells for .NETAspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel.