open office software SPREADSHEETS
I will gladly pay for help. nearly 2 hours spent on - 1. How to sign on to a Forum in order to ask a question on Forum re spreadsheets. No success. 2. found some “answers”. without signing on. See #1 3. The question was about how to sort data in Col A 4. I have used other features with success. J.Clipper clip...@casema.nl - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open office software SPREADSHEETS
Dear Alan and David, I finally got it. I highlighted all the rows by scrolling from top to bottom in col A. Row numbers were highlighted. Clicked on data-sort and voila, it worked. Thanks for your patience. > On Oct 24, 2019, at 9:25 PM, Alan B wrote: > > Do you want to sort data in column A -or- sort entire rows using column A > to order the rows? > > The two operations produce different results. > > I posted a video on YouTube ages ago showing these operations. The > interface is changed a bit since but the ideas, select what you want to > sort, then sort, haven't changed. > > If you want a look, check here... Sorting a table in a spreadsheet, > https://www.youtube.com/watch?v=RjTgDyNqqQY > > If it doesn't address your issue, post back with a bit more detail. > > On Thu, Oct 24, 2019 at 10:29 AM John Clipper > wrote: > >> I will gladly pay for help. >> >> nearly 2 hours spent on - >> >> 1. How to sign on to a Forum in order to ask a question on Forum re >> spreadsheets. No success. >> >> 2. found some “answers”. without signing on. See #1 >> >> 3. The question was about how to sort data in Col A >> >> 4. I have used other features with success. >> >> J.Clipper >> >> clip...@casema.nl >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> > > -- > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open office software SPREADSHEETS
Dear David, I have been to the link you provided via Google . No mention of SORT. Also I have never seen the TABLE 1 title appear on a spreadsheet. Perhaps it’s from an older version. I am now going to check out Alan’s utube presentation. Thanks > On Oct 24, 2019, at 5:11 PM, David Belina wrote: > > Wiki.openoffice.org has this: > > The first step in sorting data is to select the data that you want to sort. > To sort the data in Table 1, select the cells from A1 to G16—if you include > the column headers, indicate this in the sort dialog. Use Data > Sort to open > the Sort dialog. You can sort by up to three columns or rows at a time. > > the link is: > > https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide > > On October 24, 2019 at 8:30:01 AM, John Clipper (clip...@casema.nl.invalid) > wrote: > > how to sort data in Col A - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
PROBLEM
Apache too big to have a help line? I have a spreadsheet - 8 columns. All cols contain data. When I print spreadsheet - result 7 cols on page 1 col 8 on page 2. Any solution available? John - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
SORT FEATURE
I am on the page to select sort criteria. In the input field to select sort criteria there is in the field COLUMN D I can’t change it to COLUMN A J. Clipper clip...@casema.nl - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
