Hello,
I have been using Aspose.Cells 4.4 for .NET and have found a bug when using the ConvertStringToNumericValue method on Worksheet.Cells. If a cell contains a single period ("."), the ConvertStringToNumericValue throws a System.Format exception becasue it is trying to convert that cell to a double.
Here is the source code that I was using to test this (nothing special here):
License license = new License();
license.SetLicense("Aspose.Total.lic");
Workbook workbook = new Workbook();
workbook.Open("Data.xls");
workbook.Worksheets[0].Cells.ConvertStringToNumericValue();
workbook.Save("ProcessedData.xls");
I have the Excel file that I have attempted to use the ConvertStringToNumericValue method against. You will notice that under column B, there is a cell containing a single period. This is what causes the exception.
This exception seems to happen for both the .NET 1.1 and 2.0 version of Aspose.Cells. It seems to me that the ConvertStringToNumericValue method should be catching and handling this exception so that the rest of the file can be processed. If you are able to reproduce this, when do you expect to have this bug fixed?
Thanks,
Kyle