openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maurice Howe" <maur...@stny.rr.com>
Subject RE: Alphabetizing when using a spread sheet as an index for parts storage.
Date Mon, 23 Sep 2013 20:48:10 GMT
I think all (most?) spreadsheet programs require that you select [highlight]
the entire range of data to be sorted (which may or may not be the whole
spreadsheet), then click DATA, then SORT, then tell it which major/
intermediate/ minor columns to use, then press ENTER.  If you simply select
a column and do SORT, it will sort THAT column only, leaving the rest of the
data as was.  (Why?  Because that might actually be what you wanted to do.
In most cases, including yours, it isn't.)  The same logic applies to
sorting TABLEs when using the TEXT part of OpenOffice.

Yes, you can give the range a name but it's so simple to do the above.

Maurice Howe


-----Original Message-----
From: Vincent Juliano [mailto:vjuliano@optonline.net] 
Sent: Monday, September 23, 2013 3:15 PM
To: users@openoffice.apache.org
Subject: Alphabetizing when using a spread sheet as an index for parts
storage.

In using  a spreadsheet , using two columns where the first column contains
the part description and the second column indicates where the part is to be
found alphabetizaation was tried..

This feature hasn't been used in quite some time. When activated the
alphabetizing is done using the SECOND column.  This puts all the part
descriptions in chaos but the placement in alphabetical order.

To accomplish the alphabetization properly the parts list was cut and placed
in the second column behind the position the part is to be found. 

It works and then the columns are then changed into proper placement and all
is well.

It's necessary to upgrade the spreadsheet because of constant additions and
removals.  

What is the necessary procedure to get the alphabetization of the
spreadsheet based on the first column?

Thank you

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3408 / Virus Database: 3222/6691 - Release Date: 09/22/13


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message