On 08:32 Fri 21 Sep , Harold Fuchs wrote: > On 21/09/2007, Paul <[EMAIL PROTECTED]> wrote: > > > > <snip> > > > Hmm. I find this weird. I'm using OO 2.2.1 on Win XP SP/2. I open a new Calc > sheet and, in column A, I enter the values 1, 2, 1 in rows 1, 2, 3. Then I > do Data>Filter>Standard Filter>More, check the "No Duplication" box and > click OK. **All** the values disappear. This is true even if I sort the data > first. The same happens if I use row 1 as a heading and put the data in rows > 2, 3 and 4. The heading stays but *all* the values disappear. > > What am I missing, please? >
Did you set Column1 = Not Empty in the Standard Filter? Regards, John -- It is often safer to be in chains than to be free. Joseph K --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
