Column sum wrong number format in table view
Column sum wrong number format in table view
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?
- Attachments
-
- data_format.jpg (75.39 KiB) Viewed 2491 times
-
- column_sum.jpg (26 KiB) Viewed 2491 times
-
- Posts: 6
- Joined: 2016-02-01 16:30
Re: Column sum wrong number format in table view
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
Hi,
you can set
in the hooks/footer-extras.php
this will prevent changing the sum field.
you can set
Code: Select all
<script>
AppGini.noLocaleFormatting=true;
</script>
this will prevent changing the sum field.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Column sum wrong number format in table view
Great! It's Ok now. Thank you, Pascal!
Re: Column sum wrong number format in table view
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
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.
Code: Select all
<script>
AppGini.noLocaleFormatting=true;
</script>
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
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
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
Re: Column sum wrong number format in table view
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
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