What is the correct number formatting (german) for Confluence (using in tables/chart macro)?

[Kay]

Hi,

just want to configure the number formatting for Confluence.

We want it to be like 1.234.567,89

So I have tried the following:

Long format 

###.###

Long decimal format 

#.###,##

When I try to apply C says: Invalid decimal number format.

How to configure this correctly?

Thanks a lot!

[Marc - Devoteam]

Hi @Kay 

Look at the following KB article, https://support.atlassian.com/confluence-cloud/docs/configure-number-formats/ 

[Kay]

Hi, thank you, I have read it alredy before. There is no description how to configure the correct format for german numbers. Or I am just blind...

[Sven Alderath]

same issue for me, without a solution currently

[Marc - Devoteam]

Hi @Kay @Sven Alderath 

What is german format, as I'm dutch this should be the same format.

Try:

###,###

###,###,##

[Kay]

True, but in your example I miss the period dot in the patterns. I tried but when entering numbers in C with a comma it's not using it a decimal seperator. This works still only with a dot. Really weird...

Maybe my example makes it more clear:

Test 1 should be the hightest and a little bit higher than Test 3. The one in the middle should be the lowest.

The dot is used as a decimal seperator, but it should be the comma and the dot should be used to sperate the thousands only, no matter if written in the number or not (1500 = 1.500).

[Marc - Devoteam]

Hi @Kay 

Also are you browser and PC using the right locale.

Numbers is always tricky.

[Kay]

On OS level it's correctly configured. The Browser is configured to take over the OS settings or is set correctly as well. Tried different browsers.

I am still pretty sure it's the uncorrect setting in Confluence.

[Sven Alderath]

In my opinion the setting "setlocale" is missing.

[Kay]

It's probably a bug. I should open a ticket at Atlassians board and wait about 10 years for a solution...

Sorry, not sorry. :-D