I mean big tables, and not just rows. Full blown cross tabulated tables (think about 20 rows and 30 columns, the sort of thing you generally do not see on websites, because they are difficult to present. There is not an opportunity to not display them in this size. I need examples where people have taken a large table and have presented so a user can navigate the table quickly.
The google docs spreadsheet is a nice implementation.
some features of DataTables library are vertical scrolling and freezing a column: http://datatables.net/extras/fixedcolumns/
Wordpress plugin: http://wordpress.org/extend/plugins/wp-table-reloaded/
- Static tables: I see NYTimes has a great example of improving usability of a large table: http://www.nytimes.com/interactive/2010/11/07/weekinreview/20101107-detailed-exitpolls.html
- "Elastic lists" from my comment below: I've noticed the author published them as an open-source library, see http://well-formed-data.net/archives/510/elastic-lists-revisit-open-source
- Complex filtering: Tableau Public has some nice examples:
- filtering already displayed data/columns: http://www.tableausoftware.com/public/gallery/spending-president (Filter Spending option is really cool)
- pre-filtering: http://www.tableausoftware.com/public/gallery/mish-pe-ps-pb
I cannot give you examples in web, but spreadsheet programs have solved your issue with "freezing panes". You could add functionality to freeze columns and/or rows. This give users the choice of what to see from the table.
And if you are feeling Xtreme, you could add several layers of freezing panes so that your users could see rows 1, 35, 99, and 156 side by side, and columns 1, 56, and 178 side by side: a nice 4x3 matrix. :)
As to controls, it would be awesome if users could drag thick black lines from left/right and top/bottom page margins and drop them on a row/column separator to freeze columns to the left/right or rows above/below.