[Qgis-user] Decimal delimiter different in label and attribute table

[Frank Broniewski]

Hello Michaela,

Geopackage always stores numbers with "." as decimal separator. The table view just shows a localized view of it. If you enter numbers with a comma, they get internally replaced with a point before storing the values in the geopackage.
But you can format the label and force the german number format with the following expression as an example:

 format_number( "flaeche", 2, 'de')

If you use the expression dialog window, you can use the built in help for more information about the format_number function.


HTH
Frank
________________________________
Von: QGIS-User <qgis-user-bounces at lists.osgeo.org> im Auftrag von Huesmann, Michaela via QGIS-User <qgis-user at lists.osgeo.org>
Gesendet: Donnerstag, 11. Januar 2024 15:13
An: qgis-user at lists.osgeo.org <qgis-user at lists.osgeo.org>
Betreff: [Qgis-user] Decimal delimiter different in label and attribute table


Hello all,

I created a geopackage layer with a column of fieldtype „Decimal (Double)“. In the Attribute Table I can see the decimal delimiter as comma as I want it in Germany. But the labels display the delimiter as point. Where do I change the delimiter for labels?



[cid:image001.png at 01DA44A0.677C0C90]



Best regards,

Michaela



[Kreisstadt Steinfurt]<http://www.steinfurt.de>

 - 48565 Steinfurt
www.steinfurt.de<http://www.steinfurt.de>

Mit freundlichen Grüßen
im Auftrag
Michaela Huesmann
IT
Fachdienst Tiefbau

Tel.: +49 2552 925 219
Fax:
E-Mail: michaela.huesmann at Stadt-Steinfurt.de<mailto:michaela.huesmann at Stadt-Steinfurt.de>

Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240111/7f5ddaf1/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 44449 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240111/7f5ddaf1/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagea797d5.JPG
Type: image/jpeg
Size: 10418 bytes
Desc: imagea797d5.JPG
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240111/7f5ddaf1/attachment-0001.jpe>