Re: [libreoffice-users] double brackets

Thomas, 

Unfortunately I no longer have your original post so I'm using quotes of it from Brian Barker's 
response.
 
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.

> (Some) 
> Numbers appearing on the screen as "50000" do not change at all. 

Same comments.

> The 
> 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.

-- 
Jim


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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