Autofilter - number of rows limitation?

hhougs · Newbie Joined: 02 Nov 2006 Posts: 1

Does anyone know what the limit for number of rows to be autofiltered in Calc (OO v.2) is (if any)?

Thank you in advance
Hhougs

Villeroy · Posted: Thu Nov 02, 2006 7:33 am Post subject:

A1: Header
A65536: 1
Select A1:A65536
Data>Filter>AutoFilter
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Nico57fr · Newbie Joined: 05 Feb 2007 Posts: 2

Hello!

Are you sure of that?

Because I have a problem :

I have applied an AutoFilter on my sheet, and clearly, it only filters the 235 first rows Sad

The rows after the 235th are always shown, even when I apply a filter and they should not be shown...

Any idea?

Thanks a lot!

Nicolas.

EDIT : It seems that when I remove the filter, and put it again, it works ?!?
EDIT 2 : I think I have found. So if someone has the same problem : it seems that we must not just do "Filter -> AutoFilter", but we must before select ALL THE ROWS on the columns we want to apply the filter to...

Villeroy · Posted: Mon Feb 05, 2007 2:54 pm Post subject:

You have applied a filter to range A1:X235.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Nico57fr · Newbie Joined: 05 Feb 2007 Posts: 2

Villeroy · Posted: Tue Feb 06, 2007 1:09 pm Post subject:

The filtered range in both aplications defaults to the selected range or the current region around the active cell.(rectangle of adjacent non-empty cells)
Excel may extend the current region on each application of the filter. I don't know, but this would make sense. This is my preferred way to handle database-like lists in Calc:
1. General Settings:
1.1 Two shortcuts for insertion and deletion of entire rows.
Tools>Customize>Keys group:"Edit, function:"Delete Rows" and group:"Insert, function:"Insert Rows" (I use Ctrl+Del and Ctrl+Ins)
1.2. Tools>Options>Calc>General:"Extend references on insertion..."
2. Database Range:
2.1. Define a named database range: Select data and header, call Data>Define...
2.2. Apply a colored top border to the first row below the range.
When you insert a new row, the range will expand, even if you insert one row below the last row (1.2). The colored line moves with the end of range.
Data>Refresh will refresh the last applied sorting, filtering and/or subtotals. If it is a range, imported from a data-source, the data are refreshed as well.
Database ranges allow you to define more than one refreshable range per document.
There is a glitch when you filter/sort/subtotal by selection or current region without specifying a named database range explicitly. Calc creates a named database range "unnamed", which is hidden from the GUI unfortunately. This database range from selection moves to the place where it is needed, so you lose the sort/filter-description in the previous range. To make things worse, "unnamed" is a localized name ("unbenannt" with german GUI). =HYPERLINK("#unbenannt") selects that ghost-range.
Replace "unbenannt" with english "unnamed" or the equivalent in your language.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org