Re: [libreoffice-users] Table with alternat[]e row color

At 20:21 19/04/2015 -0700, James E Lang wrote:
> From: Brian Barker:
> > The automatic way to colour spreadsheet rows alternately is to use 
> > Conditional Formatting and create a formula using the ROW() 
> > function to determine the oddness or evenness of the row number and 
> > control the background colouring using cell styles. But 
> > unfortunately - and as you might expect - the effect of such 
> > formatting is lost if you
> > paste a copy into a text document as a table. So that's a dead duck.
>
> Alain, I don't know whether you consider this to be "simple and 
> automatic" but what I've found is this:
>
> Use LibreOffice to create a spreadsheet. Select the table space. Use 
> Format=>Conditional Formatting=>Condition
> Condition 1:
>   Formula is ISEVEN(ROW())
>   select or create your style for even rows
>
> Add
> Condition 2:
>   Formula is ISODD(ROW())
>   select or create your style for odd rows
>
> OK. Copy the selected cells and paste them into your writer 
> document. This is the best solution I have found. Maybe it will 
> tickle someone else's creativity to come up with a better solution.

It's not clear whether you appreciate that this is the method that I 
described as a dead duck! Could you come clean about exactly how you 
are making this work, please?

Depending on how I paste the cell range from a spreadsheet, I can create:
o a striped graphic with no row or column structure - just a picture,
o an embedded spreadsheet section,
o a blank picture,
o a stack of paragraphs containing only sequences of tab characters, or
o the required table - but without the background formatting!

In particular, freezing the effect of the conditional formatting in 
the spreadsheet before copying the range of cells to the text 
document might be expected to work, but I didn't see any way to do this.

A striped panel is not going to provide the alternately coloured 
table rows that the questioner wanted. Do please explain how you have 
managed to paste the spreadsheet range to create a *formatted table* 
in the text document.

Brian Barker  


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted