Excel 2003 called them lists, later versions call them just tables. Excel can turn a simple table to a nice sortable list by selecting rows and columns and then going to Insert > Table. Excel would create something like shown in the screenshot below.
Nifty. How can I do the same thing in Open Office's calc? Note That Data -> Filter does not quite the same. It looks similar, but once you apply the filter it only SHOWS those records that suit the filter. Excel 2003 and later versions have some really ugly compatibility issues here – so it´d be helpful to get around this in OO.
EDIT: Note I looked into the Data > Sort option. It's basically what I want, but I just wonder how to mimmick those Excel Lists / Tables.
