Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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 
experimental changes.

See further comments below.

-----Original Message----

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. 

Same comments.

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.