Zebra Stripes in OpenOffice Calc

Hold on Cowboy

This blog post is pretty old. Be careful with the information you find in here. It's likely dead, dying, or wildly inaccurate.

Open Office is a great alternative to Microsoft Office. It does lack in some areas where as MS Office might provide an easy way to accomplish a task, OpenOffice can usually do it with a little bit of acrobatics.

Zebra Striping in Calc 

1. With Calc opened up, view the Styles and Formatting window (Format > Styles and Formatting) 2. Right click in the empty white space of that box and select “New” 3. Name the new cell style “odd” 1. Change the background color of the cell to a color of your desire 2. Click OK 4. Repeat step #2 and create a style called “even” 1. Change the background color to a different color of your choice 2. Click OK 5. Select the range of cells that you want to zebra strip 6. Click Format > Conditional Formating… 7. Change the values in that box to match these 8. The brains of this operation is the MOD(ROW();2)=0 and MOD(ROW();2)=1 9. To tweak the formating just edit the styles “odd” and “even”

Did this help you out? It took me a few days to piece together all this information together, I hope this saves you some time (who knows, maybe the future me will be thankful I wrote this down). Let me know your thoughts. shanestillwell@gmail.com