On Thu, 2005-06-16 at 23:57 -0300, marcus wrote: > Hello, the text below describes my problem: > > Take, as an example, a sheet with two columns labeled 'First' and Second'. > Both columns have three rows containing numbers 1, 2, 3: > > First | Second > 1 | 1 > 2 | 2 > 3 | 3 > > - Activate autofilter on the column headers. > > - For column 'First' select '1' from the autofilter dropdown list. Now > only > one row is displayed in the sheet: 1 | 1 > > - Examine the autofilter dropdown list for column 'Second'. Notice that > all > three values (1, 2, 3) are displayed, even though, logically, there is only > one row in the active result set and only one possible choice for the > value of > column 'Second' (the value 1) given the active filtering on column > 'First'. > Selecting anything other than the value '1' in the second column > dropdown list > results in a null result (no matching rows). > > In Excel, autofilter dropdown lists only show the possible values based on > already-active filtering, so that it is not possible to return a null set. > For example, in the above demonstration, clicking on the 'Second' column > autofilter dropdown arrow would present a list with only one item: '1'. In > other words, Excel bases its autofiltering on the active result set, not > the original dataset/table.
Yes. This is what is sometimes called a "cascading" filter method. This is how MS Excel does it, but not OpenOffice.org yet (at least till version 1.9.104). > Ok, I really need this active behavior, so there's some way of create > this effect? By scripts or something?? There may be one already, but have not seen any. You can try some places like www.oooforums.org or www.ooomacros.org to see. Regards Jonathon -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
