›
Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Number formatting

keemankeeman
in SRP ReportTable Control
Hi,
In SRP reporttable we want to display valuta in a column and also make it sortable . For US we can use #,##0.00 for format and the valuta are displayed US-style. In The Netherlands we should use #.##,00 In excel this works fine but in the srp edittable 1234.56 gets formatted as 1,234.5600. We think the srp edittable ignores the windows country/region settings?
What can we do to correct this?

Regards Ed Keeman

Comments

  • KevinFournierKevinFournier
    You're right, that is currently not supported. I'll make this a high priority item as it's a long overdue oversight that should be remedied as soon as possible. Give me some time, though, as adding locale support to all formatting options is a lot.
  • keemankeeman
    Most formats work for any locale.
    Dates work fine already.
    It is only the punctuation for numbers you have to address we think.
  • KevinFournierKevinFournier
    You can try this beta build of 4.2 and let me know if it formats correctly.
  • keemankeeman
    We get 4 decimals with this formatting: #.##0,00
    OInumber = 1234.56
    Output in reporttable shows 1.234.5600
    expected output = 1.234,56
  • keemankeeman
    Oops. Typo in previous message, lets try again...
    We get 4 decimals with this formatting: #.##0,00
    OInumber = 1234.56
    Output in reporttable shows 1.234,5600
    expected output = 1.234,56
  • KevinFournierKevinFournier
    The idea was that you only have to set the format once using en-US standards and the controls would automagically localize it for you. Try "#,##0.00" instead and see if that works.

    Also note that if you use $ in your number format (without quotes), it will use the localized currency on final output.
  • keemankeeman
    Yes, then it works. Thanks
Sign In or Register to comment.