2008/5/18 NoOp <[EMAIL PROTECTED]>: > On 05/15/2008 09:47 PM, Reza Pribadi wrote: > > Dear Sir/Madam, > > > > I don't know where I must send this email. My name is Reza Pribadi > > and I live in Jakarta I have a question about OpenOffice Calc. I have > > a data. And I make with autofilter (in Excel and OO Calc). When I > > want to search, I see a different search. Example in below: > > > > > > In Excel in > > OpenOffice Calc > > > > When I click the Product in Excel, I saw only 3 product, because this > > product is true belonging my Customer, Berlico. (This condition where > > I want). But when I click the Product in OO Calc, I saw many product, > > where truly this product not belong my customer, Berlico. (I don't > > want for this condition). > > > > How I can make this condition in Openoffice Calc. same condition with > > excel?? In another word, only product must show belonging customer > > buy. I apologize if my English is not good. Please help me. Thank you > > for your attention. > > > > Hello,
I have recently seen a similar issue with autofilter for a file imported from Excel. Make sure you remove any custom defined ranges as this is what very often causes the problem. 1) remove the autofilter Data > Filter > Autofilter 2) Remove any pre-defined range Data > Define Range then select any range in the list and press Delete. 3) try the auto filter now Data > Filter > Autofilter Cheers, Michele
