blog:zebra_striping_in_libreoffice:openoffice
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
blog:zebra_striping_in_libreoffice:openoffice [2011-03-08 17:07] – created brb | blog:zebra_striping_in_libreoffice:openoffice [2011-03-08 17:12] (current) – brb | ||
---|---|---|---|
Line 4: | Line 4: | ||
- Right click in the empty white space of that box and select " | - Right click in the empty white space of that box and select " | ||
- Name the new cell style " | - Name the new cell style " | ||
- | | + | |
- | | + | |
- Repeat step #2 and create a style called " | - Repeat step #2 and create a style called " | ||
- | | + | |
- | | + | |
- Select the range of cells that you want to zebra strip | - Select the range of cells that you want to zebra strip | ||
- Click Format > Conditional Formating... | - Click Format > Conditional Formating... | ||
- Change the values in that box to match these | - Change the values in that box to match these | ||
+ | - The brains of this operation is the MOD(ROW(); | ||
+ | - To tweak the formating just edit the styles " | ||
- | {{tag>}} | + | {{: |
+ | |||
+ | Ref: http:// | ||
+ | |||
+ | {{tag>openoffice libreoffice spreadsheet}} | ||
~~LINKBACK~~ | ~~LINKBACK~~ | ||
~~DISCUSSION~~ | ~~DISCUSSION~~ | ||
blog/zebra_striping_in_libreoffice/openoffice.1299600455.txt.gz · Last modified: 2011-03-08 17:07 by brb