Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Zebra Strip in Calc
Zebra Strip in Calc
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
Ghostwalker
Red Pill


Joined: Jan 28, 2008
Posts: 5

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

PostPosted: 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 Smile
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Mon Jan 28, 2008 9:27 am    Post subject:

Some discussions about doing this with styles and conditional formatting on oooforum - the first one is the most concise, I think, but the others look into ways to semi-automate this process:

http://www.oooforum.org/forum/viewtopic.phtml?t=52166

http://www.oooforum.org/forum/viewtopic.phtml?t=52166

http://www.oooforum.org/forum/viewtopic.phtml?t=65697

http://www.oooforum.org/forum/viewtopic.phtml?t=11543

- padmavyuha
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Mon Jan 28, 2008 10:15 am    Post subject:

Thanks yoxi.

Maybe I'll add a little page in our wiki Smile

Jacqueline
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

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

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

PostPosted: 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... Smile

- 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

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

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

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

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

PostPosted: 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
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.