On 2015/12/13 21:26, Brian Barker wrote:
In the Find & Replace dialogue, click More Options. You probably have
"Regular expressions" ticked. Untick it and try again.
I DID try that in my office, but had no success. Now back home that worked.
The "same" applies to searching for "," and replace that by "." (of
course, none of these searches uses the ")
Remember that what you see in a spreadsheet cell may very well not be
there! If those commas are fractional separators in numbers - e.g.
1,23 - they are not there in the same sense as then would be as text.
The details of this depend on your locale settings.
I see. That is very enlightening!
Setting the language under "Format cells" -> "numbers" to German now
switches SOME (but not all) numbers like
"50,000" to "50.000"
(Some) Numbers appeaing on the screen as "50000" do not change at all.
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 ...
(But it is 2:30 am now and I think, I will continue trying tomorrow)
To unsubscribe e-mail to: firstname.lastname@example.org
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
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