https://bugs.documentfoundation.org/show_bug.cgi?id=89404

            Bug ID: 89404
           Summary: Empty cells have non-zero value when used in formula
           Product: LibreOffice
           Version: 4.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: blocker
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: gunther.l...@quergedacht.at

Created attachment 113412
  --> https://bugs.documentfoundation.org/attachment.cgi?id=113412&action=edit
calculated value at cursor should be zero

I'm having a big table with payments and a formula adding VAT percentage
values.
Prior to 4.4.0.3 this worked flawlessly, but now something strange happens.

As you can see in the screenshot at the cursor position it yields a value of
2000 although it should simply be zero, because the cell to left ist empty.

In the second screenshot you see the formula.

When I enter a 0 into the empty cell, the calculation is correct.

Deleting the 0 gives again the wrong value.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to