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+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@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