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?
I would suggest some more specific name for your question, such as ‘Calc: Copying a check box to another sheet’.
There is a bug reported about this matter, please add your comment there.
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
.
- Open Source.ods
-
Right Click
Sheet1 tab▸Move/Copy Sheet
▸To document:
new document - The new doc opens▸
Save As
▸Dummy.ods (e.g.) -
Close
Dummy.ods -
Close
Source.ods -
Open
Dummy.ods▸Rename
Sheet1▸Sheet2 -
Open
Source.ods - Activate Dummy.ods (e.g. menu Windows)
-
Right Click
Sheet2 tab▸Move/Copy Sheet
▸To document:
Source.ods - Activate Source.ods▸
Save
▸Close
-
Close
Dummy.ods (don’t save changes) -
Open
Source.ods… everything is ok
Regards