[libreoffice-users] Re: Conditional formatting cell copying?

Hylton Conacher (ZR1HPC) wrote:

> Hi all,
>
> Is there a way to copy a particular cells conditional formatting rules
> across a  cell selection either in a row or a column?
>
> I have a spreadsheet with three columns of numbers, two of which require
> three conditional formatting rules on each and every cell row.
>
> I know how to increase of the cell reference in a cell formula is
> possible, but how can the cell values in the cell conditional formulae
> also be updated incrementally?
>
> If this is not possible, please give me some links as to where I can
> suggest it for LibreOffice. This feature is also lacking on MS Excel
> 2003 and getting this implemented I am sure would be a MAJOR boost for
> LibreOffice.
>
> Regards
> Hylton
Hello Hylton

Set up your conditions as required in one cell and confirm they all work as 
expected. Then you can copy the cell, select paste special and you will get a 
default of paste all. This will include the conditional formats in my test.

Tested using:
LibreOffice 3.3.3 
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1
openSUSE 11.4 64 bit

HTH
Regards
Dave



-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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