Why does the thousands separator doesn't show?

Post here those questions, bug reports and suggestions for SoftMaker Office 2021 for Windows that do not fit in any of the application-specific subforums.
Post Reply
@leksander
Posts: 5
Joined: Wed Apr 19, 2023 4:51 am

Why does the thousands separator doesn't show?

Post by @leksander »

I can't get the thousands separator to work at all. This is how it looks like in the settings:
Image
The chosen format below shows it correctly: -1.234,56 but above it looks completely different.
Any Ideas what I do wrong?
Woody44
Posts: 483
Joined: Wed May 22, 2019 11:56 pm

Re: Why does the thousands separator doesn't show?

Post by Woody44 »

Why does the example have two decimal points in the number string? Could that be interfering with the comma placement?

My informal test suggests that this is the problem.
@leksander
Posts: 5
Joined: Wed Apr 19, 2023 4:51 am

Re: Why does the thousands separator doesn't show?

Post by @leksander »

I was wondering about the same thing. But how to correct this I couldn't figure out.
Woody44
Posts: 483
Joined: Wed May 22, 2019 11:56 pm

Re: Why does the thousands separator doesn't show?

Post by Woody44 »

How to correct it?

Remove the wayward decimal point, of course.
@leksander
Posts: 5
Joined: Wed Apr 19, 2023 4:51 am

Re: Why does the thousands separator doesn't show?

Post by @leksander »

Removing the decimal points leads to this:
Untitled-2.jpg
The displayed Value is 1 Million typed 1000000 and with thousands separator on that gives me 1000000.0
What? Isn't it supposed to show 1.000.000 instead? Separating the thousands? But it hangs a decimal point on the end and another 0...
Woody44
Posts: 483
Joined: Wed May 22, 2019 11:56 pm

Re: Why does the thousands separator doesn't show?

Post by Woody44 »

I can't reproduce your result. It doesn't matter if I set the currency format to Europe (1) or Europe (2), with the number of decimal places set to zero I have no decimal places displayed.
@leksander
Posts: 5
Joined: Wed Apr 19, 2023 4:51 am

Re: Why does the thousands separator doesn't show?

Post by @leksander »

And with the "Thousands Separator" on you probably see 1.000.000 instead of 1000000.0 as it should be...
Just I don't. And no idea whether it is caused by a discrepancy between how windows wants to set the comma and how the program want's it?
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2935
Joined: Wed Mar 11, 2020 5:31 pm

Re: Why does the thousands separator doesn't show?

Post by SuperTech »

Thanks for your post. Please check the settings region > Additional settings > Currency on your operating system level.
@leksander
Posts: 5
Joined: Wed Apr 19, 2023 4:51 am

Re: Why does the thousands separator doesn't show?

Post by @leksander »

Image
raitis.veksejs
SoftMaker Team
SoftMaker Team
Posts: 122
Joined: Fri Sep 15, 2017 1:29 am

Re: Why does the thousands separator doesn't show?

Post by raitis.veksejs »

Could you please provide us with a sample file? Normally, there are not allowed decimal separator and thousands separator the same - your screenshot shows that both are dots.
Post Reply

Return to “SoftMaker Office 2021 for Windows (General)”