https://bugs.documentfoundation.org/show_bug.cgi?id=145569
Bug ID: 145569
Summary: COUNTWHENS condition can not point to a field only
contain an absolute value
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Like most of the calc-users I'm an expierenced EXCEL user comparing
functionality of EXCEL with calc.
I'm using a list with 64 numeric values and want to count the occurences.
Therefore I copy the list a second time and delete the duplicates (remove (not
hide) duplicates would be nice, but is not part of the bug.
When trying to count I use |=ZÄHLENWENNS(A$1:A$64;"=28,91")| . This works.
=ZÄHLENWENNS(A$1:A$64;"=A1") doesn't work. This finds no occurencies at all.
As there are 16 different values I inherit the formula to the next 15 lines.
Here the condition is not changed, so all the 16 lines compare with "=A1" and
not with "=A2" ... "=A16".
IMHO the formula doesn't make any difference between a value and a cell
reference (so the comparison "=A1" doesn't compare with the value in the cell
A1 but to the string "A1". And therefore the inheritance is also wrong.
Best regards from southern Germany and thanks for libreoffice!
Marc
--
You are receiving this mail because:
You are the assignee for the bug.
