Frequently asked questions - Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
How to update references to linked cells when copying form controls
Form controls linked to cells were created on a sheet. When copying (sheet or controls) to another sheet, these references are not updated and continue to target the original linked cell.
The following procedure[1] uses an example spreadsheet containing four sheets (A, B , C, D). The B sheet includes a Text box linked to A1 and a Counter linked to A2. You want to copy these controls into sheet D.
The principle is to paste controls into an intermediate spreadsheet in which the positions of the sheets are swapped.
Please follow all steps :
- Copy the range containing the controls
- Create a new "work spreadsheet" containing four sheets with same names in the "initial" but with sheets "source" (B) and "target" (D) swapped:
- Paste in the sheet D of the "work" spreadsheet
- Save (you can use any name) and close the "work" spreadsheet
- Reopen the the "work" spreadsheet
- Restore the initial positions of sheets:
- Copy the range containing the controls
- Paste into the sheet D of the original spreadsheet
- Save, close, and reopen the spreadsheet.
Notes: