https://bugs.documentfoundation.org/show_bug.cgi?id=50732
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Version|3.5.3 release |Inherited From OOo
Resolution|--- |NOTABUG
--- Comment #4 from Eike Rathke <[email protected]> ---
This is not a bug. If you want to match the string "Unpaid" then you have to
enter it as string "Unpaid" including the double quotes, or use a cell
reference to a cell that contains the string.
When entered without double quotes the Unpaid is taken as a) a defined name, or
b) if there exists no name like in this case a label looked up in B2, being a
row label in this case with the formula in C1 the implicit intersection at C2
is formed as reference and the value in C2 (in this example 0) is the
criterion. The label ends up in single quotes because that is the canonical
form of a label, in case the string value in B2 is changed the label in the
formula follows that and if it includes whitespace then it has to be enquoted
in single quotes.
In newer releases the "Automatically find column and row labels" option under
Tools -> Options -> Calc -> Calculate is disabled, because it leads to
confusion and maybe unexpected results, so in this example the formula results
in #NAME? error. Only labels within defined label ranges are used per default,
but not looked up from the sheet if not defined.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
