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)
I can confirm the problem in Version 4.0.0.0.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0) on Ubuntu 12.04 (x86)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) Thank you for your help! -- The LibreOffice QA Team
Retested. Still present in 4.2.8.2 (Build ID: 48d50dbfc06349262c9d50868e5c1f630a573ebd) Tested on Windows 7 Professional, sp1.
Also confirmed bug present in 4.3.5.2 Build ID 3a87456aaa6a95c63eea1c1b3201acedf0751bd5 Tested on Windows 7 Professional, sp1.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.