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

At 20:40 13/12/2015 +0900, Thomas Noname wrote:
I have a 20,000 row file I am supposed to "review" (a translation by someone else) While changing things, I made a mistake and now one particular word appears as ((word)) Naturally, the double brackets are NOT wanted. When I try to search and replace them, Calc tell me, there are no such double brackets. But they are right in front of me on the screen. Is there any particular reason why I cannot search for "((" ?

In the Find & Replace dialogue, click More Options. You probably have "Regular expressions" ticked. Untick it and try again.

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 trust this helps.

Brian Barker

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.