This is a migrated thread and some comments may be shown as answers.

[Solved] Data formatting on calculated column

1 Answer 224 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jay
Top achievements
Rank 1
Jay asked on 10 Nov 2009, 04:49 PM
The data format string on my calculated columns is not functioning. I've tried a variety of different format strings, including the same dataformatstring I use on the data bound columns, "{0:N0}", but on the calculated column ( a simple ratio of two of the data bound values) the grid displays all the decimals.

Any special trick for assigning a data format to a calculated column?

1 Answer, 1 is accepted

Sort by
0
Jay
Top achievements
Rank 1
answered on 10 Nov 2009, 08:54 PM
Never mind, I found the issue. The default data type on the claclulated columns is string. When I changed it to single the formats worked fine.
Tags
Grid
Asked by
Jay
Top achievements
Rank 1
Answers by
Jay
Top achievements
Rank 1
Share this question
or