| View previous topic :: View next topic |
| Author |
Message |
Ghostwalker
Red Pill
Joined: Jan 28, 2008
Posts: 5
|
 Posted: Mon Jan 28, 2008 8:12 am Post subject: Zebra Strip in Calc |
|
| Does anyone know of a way to automatically zebra strip (alternate row color) in Calc? |
|
| Back to top |
|
 |
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Mon Jan 28, 2008 8:38 am Post subject: |
|
Moved to NeoOffice Support.
I do not know the answer to your question; so far I've always done it manually. I'm not sure whether there is a way to do it automatically, but it would definitely be interesting to know if there is one  |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Mon Jan 28, 2008 10:15 am Post subject: |
|
Thanks yoxi.
Maybe I'll add a little page in our wiki
Jacqueline |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Mon Jan 28, 2008 11:02 am Post subject: |
|
The formulae ISODD(ROW()) and ISEVEN(ROW()) are the easiest ones to use in the Conditional Formatting part of the process. If you want this functionality available across all your new spreadsheets, you'll need to add the new styles to the default spreadsheet template doc.
- padmavyuha |
|
| Back to top |
|
|
Ghostwalker
Red Pill
Joined: Jan 28, 2008
Posts: 5
|
| Posted: Mon Jan 28, 2008 11:29 am Post subject: |
|
| yoxi wrote: | | The formulae ISODD(ROW()) and ISEVEN(ROW()) are the easiest ones to use in the Conditional Formatting part of the process. If you want this functionality available across all your new spreadsheets, you'll need to add the new styles to the default spreadsheet template doc. |
Yoxi, I created 2 styles (odd_stripe, even_stripe) with two different colors. I then created the conditional formats using ISODD and ISEVEN and assigned them to the 2 styles. Now what do I do with them? If I select all of the cells, and then select either style, it set's the background color to that style. |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Mon Jan 28, 2008 12:18 pm Post subject: |
|
Once you've created the styles, you don't want to manually assign the styles to your sheet - you want Conditional Formatting (CF) to do this for you.
CF will be applied only to whatever cells you have selected just before you set up CF (that's so that you can apply different CF to different areas of the sheet). So what you want is to select the whole sheet, or the area you want to be striped, and then set up the CF so it looks like this:
That will assign the stripe styles dynamically to the cells you selected, dependant on whether a row is an odd or an even one.
I hope that's less ambiguous...
- padmavyuha
Last edited by yoxi on Mon Jan 28, 2008 12:28 pm; edited 1 time in total |
|
| Back to top |
|
|
Ghostwalker
Red Pill
Joined: Jan 28, 2008
Posts: 5
|
| Posted: Mon Jan 28, 2008 12:28 pm Post subject: |
|
Yoxi,
Great! That works! Thank You! |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Mon Jan 28, 2008 1:06 pm Post subject: |
|
You're welcome. It's a shame that this isn't 'built in' to OpenOffice - maybe it'll come along in a later version. The cool thing about doing it this way, though, is you can have different coloured stripes in different parts of the sheet to distinguish different data. Fiddly but fun...
- padmavyuha |
|
| Back to top |
|
|
Ghostwalker
Red Pill
Joined: Jan 28, 2008
Posts: 5
|
| Posted: Tue Jan 29, 2008 7:39 am Post subject: |
|
This is really great, and would be a nice addition to Neooffice.
Question, how do I add it to the default template? |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Tue Jan 29, 2008 8:16 am Post subject: |
|
See http://neowiki.neooffice.org/index.php/Editing_Default_Styles_and_Using_Templates in the NeoWiki for help with this.
Basically, you add the new styles to the default template doc, and save the changed template (or you create a new template if you haven't already made one). Any changes you make to it will appear in every new doc (of that type - Writer, Calc etc.) that you create after that.
- padmavyuha |
|
| Back to top |
|
|
Ghostwalker
Red Pill
Joined: Jan 28, 2008
Posts: 5
|
| Posted: Tue Jan 29, 2008 8:32 am Post subject: |
|
| yoxi wrote: | See http://neowiki.neooffice.org/index.php/Editing_Default_Styles_and_Using_Templates in the NeoWiki for help with this.
Basically, you add the new styles to the default template doc, and save the changed template (or you create a new template if you haven't already made one). Any changes you make to it will appear in every new doc (of that type - Writer, Calc etc.) that you create after that.
- padmavyuha |
Thank You Padmavyuha |
|
| Back to top |
|
|
|
