https://bugs.documentfoundation.org/show_bug.cgi?id=121078
Bug ID: 121078
Summary: Calc IF function executes false condition even though
true should have been
Product: LibreOffice
Version: 6.0.5.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a spreadsheet I use for tracking daily percentage of change from the
previous row. The unpopulated row should be blank but gives a #VALUE! in the
cell in question. I easily recreated this and will attach an example.
Steps to Reproduce:
1.Create a column of numbers (A1 thru A4 for example)the values of which can be
greater or less than the number above. Follow suit for column B. For Column C,
total A+B for the row. Drag the SUM formula down to C6 while A and B 5 and 6
are unpopulated.
2.In column D on the second row, the formula should be as follows:
=IF(C1="","",SUM(C2-C1)/C1)*100. Drag the formula down to D6.
3.Expected result is D5 and D6 should remain blank (following the TRUE portion
of the formula) but the cell gets a #VALUE! since it's looking at D4 for the
FALSE portion of the IF. (Use TRACE ERROR to see this)
Actual Results:
Cell is populated unexpectedly.
Expected Results:
Expect the cells to remain blank.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
IF should have ignored the FALSE portion of the formula.
--
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
