• How to quickly apply color schemes to a spreadsheet with OpenOffice or LibreOffice

    How do you quickly create a spreadsheet where, for example, every other line has a background of a different color? Here are a couple of methods.

    The first one is faster (and works even in controlled environments where you can’t install extensions) if you want white rows alternated with colored ones: define a cell style and apply it only to cells in even (or odd) rows. Here is the detailed procedure: