https://bugs.freedesktop.org/show_bug.cgi?id=75123
Priority: medium
Bug ID: 75123
Assignee: [email protected]
Summary: EDITING: IF Function
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.5.1 rc
Component: Spreadsheet
Product: LibreOffice
Problem description:
=WENN((ODER(Lehrer.B2=Schulen.B2;Lehrer.B2=Schulen.C2;Lehrer.B2=Schulen.D2;Lehrer.B2=Schulen.E2
));"there is";"is not")
works correct
=WENN((ODER(Lehrer.B2=Schulen.B2;Lehrer.B2=Schulen.C2;Lehrer.B2=Schulen.D2;Lehrer.B2=Schulen.E2
));4;0)
or
=WENN((ODER(Lehrer.B2=Schulen.B2;Lehrer.B2=Schulen.C2;Lehrer.B2=Schulen.D2;Lehrer.B2=Schulen.E2
));Priorität.B2;Priorität.D2)
Current behavior:
answers only with "TRUE" or "FALSE" respectivly
Expected behavior:
should give the values either written or stored in the adresses
Operating System: Windows 8
Version: 4.1.5.1 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
