Linux Today: Linux News On Internet Time.

How to quickly apply color schemes to spreadsheet rows with OpenOffice

Jun 01, 2010, 21:31 (0 Talkback[s])

[ Thanks to M. Fioretti for this link. ]

"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:

1. Remove any already existing background formatting.
2. Create an appropriate cell style with the color that you want as background:"

Complete Story

Related Stories: