Unfortunately, I already tried that and it didn't work. I also tried turning off the filter, manually selecting the rows I wanted filtered, and then clicking the autofilter again, and still no dice. Any other ideas? Thank you,
Robert >>> Jonathon Coombes <[EMAIL PROTECTED]> 10/29/05 4:44 PM >>> On Fri, 2005-10-28 at 17:15 -0500, Robert Volke wrote: > I had the same problem as this individual but I did not have blank rows > where it stopped sorting the records. It was just the point at which I > started using OpenOffice to add new rows, these new rows would not > filter with the autofilter. I even tried selecting the range of cells I > wanted filtered, then clicked auto-filter, and still the new rows did > not filter properly. Any suggestions? Thank you, Hi Robert, I take it you had already applied the autofilter and then added new rows and these were not affected when you changed the autofilter? This is logical, and should be easily overcome by simply turning the the autofilter off and then on again so that it selects all the data including the new rows. Regards Jonathon > >>> Jonathon Coombes <[EMAIL PROTECTED]> 10/28/05 2:55 AM >>> > On Thu, 2005-10-27 at 11:00 +0200, Henk ter Heide wrote: > > Hi, > > > > Last week I posted (at least, so I hope) a question about the > autofilter in > > Calc. Since then I received hundreds of messages but no answer to my > > > question. The problem is that when I apply autofilter it only works > on part > > of the data, i.e., those that were originally entered in Excel on > another > > computer before I copied the file to this computer. It does not > filter the > > new data I added after copying the file to this computer and opening > it > > (this computer not having Excel) with Calc. All cells have the same > format, > > i.e. text in the case of the columns I want filtered. Since filtering > > > spreadsheets is one of the most important things I want to do with > > OpenOffice I will be most thankful for any advice. > > The autofilter is "intelligent" in that unless you select the > required data to be worked on, it will choose the first > non-contiguous block. That is, it will choose the data from the > first row down to the first blank row. If you have data below > that blank row, you need to select it to be filtered. > > Alternatively, you should try the standard filter. -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
