Hi :) Blimey!! Good work! Hopefully that might help with other issues later even if it couldn't solve this problem this time. Thanks and regards from Tom :)
----- Original Message ---- > From: PLO <protect.libreoff...@inboxshield.co.uk> > To: users@libreoffice.org > Sent: Sun, 5 June, 2011 13:10:01 > Subject: Re: [libreoffice-users] Re: Calc: Has anyone tested the >backward-compatibility of LibreOffice 3.4? > > Hello Tom, > > On Sat, 4 Jun 2011 15:22:50 +0100 (BST) (your time) you said: > > > ... i played around with "Format Cells". I couldn't get an ideal answer > > that shows a - even when the cell is empty but i could get one when the > > cell has 0 value. > > Well, too much time later and I haven't been able to work it out either, > Tom. Even if you do get a "-" to show up in an empty cell (using COUNTBLANK > for example), it still isn't useful because "-" in a time formatted cell > always results is '#VALUE!'. > > I clearly don't know enough to be able help here. :-) > > -- > Si (PLO) > #31064. Now Hew Sore Dig? ¶ > > Auxiliary Information: > • LibreOffice 3.4.0 OOO340m1 (Build:12) > • Windows XP Pro 5.1.2600 Service Pack 3 > > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/www/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted