Numbers that are stored as text not converted to number format


#1

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.


#2

Hi,

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


#3

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


#4

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