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

Hylton Conacher (ZR1HPC) wrote:

> Hi Dave,
>
> Thanks for the answer, and sorry for the belated reply, however it
> doesn't work using LibreOffice 3.3.1
> OOO330m19 (Build:8)
> tag libreoffice-3.3.1.2 On OpenSuse 11.0
>
> You are quite correct that the conditional formulae are copied too,
> however the formulae still refer to the same cell references given in
> the copied cell.
>
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.
>
> Please confirm if this is the case.
>
> Regards
> Hylton
Hi Hylton

No problem with the belated reply. As mentioned in other replies, the cell 
references can be relative, absolute or mixed so I think what you want is 
achievable.

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