On 21/09/2007, JosephK <[EMAIL PROTECTED]> wrote: > > 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?
Thank you. No, of course I didn't :-( -- Harold Fuchs London, England Please reply *only* to [email protected]
