https://bugs.documentfoundation.org/show_bug.cgi?id=97552
Bug ID: 97552 Summary: unexpected changes in formula references Product: LibreOffice Version: 5.2.0.0.alpha0+ Master Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mrz...@gmail.com Created attachment 122372 --> https://bugs.documentfoundation.org/attachment.cgi?id=122372&action=edit unexpected changes occurs in sheet ID2 Some formulas that uses data from other sheets can change references unexpectedly if the source sheet cells has changed. I tried to find out if changes in references will go on other sheets but it didnt. for example if i have a connection like sheet1 -> sheet2 -> sheet3 then changeing some of data in sheet1 will sometime change references in sheet2 but sheet3 formulas using results in sheet2 will not change. But if i have only sheet2 (sheet1 -> sheet2) some changes in sheet1 will change some of references in sheet2. I use to change data within sheet1 by -copy/paste- not by -cut/paste- so i don't expect my formula references to be changed even if my formulas has no $ sing to lock reference of cell. I have to correct this changes manually if it occurs, also not all the formulas changes, only some of them. -- 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