Harold Fuchs,
I am sorry this is a little late and I lost the thread (did not save the
original post). However, I just tried the solution given by you in your
post of 11 Jan 2009, same subject, to get Writer table sum results of
0.00 replaced by blanks. I, needed this for my Writer purchase order
documents. I was unhappy with all the "0.00" results of multiplying the
quantity by the unit cost when either the quantity or unit cost is null,
as it is on blank lines. I didn't like the option of removing all the
unused Sum formulas in the totals column. The computer should do that
for me.
Your solution was to create a "User Defined" cell format of:
[<>0]#.##;[=0]" ". This replaces all zero values with blanks. This
does work, however the decimal places were lost on whole numbers. For
example, 12.00 becomes 12. Also, I lost the "$" US currency prefix
which the default "Currency" format inserted.
After looking at the number format codes help, I discovered that the
format can be 3 fields divided by semicolons, not just 2 fields (OO.o
v2.4.1). The first field is the format for positive numbers, the middle
field is for negative numbers, and the last field is for zero numbers.
Therefore, the default Currency format can be used to do the blanking by
appending ;" ". My resulting User Defined format is:
[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00;" "
This does everything the default Currency format does, but adds 4 blanks
if the number is zero. Note that this format is for US currency
($$-409). Check your default Currency format and adjust the format
string accordingly. For more information, look up "Number Format Codes"
in the OO.o help.
Thanks for your solution and I hope this helps.
Girvin Herr
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
