The documentation
<file:///C:/Program%20Files/LibreOffice/help/en-GB/text/scalc/01/04060181.html?DbPAR=CALC#bm_id3164897>
for COUNTIF gives the following examples, among others:
=COUNTIF(A1:A10;">=2006")
=COUNTIF(A1:A10;"<"&B1)
=COUNTIF(A1:A10;C2)
=COUNTIF(A1:A10;"<0")
and these do indeed work.
However the list of regular expressions linked from the COUNTIF page
<file:///C:/Program%20Files/LibreOffice/help/en-GB/text/shared/01/02100001.html?&DbPAR=CALC&System=WIN>
does not include the use of > and < as operators.
Neither does the "full list of supported metacharacters and syntax"
<https://unicode-org.github.io/icu/userguide/strings/regexp.html> linked
from the help page in the previous paragraph.
Neither does the page <http://userguide.icu-project.org/strings/regexp>
linked from the REGEX help page
<file:///C:/Program%20Files/LibreOffice/help/en-GB/text/scalc/01/func_regex.html?DbPAR=CALC#bm_id831542233029549>
Please, is there anywhere that tells me what regular expressions are
supported?
David Lynch
Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster;
VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
To unsubscribe e-mail to: users+unsubscr...@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/users/
Privacy Policy: https://www.documentfoundation.org/privacy
