Issue 60681 - Sorting in table does not work with fields/Numbers
Summary: Sorting in table does not work with fields/Numbers
Status: CLOSED DUPLICATE of issue 33772
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: stefan.baltzer
QA Contact: issues@sw
Keywords: oooqa
Depends on: 49629
  Show dependency tree
Reported: 2006-01-17 05:22 UTC by raindrops
Modified: 2013-08-07 14:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Contains proof for BOTH types of problems described (10.53 KB, application/vnd.oasis.opendocument.text)
2006-10-31 08:22 UTC, raindrops
no flags Details
Table demonstrating a general table sort problem (9.14 KB, application/vnd.oasis.opendocument.text)
2006-10-31 17:47 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description raindrops 2006-01-17 05:22:54 UTC
I have a odt file with 300+ pages. At the end of this document, I have inserted
a table showing "what's new". 

For this, I have inserted temporary bookmarks in the document where there are
changes, and then I have shown page numbers of those bookmarks in this table.

The first column of this table contains fields that show page numbers.

After making the table, I want to sort the table based on the page numbers.
But the page numbers are actually fields, Writer cannot evaluate the value of
the fields and then sort them.

As a result, all entries get randomly sorted.

Desired: Writer should evaluate the fields first and then sort the table.
Comment 1 michael.ruess 2006-01-17 10:20:57 UTC
Reassigned to SBA.
Comment 2 zhanghongbin 2006-01-26 03:23:57 UTC
replicated the bug in OOo2.0 on Windows xp sp2.

1 open new empty writer
2 click "Table"--"Insert"--"Table" from top menu
3 set columns to be 2, rows to be 5 and uncheck the heading option
4 type 5,2,1,4,3 in the first column of each row in the table
5 select the whole table, then click "Table"--"Sort"
6 select the key1, Column 1 and key type as "Numeric" Order as "Ascending"
7 set Direction to "Rows" Then click "OK"

The table doesnot sort based on number.
the result is :3,4,1,2,5. it only reverse the original order

Follow-up tests:

if we do set the key type as "Alphanumeric" then sort.
after that, we can sort the table based on "Numeric"

The bug should be corrected because if user want to sort a big table,
the undesired result will make user crazy
Comment 3 Rainer Bielefeld 2006-10-30 18:41:33 UTC
I checked with "2.0.2  German version WIN XP: [680m5(Build9011)]" and was not
able to reproduce the problem. 

@raindrops, @zhanghongbin 
can you please attach a small and simple sample document to demonstrate the problem?
Comment 4 raindrops 2006-10-31 08:22:50 UTC
Created attachment 40183 [details]
Contains proof for BOTH types of problems described
Comment 5 raindrops 2006-10-31 08:34:38 UTC

I have created the sample using OOo 2.0.4 and the problem is still very much there. 

Changed the summary to reflect that sorting does not work properly woith simply
entered numbers either.

Note that the contextual help file does not describe the difference between
"Numerical" and "alphanumerical" sorting. However, if the cells of a table's
column contain only numbers, both methods should have identical results.

The situation is worse when the column contains numbers that are actually
reference fields: In that case the numbers are sorted in a totally illogical
sequence (neither numeric nor alphanumeric).
The sample contains copies of the same table, in "BEFORE" and "AFTER" scenario.
If you want to repeat the experiment, please copyt the table in a new document
and repeat the step.

Comment 6 Rainer Bielefeld 2006-10-31 13:01:15 UTC
What's your OS / Platform?
I can't reproduce your problem with 'Sorting problems in tables.odt'

Please check whether your problem is the same as in Issue 49629 (I believe it
is), what is fixed for OOo 2.1!
Comment 7 raindrops 2006-10-31 17:04:42 UTC
My system is Win XP, SP-2. I'll check if on NT4 also this behaves the same way
(will be able to do it in two days).

Issue 49629 describes only "part-1" in my attachment; but "part-2" (which is
different)is not described there. My original bug mentions only the reference
fields, but when zhanghongbin added sorting of ordinary numbers; I added that
example as well in my sample (as "part-1"). My bug is actually "part-2" in the

But I don't get it: If Issue 49629 is an accepted AND resolved bug, and its the
target of is 2.1, how come you are unable to reproduce the bug? It should still
be there in 2.0.2!

