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

[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 ?

[a.gneady]

I plan to post a tutorial on this soon. Stay tuned

[facos79]

HI,
Is there any news about the decimal point position?

[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 (316.31 KiB) Viewed 5626 times

[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?

[pbottcher]

Hi,

maybe this help:
viewtopic.php?f=11&t=4510&p=18281&hilit ... lds#p18281

[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?

[pbottcher]

Hi ,

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

[facos79]

I use the 23.15 revision 1484
It won't let me save the format in calculated cells