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 [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
