Filtering in Calc: Data->Filter->AutoFilter

[disko]

I use NeoOffice 2.2.2 Patch 0 on Mac.

I try to use the AutoFilter in Calc. I selected the area with which I would like to use the filter, but it only filters part of the area. After activating the AutoFilter the dropdown menus at the top of the columns work.
I can select some of the things from the dropdown menus, that I have down there in the columns, but not all.

The thing works for 846 rows from the top. I don't know what happens then. But from there on, everything remains unfiltered. And all the writings in the columns that appear for the first time after the row 846, do not appear in the dropdown menu. As if it automatically wouldn't include the things below row 846 into the filtering.

It is the same for OpenOffice (I tried on another computer) - the filtering works until the row 846 and not with the rows that come below (starting from row 1).

Is this an OOo bug or am I doing something wrong?

[jgd]

I can't reproduce your problem with a Calc document with more than 2000 rows.
What sort of data do you try to sort?

Jacqueline

[disko]

I have a spreadsheet about my incomes and expenses. So I have the date column, then the description of what I spent my money on or what I received it for, then the amount, then some more dates (e.g. when the money transfer was made in the bank), then a category (e.g. food etc).

When I use the filter, then I select all the data.
I was wondering that perhaps the program has a limit on how many different units there can be in a dropdown menu at the top of the column, when I filter things. My spreadsheet starts from the beginning of the year and the interesting thing (perhaps a coincidence) is that the filtering stops (the row 486) at the end of July. So all the things that have happened after 1st of August are not filtered .

[jgd]

[disko]

[jgd]

Did you insert some special data in row 847? Or some new date or new data format?
Can you try to open a new Calc document and copy/paste into it your data from row 847 to the end and try to filter them?

Jacqueline

[disko]

I copied about 20 rows above row 846 and about 20 rows below that row and pasted it into the new document. I can filter all those rows and everything works fine.

I also tried this kind of thing that I left out some last columns and copied most of the table (all the rows) into a new file - then the AutoFilter works all the way down to the end of the table. If I select only these columns in my original file and just leave the last columns out of the selection then it AutoFilters only until the row 846. The same thing happened even if I created an empty column between the selected columns and some last columns (so it would no way want to include the last columns into the filtering) - it only AutoFilters until row 846.

[jgd]

Maybe your document has been, for some reason, corrupted. This sort of thing happens to me from time to time (fortunately, it's rare), without any evident cause.
if you wish, you can send me the file (I'll PM you my e-mail address). I'll test it on my machine. Of course, if you think that your file is a sensitive one, I'll understand you very well.

(I don't read Estonian )
Jacqueline

[disko]

I thought I'll send you this worksheet. As I have many worksheets in this file, I figured I'll copy this one worksheet into a new document and I'll send you this one worksheet. But - after I copied this worksheet, I tested the whole table (all the columns) with AutoFilter, and it worked!

So I copied all the other worksheets also into this new document and now I have it just like the previous file, only that the AutoFilter works

So I guess there was some kind of corruption in this file, that I wasn't aware of and now I can just delete the previous file and use the new one with all my data and the possibility to AutoFilter

Thanks!

[jgd]

Happy to hear that your problem is resolved
That sort of "corruption" is rare and it's not easy to know why it occurs, at least it's not easy for me

Jacqueline