Libre Office Calc

[Steve1948]

I have a sheet in Calc (sheet 1) with a check box linked to cell c101.
When unchecked c101=0 and when checked c101=1. Cell c1 is linked to cell c101;
Cell c1: If(c101,1000,0). This works fine. When I copy sheet 1 to sheet 2
the check box is linked to sheet 1 c101. Is there a way that on copy the
check box is linked to sheet 2 c101 and not sheet1 c101?

[Huge]

I would suggest some more specific name for your question, such as ‘Calc: Copying a check box to another sheet’.

[mariosv]

There is a bug reported about this matter, please add your comment there.

EDITING: Inconsistent / unintuitive reference link handling for check boxes and other form fields when Copying Sheets

[PYS]

Hi

There is a procedure to get what you want but it is important to follow all the steps in that order. In what follows I assume the document that contains the check box is named Source.ods, the sheet is named Sheet1.

1. Open Source.ods
2. Right Click Sheet1 tab▸ Move/Copy Sheet▸To document: new document
3. The new doc opens▸Save As▸Dummy.ods (e.g.)
4. Close Dummy.ods
5. Close Source.ods
6. Open Dummy.ods▸Rename Sheet1▸Sheet2
7. Open Source.ods
8. Activate Dummy.ods (e.g. menu Windows)
9. Right Click Sheet2 tab▸ Move/Copy Sheet▸To document: Source.ods
10. Activate Source.ods▸Save▸Close
11. Close Dummy.ods (don’t save changes)
12. Open Source.ods… everything is ok

Regards