Home Forums WinForms controls Xceed Grid for WinForms C# – Formating numeric cells to "###,###.##"

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • User (Old forums)
    Member
    Post count: 23064
    #13484 |

    How can I format the cells of an specific column to have the following format: “###,###.##” ?

    Imported from legacy forums. Posted by EFileTahi-A (had 695 views)

    User (Old forums)
    Member
    Post count: 23064

    Xceed.Grid.Column myColumn = myGrid.Columns[“myColumn”];
    myColumn.DataProvider = System.Globalization.CultureInfo.CurrentCulture.NumberFormat;
    myColumn.DataSpecifier = “###,###.##”;

    Imported from legacy forums. Posted by Tommy (had 183 views)

    User (Old forums)
    Member
    Post count: 23064

    Tks once more Tommy…

    Unfortunately it works badly, I mean, with “###.###,##” mask I get not format at all, but, if I change the “,” and “.” it formats like this: “###.###.###”, I never have the 2 digit decimal yet, I do not even get the “,”…

    Hope to hear from you soon

    Imported from legacy forums. Posted by EFileTahi-A (had 407 views)

    User (Old forums)
    Member
    Post count: 23064

    I mean if I sawnp the “,” and “.” I get ###.###.### format with no 2 decimal case and it just ignores the use of the “,”

    Damn, is there away to edit the posts?

    Imported from legacy forums. Posted by EFileTahi-A (had 380 views)

    User (Old forums)
    Member
    Post count: 23064

    If you always want the decimals (even if the numbers don’t have decimals), use “###,##0.00”, which will always show the decimals.

    Imported from legacy forums. Posted by Tommy (had 182 views)

    User (Old forums)
    Member
    Post count: 23064

    Great! That works perfectly! 🙂 I hope you can post in my other thread too…

    Imported from legacy forums. Posted by EFileTahi-A (had 4981 views)

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.