To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=61477
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'er' |'er,rainerbielefeld,ufi'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P2 |P3
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Feb 1 07:31:47 -0800
2006 -------
I checked with "2.0.1 RC5 German version WIN XP: [680m1(Build8990)]" and also
with "1.1.4 (German) WIN XP: [645m52 (Build 8824)]" (only random samples):
Indeed, there is some unexpected behaviour, pls. see my testkit.
In a Table with
A1 B1 C1 D1
-12.345.678,00 € -12.345.678,00 € 456789 23.08.50
Where 'A2=A1' and D1 = same content as C1, but formatted as Date
1. Creating B1 after inserting and formatting value A1 will transfer format from
A1 to B1. But if you create B1 (=A1) and insert value and format to A1
afterwards, A2 will not use A1-Format. That is unexpected
1a. Try similar in a new spreadsheet, but insert '=A1/2' to B1. Now only value,
but no format will be transferred.
2. Mark C1, Copy (<cntrl><v> of from menu), mark B1 and "Paste Special" only
format. Format will remain. Might be that "unformatted = nothing" to paste,
But
3. Now Paste Special to A1, and A1 will become "unformatted". That's really
really unexpected because of different result to '2.'.
Now try As in '2.', but with contents of D1. Funny thing, here B1 will get
format from D1 ....
4. Mark B1 , use "Menu - Format - Cell", and you will see "Number - standard"
(screenshot!). That's unexpected, because you see that it's not Standard, but
Currency.
The format transfer for '=A1' might be comfortable, and all that might be
comfortable from time to time, required for MS-compatibility, but it's really
worrying and it really sometimes drives me crazy using OOo, because I normally
do not want to have the format transferred by formula.
I believe there might be good reasons for the behaviour as it is, but it seems w
need a special chapter "formatting transfer" or similar in HELP.
I will leave it as DEFECT for first, may be someone might change it to task
(Online Help) or enhancement after further tests.
There are no format brush problems.
---------------------------------------------------------------------
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]
