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:vjuli...@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-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@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-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
