Hello and thanks for the replys I have reported this as a bug Using '=' and 'enter' works to an extent but blank cells appear as '0' and any cell formatting is lost and the link isn't 'live' - later changers aren't copied across I can make this work =if(len(a1)>0,"","") (for this sheet the copy only needs to reflect one data type and a 'dot' will do) so using =if(len(a1)>0,".","") works (notice the "."), however again all formatting is lost Thanks for the help but the best results are achieved by a daily copy and paste ----- IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-question-paste-special-tp4012272p4012453.html Sent from the Users mailing list archive at Nabble.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