Besides using conditional formatting, is there any way in LibreOffice Calc (or OpenOffice Calc) to highlight every other row in order to make the spreadsheet easier to read?
LibreOffice has a serious bug that causes multiple errors when the typical conditional formatting technique ISEVEN(ROW())
is used to attempt this task and then rows are copied or moved. I found a LibreOffice bug report on this issue, but the bugs are still present.
Best Answer
I've written a macro in StarBasic back in 2004, which applies alternating colors to used cells (still working with LO 5.2.2.2 i use as of today). I hope the source is well documented to let you find the color definitions, if you like to change them ;-)
Copy the code to a module in your STANDARD library of Basic code, to be available to all CALC documetns. HTH