Ask Your Question

Libre Office Calc

asked 2016-01-30 19:30:03 +0100

Steve1948 gravatar image

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?

edit retag flag offensive close merge delete


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

Huge gravatar imageHuge ( 2016-02-01 11:04:41 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-01-31 18:28:24 +0100

m.a.riosv gravatar image
edit flag offensive delete link more

answered 2016-02-03 19:12:07 +0100

pierre-yves samyn gravatar image


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


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-30 19:30:03 +0100

Seen: 121 times

Last updated: Feb 03 '16