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

          Priority: medium
            Bug ID: 82936
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: Editing : references to different sheet get removed on
                    dragging cell
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: ja...@rinac.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.3.1.1 rc
         Component: Spreadsheet
           Product: LibreOffice

references to different sheet get removed on dragging cell.

Reference changes to same sheet.

Step to produce.

1. enter some value in the cells [sheet1] 
2. create some formula using values entered in sheet1
3. create a reference in other sheet[sheet2] using formula referring sheet1
4. move the formula created in sheet1.
5. the formula eg. sheet1.A1 get lost on sheet 2 & become A1 only

Sample file attached. 
first formula cells on sheet2
move yellow cell on sheet 1

now check formula on sheet 2. all reference become lost.

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