[Libreoffice-bugs] [Bug 119980] COUNTIF function doesn't return values when Criteria is set to a cell

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Sep 19 17:01:13 UTC 2018


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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
i had a look at your example:

- select menu "View/Value highlighting" first

- A3 contains a decimal number: 432,65
- B3 refers A3: =LEFT(A3;1)
- result is: 4 (text) 
  i didn't even know that this is working, cause
  Left() formula requires parameter: =Left(Text, Number)

- D3 contains a number: 1
- E3 refers D3: =COUNTIF($B$3:$B$32;D3)
  so you compare text with vaules ...

  -> change D3 to text, e.g. type '1 or format as Text @ and enter 1 again

-- 
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/20180919/4012c5a1/attachment.html>


More information about the Libreoffice-bugs mailing list