[email protected]) 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 <[email protected]> To: [email protected] 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: [email protected] 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: [email protected] 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
