fn:format-number() for german style numbers

Saturday, 27 October 2018 · 2 messages
WS
Wiemer, Sebastian27 Oct 2018 08:39 #

Hello everyone!

How do I format german style numbers e.g.: 1.000.00,99€ (for one million € and 99cents) ?

The following approach:

format-number(26825.8, '#.###,00')

yielded an error: [FODF1310] Invalid picture string: '#.###,00'.

Anyone an idea what is going wrong here?

Best regards,

Sebastian

Quoted text · 2 lines
------------------------------------------------------- >>> business. people. technology. <<<

------------------------------------------------------- adesso AG mit Sitz in Dortmund Vorstand: Michael Kenfenheuer (Vors.), Christoph Junge, Dirk Pothen, Andreas Prenneis Vorsitzender des Aufsichtsrates: Prof. Dr. Volker Gruhn Amtsgericht Dortmund HRB 20663

MH
Martin Honnen27 Oct 2018 09:26 #
Quoted text · Wiemer, Sebastian · 12 lines
Am 27.10.2018 um 08:39 schrieb Wiemer, Sebastian: > > > How do I format german style numbers e.g.: 1.000.00,99€ (for one > million € and 99cents) ? > The following approach: > > format-number(26825.8, '#.###,00') > > yielded an error: [FODF1310] Invalid picture string: '#.###,00'. > >
declare decimal-format local:de
   decimal-separator = "," grouping-separator = ".";
format-number(26825.8, '#.###,00', 'local:de')

⚡Generated with XQuery