https://bugs.documentfoundation.org/show_bug.cgi?id=159332
Bug ID: 159332 Summary: COUNTIF/COUNTIFS does not count when it meet 17:10~18:00 Product: LibreOffice Version: 7.6.4.1 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: minhsien0...@gmail.com 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 -- You are receiving this mail because: You are the assignee for the bug.