<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Hello Michaela,</div>
<div class="elementToProof" style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
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.</div>
<div class="elementToProof" style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
But you can format the label and force the german number format with the following expression as an example:</div>
<div class="elementToProof" style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"> format_number( "flaeche", 2, 'de')</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">If you use the expression dialog window, you can use the built in help for more information about the format_number function.</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">HTH</span></div>
<div class="elementToProof"><span style="font-family: "Century Gothic", sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">Frank</span></div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Von:</b> QGIS-User <qgis-user-bounces@lists.osgeo.org> im Auftrag von Huesmann, Michaela via QGIS-User <qgis-user@lists.osgeo.org><br>
<b>Gesendet:</b> Donnerstag, 11. Januar 2024 15:13<br>
<b>An:</b> qgis-user@lists.osgeo.org <qgis-user@lists.osgeo.org><br>
<b>Betreff:</b> [Qgis-user] Decimal delimiter different in label and attribute table</font>
<div> </div>
</div>
<style type="text/css">
<!--
p.x_ImprintUniqueID
{margin:0cm 0cm 0pt}
li.x_ImprintUniqueID
{margin:0cm 0cm 0pt}
div.x_ImprintUniqueID
{margin:0cm 0cm 0pt}
table.x_ImprintUniqueIDTable
{margin:0cm 0cm 0pt}
div.x_Section1
{}
-->
</style><style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
span.x_E-MailFormatvorlage17
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:70.85pt 70.85pt 2.0cm 70.85pt}
div.x_WordSection1
{}
-->
</style>
<div lang="DE" link="#0563C1" vlink="#954F72">
<div class="x_WordSection1">
<p class="x_MsoNormal">Hello all,</p>
<p class="x_MsoNormal">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?</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><img width="811" height="338" id="x_Grafik_x0020_1" style="width:8.4479in; height:3.5208in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01DA44A0.677C0C90"></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Best regards,</p>
<p class="x_MsoNormal">Michaela</p>
<p class="x_MsoNormal"> </p>
</div>
<br>
<table class="x_ImprintUniqueIDTable" cellspacing="0" cellpadding="0" border="0" style="height:185px; width:556px; border-collapse:collapse">
<tbody>
<tr>
<td width="175" style="width:260px"><a href="http://www.steinfurt.de" target=""><img width="228" height="98" alt="Kreisstadt Steinfurt" style="border:0px Solid" data-outlook-trace="F:1|T:1" src="cid:imagea797d5.JPG@cff3766f.478e8747"></a><br>
<br>
- <font style="font-family:Arial; font-size:10pt; color:#7D7D7D">48565</font> <font style="font-family:Arial; font-size:10pt; color:#7D7D7D">Steinfurt</font><br>
<font size="2" face="Arial"><span style="color:#7D7D7D; text-decoration:none"><a href="http://www.steinfurt.de" title="" target="" style="color:#7D7D7D; text-decoration:none"><span style="color:#7D7D7D; text-decoration:none">www.steinfurt.de</span></a></span></font></td>
<td valign="top" style="width:295px"><font face="Arial"><font size="2"><br>
<br>
Mit freundlichen Grüßen</font><br>
</font><font size="2" face="Arial">im Auftrag<br>
</font><font style="font-family:Arial; font-size:13.5pt; color:#000000; font-weight:bold">Michaela<font style="font-family:Arial; font-size:13.5pt; color:#000000; font-weight:bold">
</font>Huesmann</font><span style="font-size:5pt"><font face="Arial"> </font></span><span style="font-size:10.5pt; font-family:Arial; color:#000000"><br>
<font style="font-family:Arial; font-size:10pt; font-style:italic">IT</font><br>
<font style="font-family:Arial; font-size:10pt">Fachdienst Tiefbau</font><br>
</span><font face="Arial"><span style="font-size:5pt"> </span><br>
</font><font style="font-family:Arial; font-size:10pt; color:#000000"><font style="font-family:Arial; font-size:10pt; color:#000000">Tel.:
</font>+49 2552 925 219</font><br>
<span style="font-size:9pt; font-family:Arial; color:#000000"><font size="1"><font size="2">Fax:</font>
</font><br>
</span><span style="font-size:9pt; font-family:Arial; color:#000000"><font style="font-family:Arial; font-size:10pt; color:#000000; text-decoration:none">E-Mail:
</font><span style="font-family:Arial; font-size:10pt; color:#000000; text-decoration:none"><a href="mailto:michaela.huesmann@Stadt-Steinfurt.de" title="Click to send email to Huesmann, Michaela" target="" style="font-family:Arial; font-size:10pt; color:#000000; text-decoration:none"><span style="font-family:Arial; font-size:10pt; color:#000000; text-decoration:none">michaela.huesmann@Stadt-Steinfurt.de</span></a></span></span></td>
</tr>
</tbody>
</table>
<font color="#a5a5a5" size="1" face="Arial"><font color="#7d7d7d"><font color="#7d7d7d"><br>
Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.</font><br>
</font></font><br>
</div>
</body>
</html>