Re: [libreoffice-users] copying formats in Calc

2012-12-18 Thread Hylton Conacher (ZR1HPC)
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 c

Re: [libreoffice-users] copying formats in Calc

2012-12-16 Thread Brian Barker
At 04:12 16/12/2012 -0800, Jon Noname 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 make

[libreoffice-users] copying formats in Calc

2012-12-16 Thread darwinev0lved
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 so