Issue 17998 - incorrect sorting of database rows
Summary: incorrect sorting of database rows
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-07 23:37 UTC by philmperry
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description philmperry 2003-08-07 23:37:37 UTC 
If you choose just one cell in a column and then ask for a sort, two bad things
happen: 1) it sorts on the first column, not the selected column, and 2) all
rows are included, including the header row. If the user selects all the data
cells (rows and columns) to sort, only the one column is sorted, not the entire
set of rows.
Comment 1 philmperry 2003-08-07 23:55:07 UTC 
The following problem (in OOo 1.1 Beta2) may have something to do with
the sorting issue I described above: per an online course teaching
Excel, I'm trying to sort a mix of 5 digit (nnnnn) and 9 digit
(nnnnn-nnnn) US postal ("zip") codes. Not surprisingly, a request to
sort, sorts the 5 digit codes first as numbers and then the 9 digit
codes as text. OK, so define a second column with each cell is
=LEFT(Ax:5) and try sorting that -- result, the same sort as with only
the first column (5 digit then 9 digit, numeric then text). What might
be happening is that as described before, sorting is always done on
the first column (if just click on second column).
Comment 2 frank 2003-08-08 10:21:12 UTC 
Hi,

the sort functionality works as expected. Try to use the 'sort colum'
dropdown box in the dialog and make you familiar with the Options tab
page in the Sort dialog. 

Also make sure your using the correct addressing (absolute / relative)
in the formulas you are using.

Frank
Comment 3 frank 2003-08-08 10:21:44 UTC 
closed worksforme using OOo1.1RC2