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
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
Dates work fine already.
It is only the punctuation for numbers you have to address we think.
OInumber = 1234.56
Output in reporttable shows 1.234.5600
expected output = 1.234,56
We get 4 decimals with this formatting: #.##0,00
OInumber = 1234.56
Output in reporttable shows 1.234,5600
expected output = 1.234,56
Also note that if you use $ in your number format (without quotes), it will use the localized currency on final output.