If you take the table in part-2 of the attachment, are you able to select the
rows 2-5 and sort them such that they are in proper ascending order? Can you
edit my sample file and post it here? Please sort both sample-1 and sample-2.
Comment 8 Rainer Bielefeld 2006-10-31 17:45:05 UTC
I thougt only LINUX would be affected by problem in Issue 49629 - don't ask my
why :-/
So I really do not understand why your first problem was not visible on my PC,
because now I see the you reported bug, "numeric" does not work. Life is full of

It seems that Table sort does not work correctly at all, not only for fields. I
was able to reproduce that with your part II tables and also with small self
created table with only 1 column, pls. see attached 'myowntest.odt'

So I set status to new and ask for verification of the Issue 49629 Fix.
Comment 9 Rainer Bielefeld 2006-10-31 17:47:46 UTC
Created attachment 40197 [details]
Table demonstrating a general table sort problem
Comment 10 stefan.baltzer 2006-11-09 18:02:23 UTC
(0) Biggest problem: This is a collective issue! Please don't mix problems.
Better file seperate issues and set a reference by "...I think this is similar
to issue XYZ..." - Then one can see if it is a duplicate or TWO issues will go
TWO seperate ways (developer to deal with it, target to be set, CWS to
integrate, Tester to verify) this can NOT be done with ONE issue. Thank you for
your comprehension.

(1) The problem with numbers not being not sorted correctly when cell format is
"text" is solved by issue 49629.
(2) The problem with Fields is a different one (I guess it is the same problem
with Find&Replace that can not look into a filelds string, see issue 33772). 
(3) The problem of alphanumeric sorting in sample file "myowntest.odt" is still
there, even in versions with 49629 being fixed. Strange thing is that making up
a new document with the same text in the table does work. 

Please file a new issue for this and use that very bugdoc in there.

I will close this one as duplicate of issue 33772 (Strings in fields can not be
found with "Find&Replace") and put a note concerning sorting in there because I
believe this is "one go" once it gets adressed.

*** This issue has been marked as a duplicate of 33772 ***
Comment 11 stefan.baltzer 2006-11-09 18:03:55 UTC
SBA: Closed.

Please submit a new issue for the problem of alphanumeric sorting in sample file
Comment 12 raindrops 2006-11-10 02:01:19 UTC

I am sorry, but declaring such bugs duplicate is not the correct process. 
First, you are NOT sure whether it's the same cause (you have only suspected 
it). Unless you have located the faulty class/function AND confirmed your 
initial diagnosis, you cannot close down other bugs. That is because closed 
bugs drop out of view. You cannot expect users to track such bugs for years and 
resurrect it if the other bug, when fixed, cannot fix this bug also.

The best way is to declare this bug "depends on" the other bug. That way, once 
the other bug gets fixed, people have to check this bug out. If this is also 
fixed automatically, close it. Otherwise break the link and pursue it 

BTW please remove the "needmore" from the "keywords" field. We have provided 
all the needed proof! 
Comment 13 Rainer Bielefeld 2006-11-10 06:18:10 UTC
I disagree with most of raindrop's arguments concerning advisability of
classifying this issue as a DUP of 33772. That is an issue with very few
comments, so the hint concerning the problem here will be noticed in Issue
33772. Currently it seems very plausible that Issue 60681 and  Issue 33772
describe different manifestations of the same problem, and so it is useful to
handle both problems in one issue. I will close this issue again.

But I doubt whether "Enhancement / Later" is an appropriate classification. Most
users will see that as a bug and not as a "missing feature", and we need a clear
target definition when this function will be added.

I will file another issue with a request to mention current limitations in HELP,
and of course for the 'myowntest.odt' problem.

*** This issue has been marked as a duplicate of 33772 ***
Comment 14 Joe Smith 2006-12-07 23:28:23 UTC
[-- This comment also added to Issue 49629 --]

> - General alphanumeric sort order problem 
>   Attachment issue 60681 'myowntest.odt'

This is INVALID.

The problem with sorting in the sample document is that the Table properties >
Text Flow > Repeat heading is set to 1. This causes the sort operation to
exclude the first row from the sort. It is a mere coincidence that the
descending order example happens to work. If you change the data order so that
the first row must move, then the descending example produces wrong results as well.

See further comment under Issue 48164.
Comment 15 Rainer Bielefeld 2006-12-08 06:19:26 UTC
So it is, Issue 48164 files one aspect of the "heading handling" (what is
completely different from the original issue report), Issue 71424 an other one.