I had a similar instance with a co-worker's spreadsheet I was trying to
help her with. The Autofilter wasn't working quite right, although I
don't think it's exactly the problem you're describing, but similar.
What I found got it working right was to copy all of the data, open a
new Calc file, and paste the data into the new file. I could never
figure out why things weren't working like they should in the original
file, but this did the trick. Probably a long shot that this will be
your solution, but it's easy enough to try that it's worth a shot.
Dick, Webster, NY
-----Original Message-----
From: Robert Volke <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; [email protected]
Sent: Mon, 31 Oct 2005 09:19:43 -0600
Subject: Re: [users] Autofilter
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
