I created an xls file in LibreCalc with 962 rows. Then I made a copy of this xls file and deleted the first 962 rows with the exception of the header with right click > deleted selected rows ( I didn’t just delete row contents). When I open the file again, why does LibreCalc still show me the 962th row instead of the first?
Ok, I just realized librecalc always replicates the same view that was present when I saved the document. Not the last view that I had when I closed the document. So all I needed to do were some fake edits and then save it in my favourite view.