To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62238
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Feb 19 22:50:21 -0800
2006 -------
I checked with "2.0.1 RC5 German version WIN XP: [680m1(Build8990)]" and was
able to reproduce the problem.
Steps to reproduce the problem
1. open 'oo-Fehler1-2.ods'
2. select sheet "A"
3. Menu "Edit - Sheet - Move/Copy - "Move to end position"
3.1. Check checkbox copy
3.2. Select "- move to end position -"
A ne sheet "A_2" with content like "sheet A" will be created
Everything looks fine
4. Select cell 'A_2.A7' by mouseclick, yo will see
"=DATE(YEAR($A.A5);MONTH($A.A5)+1;1)" in 'Formula Input Line'
5. Mark contents of 'Formula Input Line" by mousepointer and press <cntrl>+<c>
6. Click cell 'A_2.A5'
7. Press <cntrl>+<v>
Formula in cell 'A_2.A5' will be replaced and "07:42" will appear in cell
'A_2.B5'
8. Menu "Edit - Sheet - Move/Copy - "Move to end position"
8.1. Check checkbox copy
8.2. Select "- move to end position -"
A new sheet "A_2_2" with content like "sheet A_2" will be created.
Everything looks fine, "07:42" still is visible
9. go back to sheet A_2
expected: "07:42" still is visible in cell 'A_2.B5'
actual: formula is still in cell, but no "07:42" visible
Some further results.
If I continue copying last sheet to new sheet, always "07:42" disappears in 'B5'
of sheet from where I copied.
If I change date in 'A.A5'to something late after today (1.6.06), all cells 'B5'
will become grey.
If I change 'A.A5' back, grey background will disappear in all cells 'A_x.B5',
but only in latest sheet "07:42" will appear as expected.
It seems that the formula in 'A_x.B5' is not really "excepted" by OOo.
Steps to make reappear "07:42":
21. select a cell 'B5' with "disappeared" "07:42"
22. Click into 'Formula input line' between the last to quotation marks before
bracket.
23. Insert blank and remove immediately by pressing <backspace>
24. <enter>
expected: nothing changes, because there was no real change in formula
actual: "07:42" reappears in 'B5'
In "Step 4", in is not necessary to paste formula, you can also change call
'A2.A5' by inserting "1.2.06"; results for cell 'B5' will be the same.
Al that will also work for other 'Locale Setting', for example "English" with
date format like "01/02/06"
---------------------------------------------------------------------
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]
