Column sum wrong number format in table view

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
User avatar
csultan
Posts: 9
Joined: 2020-02-09 19:40

Column sum wrong number format in table view

Post by csultan » 2023-02-10 13:23

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
data_format.jpg (75.39 KiB) Viewed 2484 times
column_sum.jpg
column_sum.jpg (26 KiB) Viewed 2484 times

Richard 500
Posts: 6
Joined: 2016-02-01 16:30

Re: Column sum wrong number format in table view

Post by Richard 500 » 2023-02-10 16:25

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... :D

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Column sum wrong number format in table view

Post by pbottcher » 2023-02-12 13:43

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.
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.

User avatar
csultan
Posts: 9
Joined: 2020-02-09 19:40

Re: Column sum wrong number format in table view

Post by csultan » 2023-02-12 19:29

Great! It's Ok now. Thank you, Pascal!

facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

Re: Column sum wrong number format in table view

Post by facos79 » 2023-10-15 13:43

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.

jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Re: Column sum wrong number format in table view

Post by jfischer » 2023-10-16 19:38

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
tausendertrennzeichen.jpg (99.72 KiB) Viewed 1895 times

facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

Re: Column sum wrong number format in table view

Post by facos79 » 2023-10-16 21:58

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

Post Reply