https://bugs.freedesktop.org/show_bug.cgi?id=71612
Priority: medium
Bug ID: 71612
Assignee: [email protected]
Summary: Other: =WENN(ODER(ISTLEER(G1);ISTLEER(H1));"";G1-H1)
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 89199
--> https://bugs.freedesktop.org/attachment.cgi?id=89199&action=edit
Window showing what is seen on my desktop for a file using "ODER"
Problem description:
This shall be "" if G1 or H1 or both are empty.
If both fields carry values it shall print G1-H1.
But it prints only "" if *BOTH*, G1 *and* H1 are empty. In cases G1 *or* H1 are
empty it prints "#WERT!". In case both hold values it prints G1-H1. The
function "ODER" acts as "UND".
If I switch from "ODER" to "UND" it doesn't change anything.
Steps to reproduce:
1. Install LibreOffice
2. Open Spreadsheet
3. Enter the formula and values
Current behavior:
Prints G1-H1 in case G1, or H1, or both hold values
Expected behavior:
Only print G1-H1 if both fields hold values
Operating System: Windows XP
Version: 4.1.3.2 release
--
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
