Description:
A checkbox control can have a "Linked cell" reference.  The specified cell is auto-updated to reflect the state of the checkbox.  The reference may or may not have a SHEETNAME. qualifier (e.g. SHEET1.C1 or just C1).

However, when the sheet is copied, un-qualified references are changed to be qualified by the *original* sheet name.  This defeats the intended behavior or referring to the "current" sheet, i.e. all copies will update the same cell on the original sheet.

The reference either should be left as-is (unqualified in this case), or if some internal limitation requires adding a sheet qualifier, then the *new* sheetname should be the qualifier (similar to what happens with Named Ranges when copying sheets).  But again, the most "obvious" behavior would be to not change such references at all; if the user originally specified an unqualified cell address, then it should remain that way, so it refers to the "current" cell; and if the user does specify a sheet. qualifier, then that should be left alone as well.  IMO, of course...

Steps to Reproduce:
1. Open the attached "checkbox.ods".  Do NOT enable macros.

2. Tools->Forms and CHECK "Design Mode"

4. Click on the checkbox Control to select it;
   Rightclick->Control Properties...
   Click the "Data" tab

5. Set "Linked Cell" to C1 (should already be set)

7. Copy the sheet
   (rightclick on SHEET1 tab->Move or Copy, click Copy, then OK)

8. In the copied sheet, view "Linked cell" property of the checkbox
   Control (see step 5 above)


Actual Results:
The Linked cell is changed from "C1" to "SHEET1.C1"

Expected Results:
The reference should remain unqualified (or, in the alternative, qualified with the *new* sheetname)


Reproducible: Always


User Profile Reset: No



Additional Info: