How do I force a cell format to text?

[Marc]

I write content to a cell that is by default interpreted as a date.
But I want it treated as plain text.
How do I do this? The CellValueFormat constructor wants a format string; but there is no format string for this case.

[Anna]

Hi Marc,

The format string which will help the value be interpreted as text is "@", as it is used in the following snippet:

CellSelection selection = this.radSpreadsheet.ActiveWorksheet.Cells[0, 0];

selection.SetFormat(new CellValueFormat("@"));
selection.SetValue("1/1/2013");

The reason why the format is applied before the value is set is that if you do it the other way around, you will get the numeric value of the date (41276), instead of the string you entered (1/1/2013), which is consistent with the behavior of Excel.

Regards,
Anna
Telerik

 

 

[Marc]

Hi Anna,

Thank you. This is indeed working. I had it the wrong way around (formatting after setting value).

Cheers
Marc