To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72095
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
OS/Version|All |Windows XP
--------------------------------------------------------------------------------
Platform|All |PC
--------------------------------------------------------------------------------
Summary|copying a sheet with a con|Inconsistent link handling
|trol that (relatively) lin| for form fields comparing
|ked to a cell results as a| move and copy operation n
|n absolute link |ot mentioned in HELP
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Mar 10 09:07:45 +0000
2007 -------
I can confirm that unexpected behaviour with "2.2.0RC2 Multilanguage/German
version WIN XP: [680m9(Build9124)]"
Steps to reproduce:
1. open attached "sample.ods"
2. change to 'Form Controls Design Mode' if necessary
3. rightclick checkbox on Sheet 1, select 'Control ...' and check
'Card "Data" / Linked Cell': should be 'B20'
4. If you want you can switch off 'Form Controls Design Mode' to test the
function of the box: check / uncheck writes "true" / "false" into cell
'B20'.
5. switch on 'Form Controls Design Mode' if necessary
6. Menu 'Edit > Sheet > Move/Copy' and select
- 'To document': "Sample.ods"
- 'Insert Before': "Sheet3"
- leave checkbox 'Copy' unchecked
- <OK>
'Sheet1' will be moved between 'Sheet2' and 'Sheet3'
7. rightclick checkbox on 'Sheet1', select 'Control ...' and check
'Card "Data" / Linked Cell': should be 'B20' on Sheet 1
(at it's new position)
8. If you want you can switch off 'Form Controls Design Mode' to test the
function of the box: check / uncheck writes "true" / "false" into cell
'B20'.
That shows that the link leads to a cell on the same sheet (relative)
as expected.
Now close the document without saving and reopen it.
Redo tests from 1 ... 6, but check checkbox 'Copy' in step 6. That will create a
new sheet 'Sheet1_2'.
Now (after you changed to 'Form Controls Design Mode', if necessary) rightclick
checkbox on Sheet 1_2, select 'Control ...' and check
'Card "Data" / Linked Cell': It is 'Sheet1.B20' on 'Sheet1'. That is unexpected
and inconsistent, with experience from first test I would expect that in the new
cell the linked cell should also be on the same sheet.
When you test the checkbox on 'Sheet1_2', you see that it toggles 'Sheet1:B20'
and the checkmark in the checkbox on 'Sheet1'.
It seems that links to other sheets always are "absolute".
I do not think that the current behaviour is inexpedient and should be changed,
but the help text is incomplete, so I see this as a documentation / helpcontent
problem.
The current behaviour is not new, I also see it in 1.1.4
@mroe
please specify your OS and Platform!
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
