Re: [libreoffice-users] copying formats in Calc

On 16/12/12 14:12, darwinev0lved wrote:
> Hi there, hoping this is easy : I'm using a vlookup function to return some
> text from a cell. Is there a way to return not just the text but also the
> background colour of the cell?
> Or, thinking about it another way, if I just do A1=B1, this only makes the
> contents of the cell the same, is there some way to make the formatting the
> same ?

I immediately thought of something like 'Paste Special' but then 
realized that it could not be included in a formula. Perhaps there is 
some way to link just the formats of one cell to another?

Hih
Hylton
--
========================================================================
Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://e-clubhouse.org/sites/fishhoek/index.php being part of the worlds
largest non profit NGO
========================================================================



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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