Thousands separators in Calc

Discuss the spreadsheet application
Post Reply
Miro
Posts: 2
Joined: Thu Feb 08, 2018 11:04 am

Thousands separators in Calc

Post by Miro »

Hi

Anyone know how to get rid of Calc using . (full stop) as thousands separator?

Thanks in advance
OpenOffice 4.1.5, Windows 10
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Thousands separators in Calc

Post by robleyd »

See what you have set in Tools | Options | Language Settings under Language of -> Locale setting and whether that reflects where you are.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Miro
Posts: 2
Joined: Thu Feb 08, 2018 11:04 am

Re: Thousands separators in Calc

Post by Miro »

They seem to fit with my location
OpenOffice 4.1.5, Windows 10
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Thousands separators in Calc

Post by robleyd »

What is the setting?
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
Lupp
Volunteer
Posts: 3553
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Thousands separators in Calc

Post by Lupp »

By the way (once more): The relevant international standard published by ISO expressly deprecates any thousands grouping except by narrow spaces. Namely the point and the comma are mentioned as never to use because of the conflicts concerning the culture dependent decimal separators.

It is annoying that spreadsheet softwares simply ignore the standards.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Thousands separators in Calc

Post by Villeroy »

Whatever your current setting is, the attached sheet may help you to find an alternative that matches your needs. Just use the filter buttons.
Attachments
AOO4Locales.ods
(24.86 KiB) Downloaded 139 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply