https://bugs.freedesktop.org/show_bug.cgi?id=55603
Priority: medium
Bug ID: 55603
Assignee: [email protected]
Summary: EDITING: Wrong copy+paste of formulas with absolute
references
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.5.6.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 68065
--> https://bugs.freedesktop.org/attachment.cgi?id=68065&action=edit
And example of formula pasted
Problem description:
When copy and paste formulas with absolute references, sometimes the pasted
formula ignores the absolute reference and treats like relative references.
The problem appears when the absolute reference points to the source cell of
copy & paste process.
Steps to reproduce:
1. write a formula like this (at position A1): (test with formulas in Spanish
language)
=COLUMN()-COLUMN($A1)
2. Copy cell A1
3. Paste the formula at cells B1, C1, etc..
Current behavior:
The contents of paste cells is something like
B1 : =COLUMN()-COLUMN($B1) [results = 0]
C1 : =COLUMN()-COLUMN($C1) [results = 0]
etc.
Expected behavior:
The contents of paste cells must be:
B1 : =COLUMNA()-COLUMNA($A1) [results = 1]
C1 : =COLUMNA()-COLUMNA($A1) [results = 2]
etc.
The problems repeats with other funtions, like ROW, for example.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux i686; rv:15.0) Gecko/20100101 Firefox/15.0.1
LibreOffice 3.5.6.2 installed from Fedora 17 repository.
--
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
