2011/7/13 Hylton Conacher (ZR1HPC) <[email protected]>: > 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 [email protected] > In case of problems unsubscribing, write to [email protected] > 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
