https://bugs.freedesktop.org/show_bug.cgi?id=54481
Bug #: 54481
Summary: EDITING: inconsistant label reference
Classification: Unclassified
Product: LibreOffice
Version: 3.5.6.2 rc
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
When working with identical local labels in several sheets, copy and paste
across the sheets messes up label consistancy really bad.
Steps to reproduce:
1. On sheet1 fill cells with exact data shown in square brackets:
A1:[ACOL]
B1:[BCOL]
A2:[="S"&SHEET(A2)&"."&A$1&".R"&ROW(A$1)]
2. Do the same on sheet2
3. Add label ranges for both sheets with insert->names->labels
These entries should be in the label table:
$Sheet1.$A$1:$B$1
$Sheet2.$A$1:$B$1
4. Write [=ACOL] (no quotes) in C2 of sheet1. Watch cell content contain
[='ACOL'] and cell showing [S1.ACOL.R1]
5. Copy the entire C2 (using ctrl-c, ctrl-v) to same position in sheet2 and
watch it contain the same [='ACOL'] and showing the same [S1.ACOL.R1]. Note
that this is not expected. It should show S2...
6. Now TYPE ='ACOL' in the same cell and watch it now display correctly
"S2.ACOL.R1". This inconsistancy is locked and invisible by reading the cell
content, and apparently the only way to get it right is to type cell content or
copy and paste from same page.
LibreOffice 3.5.6.2
Build ID: e0fbe70-5879838-a0745b0-0cd1158-638b327
Platform (if different from the browser):
Browser: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center
PC 6.0; .NET4.0C; .NET4.0E)
--
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
