Page 1 of 1

How can I do to display numbers in the format 1.234,56 ?

Posted: 2015-01-13 23:05
by facos79
Normally the decimal numbers are displayed in the format 1,234.56 where the decimal separator is the point.
How can I do to display numbers in the format 1.234,56 ?

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2015-01-16 08:42
by a.gneady
I plan to post a tutorial on this soon. Stay tuned :)

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-08-22 14:20
by facos79
HI,
Is there any news about the decimal point position?

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-08-24 22:00
by a.gneady
I guess I didn't update my reply here for so many years, but you can specify this format in AppGini under the 'Data format' tab, select the option highlighted below from the drop-down. The field data type should of course be float, double or decimal in order for this to work.

Screenshot 2023-08-25 005406.png
Screenshot 2023-08-25 005406.png (316.31 KiB) Viewed 5645 times

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-08-29 08:02
by facos79
thanks for the reply, great. I tried. :)
But I have the problem of the cells with the automatic calculation. There I can not set the 'data format'. How should I do to display them in the same way?

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-09-03 14:59
by pbottcher

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-09-29 11:19
by facos79
Thanks for your help. You are always very kind and helpful.
I tried with SELECT FORMAT (myNumber, decimals, 'it_IT') inserted directly into the automatic calculation field. It works and the correct format number is shown. But then the total sum of the column goes wrong. As if rounding down but taking more than necessary.
Has anyone solved it?

***In italiano***
Grazie per l'aiuto. Sei sempre gentilissimo e disponibile.
Ho provato con SELECT FORMAT (myNumber, decimals, 'it_IT') inserito direttamente nel campo del calcolo automatico. Funziona e viene mostrato il numero del formato corretto. Però poi mi sballa la somma totale dela colonna. Come se arrotondasse per difetto tohliendo però più del necessario.
Qualcuno ha risolto?

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-10-01 19:00
by pbottcher
Hi ,

which version of AppGini are you using? I think the newer versions allow using the Data format with calculated fields.

Re: How can I do to display numbers in the format 1.234,56 ?

Posted: 2023-10-02 15:40
by facos79
I use the 23.15 revision 1484
It won't let me save the format in calculated cells