Hi,
I'm creating an application that have a grid which user can change the cell format similar to Excel.
The only issue is, if a cell's CellValueType is set to Double, whenever user apply customize format (i.e "mm:ss"), the cell text will display the format text itself. This is undesirable.
i.e:
CellValueType = typeof(Double)
CellText = 101
Format = "mm:ss"
Displayed Text = mm:ss
In Excel, the cell value is converted to a DateTime value and then applies the format. Is there a way I can achieve this? or Is there a way I can block applying the format so that it won't display the format text itself?
Attached is the sample showing this issue.
Please help.
Thanks,
Jamilah Abdul Rashid
FormatCell.zip