Ask Your Question

Steve1948's profile - activity

2019-01-17 17:17:56 +0100 asked a question Check Box data property changes when copied.

Check Box data property changes when copied. I place a check box on Sheet1 and go to design mode properties under data a

2016-02-02 22:18:43 +0100 received badge  Famous Question (source)
2016-02-02 14:29:46 +0100 received badge  Notable Question (source)
2016-02-01 12:17:45 +0100 received badge  Student (source)
2016-02-01 11:00:55 +0100 received badge  Popular Question (source)
2016-01-31 13:59:47 +0100 asked a question 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?