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