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.