To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96274
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
URL|http://k1.dyndns.org/bugs/|
|buggysort.ods |
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Platform|Macintosh |All
--------------------------------------------------------------------------------
Summary|Sorting simple ASCII Text |Cell contents eremains num
|vertically sorts wrong |ber after modification wit
| |h format cell
--------------------------------------------------------------------------------
Subcomponent|code |formatting
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Nov 17 12:54:23 +0000
2008 -------
I checked with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP: [OOO300m8
(Build9357)]" and can confirm the reported effect.
It's not a sort problem, but a formatting issue.
"buggysort.ods SMD.B3" does NOT contain text contents, as you can see when you
insert formula "=B3+1" to 'F3': You will get 74246 as result. If 'B3' contains a
text, result should be "1" (as you can see when you "fill-down" formula).
Contents of 'B3' will be modified to text, if you type "74245" in it again.
That's an old bug or feature (currently I am not sure), content will change from
number to text only after you modify contents.
To repruduce this behaviour:
1. open new spreadsheet
2. Type "1" <Enter> into 'A1'
Numeric data has been inserted as expected.
3. Insert formula "=A1+1" into 'B1'
Result is "2" as expected
4. Menu 'Format -> Cells -> Card "Numbers" - Cat. ' change from "Number" to
"Text" (Format code "@") <Enter>
expected: Contents of 'A1' should be aligned left, result 'B1' should
change to "1"
actual: nothing happens
5. Click on 'A1' and then click into formula input pane (with contents "1")
6. <Backspace> (to delete contents) and type "1" again <Enter>
Now result is as expected in step 4
The problem is that the contents of 'A1' after step 4 still behaves as "number",
although formatting is shown as "text".
If you want you can do the same test with a new document and modified
formatting "Text" for 'A1' before you continue with step 2: see the differences!
I saw some discussion concerning this behaviour several times ago in an issue,
but currently I can't find that issue.
---------------------------------------------------------------------
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]
