Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.