Numbers that are stored as text not converted to number format


I’m importing an Array of objects. The objects are strings, but may be either numbers, text, dates, times, datetimes stored as text.

Even though sheet.Cells.IsStringsPreserved = False the numbers show up with a warning “Number stored as text” on both Excel 2002 and Excel 2003. Formatting the cell in the template (designer) does not affect the end result.



You have to convert text to number or datetimes before importing them. If not, Aspose.Excel saves them as strings.


OK. Can you clarify the purpose of IsStringsPreserved in the documention? What exactly happens (and when) if it is True?


If IsStringPreserved is set to true, all values(number, date) are converted to string. Some users aked for this before.