Libre Office Calc

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.

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

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 SheetTo 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 SheetTo document: Source.ods
  10. Activate Source.ods▸SaveClose
  11. Close Dummy.ods (don’t save changes)
  12. Open Source.ods… everything is ok

Regards