Unfortunately I no longer have your original post so I'm using quotes of it from Brian Barker's
My first advice is to create a test copy of the spreadsheet file by saving it as a differently
named file. I construct such a file name by adding something like test- or trial- to the front of
the original file name. Then experiment with this test copy. Twenty thousand rows are not to be
trifled with while poking and prodding a live file. Also remember that you can generally undo your
See further comments below.
At 02:16 14/12/2015 +0900, Thomas Blasejewicz wrote:
Setting the language under "Format cells" -> "numbers" to German now
switches SOME (but not all) numbers like "50,000" to "50.000"
Regarding those that did not change:
Are these values computed? If yes, what is done in the formula? Or if no, try F2 and look to see
whether the number is preceded by a single quote (apostrophe) which signifies that the number is a
text string instead of a true number.
What is the number format (Alt+O, L) for those cells? Though unlikely, it is possible that a custom
format has been employed.
Numbers appearing on the screen as "50000" do not change at all.
latter one being the German localization. I am still fighting with
the problem, that this works in some cells, but not all (probably
because of the format of the entered data?). It would be helpful to
find a way change the thousand separator for "," to "." and the
decimal separator the other way around, because there are quite
literally thousands of items that need to be changed that way ...
The German language localization should have done that for true numeric values that are formatted
with the thousands separator attribute.
Brian also gave you very good information about numbers as text.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- Re: [libreoffice-users] double brackets · James E. Lang
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy