I don’t use spreadsheets much, and when I do it’s usually LibreOffice Calc, but today I came across Index and Match which described the INDEX and MATCH spreadsheet functions and that looked handy so I thought I might make a note!
I was reading about Abstraction inversion on Wikipedia which mentioned the anti-pattern of “using spreadsheet lookup functions to replicate the functionality of a database”.
I don’t know how it happened but suddenly I found I had this annoying situation in LibreOffice Calc whereby there were “dashed lines” repeating regularly throughout my sheets. Turns out it was display of page breaks. Anyway I found this and the solution was:
Tools ▸ Options ▸ LibreOffice Calc ▸ View ▸ Visual Aids ▸ Page breaks