Re: Alphabetizing when using a spread sheet as an index for parts storage.
Hi Vincent, Vincent Juliano schrieb: 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. Then you have only sort the second column and not the whole data range. 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? "first column"? For to get sorting based on the second column, and for to be able to insert and delete records, do this: Mark the whole data range including column labels (=field headers) and an additional empty row at the end of the date. The empty row is needed, because you can only insert a row above the current row, not after the current row. Name this data range via menu Data > Define Range. Click the "More" button and check the options "Contains column labels" and "Insert or delete cells". The later provides, that the address of this data range is adapted automatically, so that you always get the correct range, when you use its name. If the data range is no longer selected, select it via menu Data > Select Range. Then use menu Data > Sort. In that dialog choose the label of the second column. Then set the other needed sorting options in that dialog. After you have insert a record (=row) in the data range, set cursor into the data range and use menu Data > Refresh Range. Now your data range is sorted again with the same initial settings. Kind regards Regina - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
RE: Alphabetizing when using a spread sheet as an index for parts storage.
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
Re: Alphabetizing when using a spread sheet as an index for parts storage.
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
Re: Alphabetizing when using a spread sheet as an index for parts storage.
Regina, It was a great help. thank you Vince On Sep 23, 2013, at 4:09 PM, Regina Henschel wrote: > Hi Vincent, > > Vincent Juliano schrieb: >> 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. > > Then you have only sort the second column and not the whole data range. > >> >> 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? > > "first column"? > > For to get sorting based on the second column, and for to be able to insert > and delete records, do this: > > Mark the whole data range including column labels (=field headers) and an > additional empty row at the end of the date. The empty row is needed, because > you can only insert a row above the current row, not after the current row. > Name this data range via menu Data > Define Range. Click the "More" button > and check the options "Contains column labels" and "Insert or delete cells". > The later provides, that the address of this data range is adapted > automatically, so that you always get the correct range, when you use its > name. > > If the data range is no longer selected, select it via menu Data > Select > Range. Then use menu Data > Sort. In that dialog choose the label of the > second column. Then set the other needed sorting options in that dialog. > > After you have insert a record (=row) in the data range, set cursor into the > data range and use menu Data > Refresh Range. Now your data range is sorted > again with the same initial settings. > > Kind regards > Regina > > - > 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