Greetings, I am using AOO 4.1.6 under Slackware Linux 14.2.
In Writer, I am trying to create a blank data entry form or template with a table to be filled out later, so all of the to-be-entered values in the table's cells are zero or null. In a few cells I want to create a formula that in part divides one cell value by another cell value, both of which are, of course, zero or null at this time. Normally this divide by zero is an error, and I am getting an "Expression is faulty" error. It isn't the expression that is faulty, but the data. How do I get Writer to ignore this error so the form is clean, until something other than 0.00 is entered in the divisor cell?
Is there a way to use a conditional in the formula cell, such as: "if divisor = 0.00 then use 0.01 for divisor else use divisor"?
That would fake it out and keep the form clean (blank with no error messages) until data is entered and the divisor becomes not zero.
Thanks. Girvin --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
