Description: COUNTIF/COUNTIFS does not count when it meet 17:10~18:00. Steps to Reproduce: 1.Insert "17:10~18:00" to any cell. 2.Use COUNTIF or COUNTIFS to count it. 3."17:10~18:00" will not be counted by COUNTIF or COUNTIFS. Actual Results: the result of COUNTIF or COUNTIFS counting "17:10~18:00" is 0. Expected Results: the result of COUNTIF or COUNTIFS counting "17:10~18:00" should not be 0 if "17:10~18:00" presents. Reproducible: Always User Profile Reset: No Additional Info: I will submit attachment later
Created attachment 192110 [details] the ods countif/countfis not count 17:10~18:00
Created attachment 192111 [details] the screenshot showing countif/countfis not count 17:10~18:00
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