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

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

  • 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.
  • Most formats work for any locale.
    Dates work fine already.
    It is only the punctuation for numbers you have to address we think.
  • You can try this beta build of 4.2 and let me know if it formats correctly.
  • We get 4 decimals with this formatting: #.##0,00
    OInumber = 1234.56
    Output in reporttable shows 1.234.5600
    expected output = 1.234,56
  • 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
  • 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.
  • Yes, then it works. Thanks
Sign In or Register to comment.