https://bugs.freedesktop.org/show_bug.cgi?id=57929
Priority: medium
Bug ID: 57929
Assignee: [email protected]
Summary: Switching between absolute & relative external
references not possible (regression)
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description: It does not work anymore to switch between absolute &
relative references in Calc if the reference comes from an external file. This
used to work in previous versions, so it is a regression. In the tested
version, Calc gives an error message "No references found".
IMHO this is a very often used feature in spreadsheet programmes, since many
values may be imported from other files (e.g. financial calculations). This
regression makes Calc almost useless when working with external references.
Steps to reproduce:
1. Create a new Calc spreadsheet and write the value "1" in cell A1. Save the
file.
2. Create a second file
3. Type in the second file in cell A2 "=" and pick with the mouse the cell "A1"
from the first file. You will see the value of the first file in the second
file. So far, everything works fine. What you see is a relative reference.
4. Click in cell A2 in the second file and try to hit "Shift" & "F4". This
should switch from relative references "='file:///test.ods'#$Sheet1.A1" to the
absolute reference "='file:///test.ods'#$Sheet1.$A$1". This does not work
anymore. You get the error message "No references found".
Cross-check: This feature still works if the reference is in the same file:
5. In the second file write the value "2" in cell B1.
6. Type in the second file in cell B2 "=" and pick with the mouse the cell "B1"
in the same file. You see the value as relative reference.
7. Hit "Shift" & "F4" and you see that the relative reference switches to an
absolute reference "=$B$1".
System: Ubuntu 11.10, LibreOffice 3.5.4.2 Build ID: 350m1(Build:2)
--
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
