[Libreoffice-bugs] [Bug 121078] New: Calc IF function executes false condition even though true should have been

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: david.brauksieck at gmx.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181031/4720c23f/attachment-0001.html>