Excel's spooky behaviour (OWC Question)

[pontifikas]

The Main Question
Where Can I find the Class Documentation for OWC(Office Web
Components)?
I want to find how to tell to an Excel column to accept specific data
types of input values.

[b:ffd9a7a328]The Story Behind[/b:ffd9a7a328]
I'm using OWC to extract a DataTable or a C1.FlexGrid to Excel.

When I import the data I know what their data type is. So I use the
appropriate 'Convert.to_" statement.

i.e MyExcel.ActiveSh(i)eet.Cells = Convet.toDouble(dr);
(dr = datarow of the data table)

While the majority of the data gets copied to the Excel correctly(in
the same column), there are some specific inputs whose value change
when extracted to Excel.As a result,
String inputs appears as ... dates. For example "Olympiakos-FC"
becomes
"12/3/3029".

I 've deduced that the specific column tends to accept Date inputs.So
if a string can somehow be translated to date(doono, maybe it makes
it an Int and then cosiders this Int as a day count).

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

 

[Bonj]

Tey setting the NumberFormat property of the cell to "@" before you set the
data.

 

[pontifikas]

nope! That didnt work :?

BTW, what does the '@' infront of a variable implies??(yes I'm new to
C#)

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*