[libreoffice-users]

 postmaster@btinternet.com)
Subject: Re: [libreoffice-users] Table with alternat[]e row color
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

I performed a simple paste. I guess that technically it's an image (or if you like, a picture) but 
the contents can be editted.

I don't generally use Writer but I do use Calc a lot. I knew that I could generate the alternating 
color bands in Calc by means of formulas so I first looked for that functionality in Writer to no 
avail. Then I tried the technique I posted and editted the data successfully so I posted it.

Maybe I'm being over sensitive but I sensed hostlity in your response to me. I thought this list 
was one where everyone (expert or novice) shared for the benefit of all.

-- 
Jim

-----Original Message-----
From: Brian Barker <b.m.barker@btinternet.com>
To: users@global.libreoffice.org
Sent: Sun, 19 Apr 2015 22:27
Subject: 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


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