To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57956
User atdsm changed the following:
What |Old value |New value
================================================================================
CC|'atdsm' |''
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Nov 21 11:03:19 -0800
2005 -------
Now that I see what you are talking about, I can see that yes, the behavior is
the same in OOo 2.0. However, this is not a bug. What you are referring to is
the difference between a cell's content, content type, and content formatting.
The cell's content type is date. It's content is 21.11.2005, as per the local
date formatting of you system (german). When you double click the cell to modify
it, it does not change the formatting. Instead, it gives you access to the
content's value (which is independant of formatting).
You may notice that in the .png files you generated the date is displayed as
21.11.2005 in the edit bar, even when it is displayed as 2005-11-21 in the cell.
In other words, you are seeing the unformatted contents (in the edit bar) and
the formatted contents (in the cell) at the same time. When you double click the
cell, then it gives you access to the unformatted contents.
This may be annoying in this case, but it is in general very useful. For
example, what if you have a cell formatted as a year (2005), but you want to
modify the month and day (to January 1st)? You would have to type in 1.1.2005,
which would then change your formatting to "1.1.2005". You would then have to
re-format the cell as year to get "2005" to display again.
Analogously, what if you have a set of numbers formatted to display at 0 decimal
places, but they actually are decimal numbers. For example, 23.837 would display
as "24". Lets say you wanted to change the cell contents to 23.839. When you
double click the cell, you want to be able to access the full contents (23.837),
not just "24". Otherwise, you would have to type all that in again!
So, in all but a very few cases, this is the preferred behavior. MS Excel
handles cell contents the same way.
*Marking as RESOLVED > INVALID
-Steve
---------------------------------------------------------------------
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]
