Issue 58415

Summary: Inconsitent reference link handling for checkboxes and other form fields when Copying Sheets
Product: Calc Reporter: w2wwong <w2wwong>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, lars_o_hansen, pierre.choffardet, raal
Version: OOo 1.1.3Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Copy/Move Sheet Bug none

Description w2wwong 2005-11-25 08:45:46 UTC 
Hi,

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 
there
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 ?

Frank
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.

regards
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 "issues@openoffice.apache.org".