Thanks Nic, I always appreciate your explanations. Jürgen > Am 15.01.2015 um 12:54 schrieb Nicholas Parsons > <mr.nicholas.pars...@gmail.com>: > > And of course once you open the context menu one of the first few options is > “Sort ascending”, and the next is “Sort Descending”. Those are for sorting > rather than filtering. You do not need the submenu for the sorting options, > only the filtering options. Sorry if that explanation was not needed, just > thought I’d add it so it’s clear for anyone that’s interested. > >> On 11 Jan 2015, at 4:26 am, Jürgen Fleger <apple-engl...@fleger.net >> <mailto:apple-engl...@fleger.net>> wrote: >> >> OK, thanks for your answer. That was very clear to me. Now I’m able to >> figure out more. >> All the best >> Jürgen >> >>> Am 10.01.2015 um 15:55 schrieb Phil Halton <philh...@gmail.com >>> <mailto:philh...@gmail.com>>: >>> >>> Yes, VO does not always speak the initial list of row/column headers when >>> you first enter the headers. But, arrowing up or down will speak either row >>> or column header. anyway, once you have your desired column selected and >>> have brought up the context menu, you have those sort and filter options as >>> you said. The context menu entry called “sort and filter options” is just a >>> heading for options that are listed below it. >>> Below sort and filter options you will find “filter table” which is a >>> submenu. in that submenu, you will find a listing of all the unique data >>> found in the selected column. If you press VO spacebar, or enter on any of >>> these entries, Numbers will filter the table showing only those rows that >>> contain the filtered data item. >>> For example, a table with a column containing the name of the month could >>> be filtered to show only “January” entries. >>> This is a shortcut method of filtering the table which can also be done in >>> the sort and filter inspector, where you can specify more sophisticated >>> filter rules. >>> Check out the sort inspector after you do this shortcut filtering method >>> and you’ll see that numbers created a rule to produce the filter you >>> selected in the context menu. You can add to it, modify the rule, or delete >>> all or part of it etc. >>> It’s important to know that once you’ve filtered a table, you can’t use the >>> VO arrow keys. you have to use the arrow keys by themselves to see the >>> filtered table rows/columns. If you use the VO arrow keys, Numbers will >>> show you the unfiltered table entries along with the desired filtered data. >>> >>> >>> >>> >>> >>>> On Jan 10, 2015, at 5:13 AM, Jürgen Fleger <apple-engl...@fleger.net >>>> <mailto:apple-engl...@fleger.net>> wrote: >>>> >>>> Hi Phil, >>>> >>>> I didn’t want to dought your instructions. I’m sorry if I raised this >>>> impression. I find it very useful if people take the time to answer very >>>> detailed. Thanks for that. And I agree, to assume people know to press >>>> Enter is something you can expect. >>>> >>>> What I find confusing: >>>> 1. My VO doesn’t anounces wether the column is highlighted or not. >>>> 2. After choosing a column I can open a context menue. There’s an entry >>>> called something like „Sorting and filter options“. I translated this >>>> entry name from german and so it might be a little bit different in your >>>> context menue. If I press on this entry nothing happens. Do you know >>>> something about this functionality? >>>> >>>> All the best >>>> Jürgen >>>> >>>> >>>> >>>>> Am 09.01.2015 um 15:59 schrieb Phil Halton <philh...@gmail.com >>>>> <mailto:philh...@gmail.com>>: >>>>> >>>>> Yes, I use V3.5 (2019). I don’t know what your question is, all I said >>>>> was that you could sort up or down (high or low or whatever you want to >>>>> call it). I detailed the method I use for sorting table rows using a >>>>> specific column as the sort key. I also showed how I sort subsets of rows >>>>> and columns. You can also use multiple sort keys. So, what method are you >>>>> saying doesn’t seem to work? Did you forget to press enter or VO space on >>>>> the header selections? You know after entering the headers and arrowing >>>>> down to either row or column headers, did you first press enter before >>>>> trying to arrow right or left to the specific column header to use? It’s >>>>> the only thing I can think of that you might have not done. I re-read my >>>>> message and that’s the only thing I left out. I just assumed people knew >>>>> that sort of thing. >>>>> >>>>> >>>>> >>>>>> On Jan 9, 2015, at 4:36 AM, Jürgen Fleger <apple-engl...@fleger.net >>>>>> <mailto:apple-engl...@fleger.net>> wrote: >>>>>> >>>>>> Hi Phil, >>>>>> did you try this method in Numbers version 3.5 (2109)? I’mnot quite sure >>>>>> but it seems not really to work that way anymore. All I can do is >>>>>> sorting up or down. But if you could try it out and tell wether it >>>>>> worked still for you in this version of Numbers it would be a motivation >>>>>> for me to play around a little more. >>>>>> Thanks and >>>>>> all the best >>>>>> Jürgen >>>>>> >>>>>> >>>>>>> Am 08.01.2015 um 21:51 schrieb Phil Halton <philh...@gmail.com >>>>>>> <mailto:philh...@gmail.com>>: >>>>>>> >>>>>>> In numbers, I sort table rows/columns by the following method. I don’t >>>>>>> know if this will work the same with a selection, but it might. A >>>>>>> little experimentation will tell the tale. >>>>>>> >>>>>>> for sorting tables by row or column. >>>>>>> 1, position VO anywhere in the table and press VO Shift Vertical bar >>>>>>> (the key above the return key). >>>>>>> 2, Press VO down or up arrow to select whether to work in rows or >>>>>>> columns. >>>>>>> 3, VO right or left to select the desired column heading, or up and >>>>>>> down to select the desired row heading, and press VO space to select it. >>>>>>> >>>>>>> for example, if you wanted to sort by column C, you would arrow down to >>>>>>> Column headers after pressing VO shift vertical bar, then arrow right >>>>>>> or left until you get to Column C and then press VO space to make it >>>>>>> the selected column. >>>>>>> >>>>>>> 4, bring up the context menu with VO shift M. >>>>>>> 5, arrow down through the menu and select the desired sort option. >>>>>>> 6, exit the headers and return to the normal table mode by pressing VO >>>>>>> shift vertical bar again. >>>>>>> >>>>>>> This procedure sorts the entire table by either rows or columns. To >>>>>>> sort a subset of rows/columns in a table, you would first select the >>>>>>> rows/columns to be sorted, and then go into the sort/filter inspector. >>>>>>> in there you would add the row or column you wish to sort by by >>>>>>> pressing the “add” button, and then you can set sort options in the >>>>>>> scroll area before actually doing the sort by pressing the “sort now” >>>>>>> button. >>>>>>> >>>>>>> I just messed around with this a little and I don’t believe you can >>>>>>> sort just a selection of data in a table row or column. That is, the >>>>>>> entire row or column will be included in the sort action with the >>>>>>> selected field being the sort key. >>>>>>> Hope this all makes sense. >>>>>>> >>>>>>>> >>>>>>>> Hi, >>>>>>>> try to jump to the head of the table at first by pressing VO + Shift + >>>>>>>> ‚. It might be another key combination on english keyboards but you >>>>>>>> might find it yourself. There you can choose wether to jump to column >>>>>>>> head or row head. Then you can open the context menue. >>>>>>>> But in terms of the sorting data entry in the menue I got the same >>>>>>>> results. I wonder wether there’s something broken. >>>>>>>> All the best >>>>>>>> Jürgen >>>>>>>> >>>>>>>> >>>>>>>>> Am 08.01.2015 um 17:53 schrieb Jim Fettgather >>>>>>>>> <jimfettgat...@gmail.com <mailto:jimfettgat...@gmail.com>>: >>>>>>>>> >>>>>>>>> This one really has me stumped. >>>>>>>>> After highlighting a row of numbers to be sorted in either a row or >>>>>>>>> column of numbers, then stop interacting with the table and VO left >>>>>>>>> arrow to the formatter group, because this seems to be where the sort >>>>>>>>> options are located, no matter what I select, the sort now option is >>>>>>>>> dimmed. >>>>>>>>> Evem doing VO Shift M, and then selecting sort options, I am >>>>>>>>> immediately returned back to the spreadsheet. >>>>>>>>> Is there a hidden secrent to be able to sort data in Numbers? >>>>>>>>> Thanks. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "MacVisionaries" group. >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>> send an email to macvisionaries+unsubscr...@googlegroups.com >>>>>>>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>>>>>>> To post to this group, send email to macvisionaries@googlegroups.com >>>>>>>>> <mailto:macvisionaries@googlegroups.com>. >>>>>>>>> Visit this group at http://groups.google.com/group/macvisionaries >>>>>>>>> <http://groups.google.com/group/macvisionaries>. >>>>>>>>> For more options, visit https://groups.google.com/d/optout >>>>>>>>> <https://groups.google.com/d/optout>. >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "MacVisionaries" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>>>>> an email to macvisionaries+unsubscr...@googlegroups.com >>>>>>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>>>>>> To post to this group, send email to macvisionaries@googlegroups.com >>>>>>>> <mailto:macvisionaries@googlegroups.com>. >>>>>>>> Visit this group at http://groups.google.com/group/macvisionaries >>>>>>>> <http://groups.google.com/group/macvisionaries>. >>>>>>>> For more options, visit https://groups.google.com/d/optout >>>>>>>> <https://groups.google.com/d/optout>. >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MacVisionaries" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>>>> an email to macvisionaries+unsubscr...@googlegroups.com >>>>>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>>>>> To post to this group, send email to macvisionaries@googlegroups.com >>>>>>> <mailto:macvisionaries@googlegroups.com>. >>>>>>> Visit this group at http://groups.google.com/group/macvisionaries >>>>>>> <http://groups.google.com/group/macvisionaries>. >>>>>>> For more options, visit https://groups.google.com/d/optout >>>>>>> <https://groups.google.com/d/optout>. >>>>>> >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MacVisionaries" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>>> an email to macvisionaries+unsubscr...@googlegroups.com >>>>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>>>> To post to this group, send email to macvisionaries@googlegroups.com >>>>>> <mailto:macvisionaries@googlegroups.com>. >>>>>> Visit this group at http://groups.google.com/group/macvisionaries >>>>>> <http://groups.google.com/group/macvisionaries>. >>>>>> For more options, visit https://groups.google.com/d/optout >>>>>> <https://groups.google.com/d/optout>. >>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups >>>>> "MacVisionaries" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send an >>>>> email to macvisionaries+unsubscr...@googlegroups.com >>>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>>> To post to this group, send email to macvisionaries@googlegroups.com >>>>> <mailto:macvisionaries@googlegroups.com>. >>>>> Visit this group at http://groups.google.com/group/macvisionaries >>>>> <http://groups.google.com/group/macvisionaries>. >>>>> For more options, visit https://groups.google.com/d/optout >>>>> <https://groups.google.com/d/optout>. >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "MacVisionaries" group. >>>> To unsubscribe from this group and stop receiving emails from it, send an >>>> email to macvisionaries+unsubscr...@googlegroups.com >>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>> To post to this group, send email to macvisionaries@googlegroups.com >>>> <mailto:macvisionaries@googlegroups.com>. >>>> Visit this group at http://groups.google.com/group/macvisionaries >>>> <http://groups.google.com/group/macvisionaries>. >>>> For more options, visit https://groups.google.com/d/optout >>>> <https://groups.google.com/d/optout>. >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to macvisionaries+unsubscr...@googlegroups.com >>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>> To post to this group, send email to macvisionaries@googlegroups.com >>> <mailto:macvisionaries@googlegroups.com>. >>> Visit this group at http://groups.google.com/group/macvisionaries >>> <http://groups.google.com/group/macvisionaries>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com >> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >> To post to this group, send email to macvisionaries@googlegroups.com >> <mailto:macvisionaries@googlegroups.com>. >> Visit this group at http://groups.google.com/group/macvisionaries >> <http://groups.google.com/group/macvisionaries>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To post to this group, send email to macvisionaries@googlegroups.com > <mailto:macvisionaries@googlegroups.com>. > Visit this group at http://groups.google.com/group/macvisionaries > <http://groups.google.com/group/macvisionaries>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>.
-- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
