To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96274
User az77 changed the following:
What |Old value |New value
================================================================================
CC|'jbfaure,mhatheoo,rainerbi|'az77,jbfaure,mhatheoo,rai
|elefeld' |nerbielefeld'
--------------------------------------------------------------------------------
------- Additional comments from a...@openoffice.org Mon May 24 21:35:12 +0000
2010 -------
I've just encountered the same problem, sorting data, in Ooo 320 m12 (build
9483).
(On Linux.)
As the first comment by "rainerbielefeld" indicates, it's a format issue.
(See his analysis of the problem.)
A number nominally reformated as text is still formated as a number, and is
sorted as such.
One must re-enter the data to translate it to the text format.
There are similar problems with certain text being automatically formated as
dates.
Changing the format to something else (for example if it were a postal code or
currency in some locales) produces a weird number which has nothing to do with
the value entered.
Seriously, the value displayed, when reformated, should only change its visual
presentation and treatment, while retaining its association with the value
entered.
I.e., be treated as number if nominally formated as a number, but if reformated
as text, be treated as text in every respect, and continue to display the same
value.
Similarly, a date should retain its value as entered, if changed to another
format.
If this means reformating the stored value, so be it.
(It might mean that, for items like dates, that the value entered should be
retained, as least for the session when entered, to allow the user to correct
automatic formating errors.)
Anything else is counter-intuitive at best.
Unlike the comment by "er" following that of "rainerbielefeld", changing the
format stored is *exactly* what I would expect.
IMO, this is a serious flaw in Ooo.
It gets my votes.
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
