Hi Celia,
I am not sure that the paragraph is obsolete.
Taking your example a little further, suppose one of the cells in the
range B1:B13 contains the string "$Celia".
* Firstly, let us assume that "No wildcards or regular expressions in
formulas" is selected on the Tools > Options > LibreOffice Calc >
Calculate dialog. Then the formula =COUNTIF(B1:B13,"$Celia") should
give the expected value of 1.
* If we now select "Enable regular expressions in formulas" on the
Tools > Options > LibreOffice Calc > Calculate dialog, then the same
formula (=COUNTIF(B1:B13,"$Celia")) gives the answer 0. Why? Because
the $ is a special character.
* With regular expressions still enabled, the formula
=COUNTIF(B1:B13,"\$Celia") gives the answer 1 again. So the
backslash is required before the $ so that the regex processor does
not treat it as a special character.
I hope this makes sense and answers your question.
Regards,
Steve Fanning
On 16/01/2021 01:06, Celia Palacios wrote:
Hello again!
Here's another question. Same Calc Guide 6.2:
On page 244 this paragraph says:
«Activating the *Enable regular expressions in formulas* option means
all the above functions will require any regular expression special
characters (such as parentheses) used in strings within formulas, to
be preceded by a backslash, despite not being part of a regular
expression. These backslashes will need to be removed if the setting
is later deactivated.»
However, I have the aforementioned option enabled, and I'm using this
formula which yields the appropiate result:
=COUNT.IF(B1:B13,"^u.a$") for searching "uva" or "una" in cells, but
not "viuda" nor "suma".
I can trace back the paragraph to the OpenOffice wiki
(https://wiki.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc#Regular_expressions_in_Calc_functions).
I think that paragraph is obsolete.
Celia
--
To unsubscribe e-mail to: documentation+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
Context
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.