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

            Bug ID: 85946
           Summary: cell move breaks cell references
           Product: LibreOffice
           Version: 4.2.7.2 rc
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 109002
  --> https://bugs.freedesktop.org/attachment.cgi?id=109002&action=edit
Calctest.ods for tests

installed is Fedora's libreoffice-calc-4.2.7.2-2.fc20.x86_64 with kernel 3.17.2

a regression since update to 4.2.7.2-2

Problem description:
==================== 
To show this I attached a spreadsheet (Calctest.ods) with 4 tabs: Jan, Feb,
Mar, Apr

starting with tab "Feb" the cell "C3" is a reference of the cell "C12" of the
previous tab ( Feb.C3==Jan.C12, Mar.C3==Feb.C12, ...)  

since the update I get an error "Err:523" if I move in last tab "Apr" the
selected cells "E23:F23" with the mouse to the right side.

If I press key "F9" all cells "C3" contain this error.

sometimes it seems to be necessary to save, close and reopen the spreadsheet
and/or to move "Apr.E23:F23" back and forth.

tricky !

what I mentioned is that for example the cell "Apr.C3=Mar.C12" reads
"Apr.C3=C3" just after the move of "E23:F23" !
the reference "=Mar" is lost... 

maybe related to bugs

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=45574

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=85282

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

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

Reply via email to