Re: [users] can you suppress the #value! errormessage(inOpenOffice calc)

+, Harold Fuchs wrote: On Monday, December 04, 2006 12:47 PM [GMT+1=CET], Nino Pereira [EMAIL PROTECTED] wrote: Harold, thank you: the ISNUMBER function works wonders. With one single command I have now filled the whole 2-dimensional array with calculated data, without burps

Re: [users] can you suppress the #value! error message(inOpenOffice calc)

function I may not even need it. Thank you again. Nino On Sun, 2006-12-03 at 22:43 +, Harold Fuchs wrote: On Sunday, December 03, 2006 5:25 PM [GMT+1=CET], Nino Pereira [EMAIL PROTECTED] wrote: Harold, thank you very much for looking at this problem in such a detailed manner

[users] Re: Installing OOo on Debian Linux (was Re: [users] can you suppress the #value! error message (inOpenOffice calc))

removal (with dpkg -rf?) I have given up for the moment. OOo works well enough right now, and I'd hate to break it and then have to spend days to recover. On Sun, 2006-12-03 at 10:04 +, Harold Fuchs wrote: On Saturday, December 02, 2006 10:05 PM [GMT+1=CET], Nino Pereira [EMAIL PROTECTED] wrote

[users] can you suppress the #value! error message (in OpenOffice calc)

Hi, I want to multiply a row that is sparsely populated with non-zero numbers only where there are data: when there are no date the cell is blank. But, when you multiply a blank you get an error message: #value!. Can you suppress this error message? I've tried to define the cell as a 'number',