Issue 58415 - Inconsitent reference link handling for checkboxes and other form fields when Copying Sheets
Summary: Inconsitent reference link handling for checkboxes and other form fields when...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: All Windows XP
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 72095 97290 (view as issue list)
Depends on:
Reported: 2005-11-25 08:45 UTC by w2wwong
Modified: 2017-05-20 11:11 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Copy/Move Sheet Bug (115.50 KB, application/
2005-11-25 08:47 UTC, w2wwong
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description w2wwong 2005-11-25 08:45:46 UTC

I opened an Excel file using Calc. This worksheet contains checkboxes which are 
used to calculate values.

My previous excel worksheet contains 5 worksheets. After opening using Calc, I 
wanted to copy 1 more worksheet. I chose the 'Copy/Move sheet' function and 
successfully created another worksheet (sheet B), which is a copy of the last 
worksheet (sheet A).

However, the checkboxes of these 2 worksheets are now linked. Meaning that 
whenever I choose which checkboxes to 'check'in Sheet A, sheet B will also 
reflect the same checkboxes as 'checked'.

I have attached the worksheet (Calc Bug.xls) for your reference.

Thank you very much.

Wilfred Wong
Comment 1 w2wwong 2005-11-25 08:47:08 UTC
Created attachment 31783 [details]
Copy/Move Sheet Bug
Comment 2 lars 2005-11-25 19:22:05 UTC
confirmed on Windows XP SP2 with OOo-dev 2.0.139: open the attached file and 
check a box in sheet A, then look at B to see that the box got also checked 
Comment 3 frank 2005-12-15 11:48:56 UTC
Hi Niklas,

the reference in the control on the original sheet is relative. So it seems to
be a bug. Yours or Eikes ?

Comment 4 niklas.nebel 2006-07-14 18:09:58 UTC
Controls don't have relative references. But it would make sense to adjust them
when copying the whole sheet.
Comment 5 frank 2007-03-12 12:44:27 UTC
*** Issue 72095 has been marked as a duplicate of this issue. ***
Comment 6 Rainer Bielefeld 2007-03-12 14:13:21 UTC
This problem does not only affect checkboxes, as 'nn' annotated in comments ri
Jul 14 17:09:58. So I modify Summary to make it more meaningful and general (as
I hope).
Is TM "2.x" realistic (still not STARTED) or should we modify HELP to say
clearly that those references are absolute?
Comment 7 niklas.nebel 2007-12-04 18:07:19 UTC
retarget 2.x -> 3.x
Comment 8 raal 2011-05-18 05:45:02 UTC
Please take a look on this issue, these bug is serious problem in our company. Copying of whole sheet is common and we are waiting few years for repair of this bug. Thank you for your good work.
Comment 9 choffardet 2012-02-26 13:29:29 UTC
I use calc to evaluate my students. a template sheet using cursors as been built.

I can't copy this template for each student. all the copyed sheets are referenced to the template.

this work fine with MS Office

please have a look.

Comment 10 binguo 2012-09-03 08:39:16 UTC
*** Issue 97290 has been marked as a duplicate of this issue. ***
Comment 11 Marcus 2017-05-20 11:11:30 UTC
Reset assigne to the default "".