https://bugs.documentfoundation.org/show_bug.cgi?id=119980
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #3 from Oliver Brinzing <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
