Re: [libreoffice-users] Calc question - paste special

On 10/09/2012 04:44 AM, IGraham wrote:
> Hello
> A Calc question
> I have a grid of cells 7x20, one row for each day of the week, cells may
> contain no data today
> Daily I update the relevant cells
> I want to copy and paste this grid to another sheet in the same book
> I select grid and copy, go to other sheet right click a cell, select paste
> special, click 'paste all' and 'link'
> The contents of the cells are pasted as links, but only the cells that have
> content, blank cells do not contain the link
> Would be nice if all the cells were linked as daily I have to recopy/paste
> Am I doing something wrong or is that the way it works
>
> Thanks for any help
>
>
>
>
> -----
> IGraham
>
> W764  LibreOffice 3.5.2.2 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-question-paste-special-tp4012272.html
> Sent from the Users mailing list archive at Nabble.com.
If A1 has a string (Sunday) the try =if(len(a1)>0,"",""). This will put any empty string in the 
cell whether the expression evaluates to true or false.


-- 
Jay Lozier
jslozier@gmail.com


-- 
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