Google Sheets (part of Google Drive) has a convenient feature called frozen rows (and columns) that allows to specify (nowadays unlimited number of) rows that’ll be the header of any kind you want that are ignored during sorting, and at least some other features; take my spreadsheet for example. What is LO’s equivalent ? As far as I know and see, LO and OOo alike don’t have anything like that, instead the rows you wanna use as headers get dragged into sorting results.
LO5 preferably, although it doesn’t really matter to me cuz I’ve never seen such feature.