https://bugs.documentfoundation.org/show_bug.cgi?id=159332
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #3 from Mike Kaganski <mikekagan...@hotmail.com> ---
This is not a bug.
As documented in help [1] [2], COUNTIF/COUNTIFS functions use wildcards (if
enabled in calculation options, which is the default since version 5.3 [3]).
The wildcards are documented at [4]. The ~ character has special meaning there;
so you may either disable wildcards in the settings, or escape tilde characters
(and other special wildcards) using second tilde.
[1]
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060181.html?DbPAR=CALC#bm_id3164897
[2]
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_countifs.html?DbPAR=CALC
[3] https://wiki.documentfoundation.org/ReleaseNotes/5.3#Option_settings
[4]
https://help.libreoffice.org/latest/en-US/text/scalc/guide/wildcards.html?DbPAR=CALC
--
You are receiving this mail because:
You are the assignee for the bug.
