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

[Solved] Sorting messes up formatting

2 Answers 84 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Andrew Blum
Top achievements
Rank 1
Andrew Blum asked on 16 Sep 2011, 04:34 PM
I have a column which is an integer for which I need to put comma separated formatting in place. (ie.  34555 displays as 34,555).  I added code to format the column as so:

 columns.Bound(o => o.Salary).Format("{0:#,###0}");

This works fine on initial binding .  However, when I click on a sort-able header column the data format changes and appears as:  

3,4,555

I attached a picture to show the post sort behavior.
Notice the two commas, how can I fix this?

Thanks,

Andy
 
          

2 Answers, 1 is accepted

Sort by
0
Andrew Blum
Top achievements
Rank 1
answered on 20 Sep 2011, 06:53 PM
Please Answer!
0
ermi
Top achievements
Rank 1
answered on 02 Nov 2011, 05:21 AM
columns.Bound(o => o.Salary).Format("{0:#,##0}");

I removed one # and it worked for me.
Tags
Grid
Asked by
Andrew Blum
Top achievements
Rank 1
Answers by
Andrew Blum
Top achievements
Rank 1
ermi
Top achievements
Rank 1
Share this question
or