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
