https://bugs.freedesktop.org/show_bug.cgi?id=54784
Bug #: 54784 Summary: EDITING: Copy/Paste of formula containing absolute address treats address as relative. Classification: Unclassified Product: LibreOffice Version: unspecified Platform: Other OS/Version: All Status: UNCONFIRMED Status Whiteboard: BSA Severity: normal Priority: medium Component: Spreadsheet AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: dwyo...@mail.com Problem description: Formula in cell a1 contains absolute reference to cell in which formula is entered. When doing copy/paste of the cell, the address is treated as a relative address. Steps to reproduce: 1. In cell a1, enter formula: =ROW(A1) - ROW(A$1) 2. Copy/paste cell a1 to a2 Current behavior: As a result of the paste, cell a2 contains: =ROW(A2) - ROW(A$2) Expected behavior: Cell a2 should contain =ROW(A2) - ROW(A$1) Platform (if different from the browser): Windows XP Professional Version 2002 Service Pack 3 Browser: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20100101 Firefox/15.0.1 Additional note: This problem is occurring in 3.5.6.2, the release version as recommended on the LO download page on Sep. 10, 2011. There is no selection for 3.5.6.2 in the Version drop-down menu, other than "3.5.6.2 rc", and when that selection is made and the submit button is clicked, then an error message says there is no such version. Therefore I entered the version as "unspecified". -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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