[Libreoffice-bugs] [Bug 112115] New: COUNTIF not counting non-blank cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112115

            Bug ID: 112115
           Summary: COUNTIF not counting non-blank cells
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: neavesphilip at gmail.com

Created attachment 135877
  --> https://bugs.documentfoundation.org/attachment.cgi?id=135877&action=edit
Spreadsheet to resolve backups

I have a spreadsheet that counts NON blank cells.  It works in 5.3.4.2
but counts ALL cells in 5.4
Syntax example is:
=COUNTIF(D24:N24,"<>""")
I have attached the spreadsheet.
Delete a 'Y' and the counts go up to 11.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170830/cef13b9b/attachment.html>