[Libreoffice-bugs] [Bug 126802] New: Copying sheet forces Control "Linked cell" refs to be qualified by original sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126802

            Bug ID: 126802
           Summary: Copying sheet forces Control "Linked cell" refs to be
                    qualified by original sheet
           Product: LibreOffice
           Version: 6.4.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190809/c868da51/attachment-0001.html>