Page 1 of 1
Column sum wrong number format in table view
Posted: 2023-02-10 13:23
by csultan
Hi, I have an Integer field and checked Show column sum. The number format is "Points for thousands and comma for decimals, NO decimals (exemple: 21.345), it shows Ok on every row but the column sum missing some zeros. Do you have any ideea what the problem could be?
Re: Column sum wrong number format in table view
Posted: 2023-02-10 16:25
by Richard 500
Just a thought but if the data type is set to integer I do not think it will display anything but a whole number. Could be wrong just a quick thought...
Re: Column sum wrong number format in table view
Posted: 2023-02-12 13:43
by pbottcher
Hi,
you can set
Code: Select all
<script>
AppGini.noLocaleFormatting=true;
</script>
in the hooks/footer-extras.php
this will prevent changing the sum field.
Re: Column sum wrong number format in table view
Posted: 2023-02-12 19:29
by csultan
Great! It's Ok now. Thank you, Pascal!
Re: Column sum wrong number format in table view
Posted: 2023-10-15 13:43
by facos79
Do you know if the bug will be fixed in a future release? Because I have the same problem. I'm making an application that should use the Italian number format with a comma before decimals and a period for thousands. However, I cannot use this format because the summation does not display the totals correctly. If I use the code
Code: Select all
<script>
AppGini.noLocaleFormatting=true;
</script>
everything works normally but all the numbers remain in the default format with the period before the decimals.
It's a nuisance because Italian customers are naturally not used to using the period and this creates confusion.
Re: Column sum wrong number format in table view
Posted: 2023-10-16 19:38
by jfischer
Hello
It goes under Data Format. Select the format as shown in the picture. If it is not available, you can find it under C:/programme (x86)/appgini/add-ons/dataFormats.cfg
create.
Best regards
- tausendertrennzeichen.jpg (99.72 KiB) Viewed 4130 times
Re: Column sum wrong number format in table view
Posted: 2023-10-16 21:58
by facos79
Hi, thanks for the reply. I select the format in the section you indicated. The numbers in the column are displayed correctly but those in the row where the sum is indicated are displayed incorrectly as indicated by Csultan in the post.
I have to insert the code in the hooks/footer-extras.php file so that the values in the sum line are displayed correctly but, by doing so, unfortunately the number format is no longer the one we use in Italy.
Thanks again