David Blomstrom wrote:
I have X11 and OpenOffice installed on my MacBook Pro now, and everything seems
to be working OK. My first question about OpenOffice's spreadsheet concerns the
sort function.
On Excel, you can simply highlight a column and sort, with every column to the left and
the right adjusting accordingly. For example, you could highlight column 7, then choose
"Sort by" column 76, then by column 2 and then by column 16. This is obviously
very convenient when doing a lot of design and analysis.
On OpenOffice's Calc spreadsheet, it appears that I have to highlight
EVERYTHING that I want to sort. If I click on a single column, I can sort that
column only. If I highlight three columns, those three columns are sorted in
relation to each other, but all the other columns are left behind. This is
inconvenient if I have to sort a large range of rows or columns, rather than
the entire spreadsheet. For example, if I want to sort the first 500 rows of
columns 3 through 27, then I have to highlight all the columns for the first
500 rows.
Is there another way to sort columns with Calc, or is that it? If that's it,
does anyone know of any other spreadsheets that have Excel's multi-sorting
ability? Thanks.
____________________________________________________________________________________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
I find that it works somewhat similar to Excel in that, if you have a
cell selected in a block of data, it will select the entire data range,
then issue a dialog box giving you sort options.
Using the A-Z/Z-A menu will select the data range that the selected cell
is in, but will not invoke the dialog. It will sort that data range by
first column in the data range.
TomW
WinXP SP2 OO 2.1
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
