Issue 100733 - Copying sheet changes Control linked-cell references to absolute refs to original sheet
Summary: Copying sheet changes Control linked-cell references to absolute refs to orig...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: PC (x86_64) Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-31 21:50 UTC by jimavera
Modified: 2013-06-07 13:28 UTC (History)
3 users (show)

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

Attachments
Spreadsheet showing check-box control with cell reference changed by copying the sheet (14.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-03-31 21:54 UTC, jimavera 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jimavera 2009-03-31 21:50:48 UTC 
If a check-box form control contains an orginary cell reference (such as A1),
then if the sheet is copied, the reference is changed to 'OriginalSheetName'.A1
which makes the control manipulate the original sheet, not the copy.

Expected behavior: The cell reference should not be changed, so that it
continues to refer to the current sheet.

I will attach a demo .ods document.
Comment 1 jimavera 2009-03-31 21:54:38 UTC 
Created attachment 61320 [details]
Spreadsheet showing check-box control with cell reference changed by copying the sheet
Comment 2 raal 2009-07-13 14:10:06 UTC 
duplicate of unconfirmed bug 97290 ? Please could someone QA look at this?
I can confirm this behaviour and I mean it's bad behaviour.
Compare to MS excel where is possible copy form elements with respect to their
original references.
Comment 3 raal 2009-08-08 16:57:57 UTC 
duplicate of issue 58415
Comment 4 Edwin Sharp 2013-06-07 13:28:40 UTC 
As given in description.

Rev. 1489073 Win 7