https://bugs.freedesktop.org/show_bug.cgi?id=87678

            Bug ID: 87678
           Summary: Formula calculates data from the row below that
                    programmed
           Product: LibreOffice
           Version: 4.3.5.1 rc
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: jacek.skrzynecki....@gmail.com

Created attachment 111270
  --> https://bugs.freedesktop.org/attachment.cgi?id=111270&action=edit
Register of work time for team members (one person on one sheet).

In attached file on sheet "Marta Borowiec" in column E shuld be calculated time
of work (formula simply subtracts col.D-C in the same row).
In row 5 I manually corected formulas by retyping THE SAME FORMULA : E5=D5-C5 
But in row 6 till 50 cells are not edited. Results are calculated from rows
below (offset?). Using F9 or recalculate function from menu or saving and
closing file - doesn't affect the result.

-- 
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