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
