Hide Zeros
Posted: Tue Jan 27, 2009 2:41 am
I've created a quote form in Calc that works really well, except ... Each line has a formula that multiplies the quantity by the item price. Unless each line has an item in it (usually not), the formula evaluates to zero. (Actually, if there is no item price or quantity, why does the formula calculate at all?) I can hide the zeros in the display but they re-appear in the printed and PDF outputs. Is there any way to extend the Hide Zero Values to the printed format short of deleting prior to printing? Thanks.
Dan
Dan