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

2011/7/13 Hylton Conacher (ZR1HPC) <hylton@conacher.co.za>:
> 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.

Remember that the $ works the same way in conditional formatting like
it does in cell formulas, for example $A$1. This reference won't
change when copying the cell, A1 would.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


> Please confirm if this is the case.
>
> Regards
> Hylton
> --
> ========================================================================
> Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
> http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO
> ========================================================================
>
> --
> 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

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