openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vincent Juliano <vjuli...@optonline.net>
Subject Re: Alphabetizing when using a spread sheet as an index for parts storage.
Date Mon, 23 Sep 2013 22:48:51 GMT
Maurice.

Thank you. Data-sort-column A --OK

It is so easy I'm embarrassed.

Thank you



> 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
> 


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


Mime
View raw message