Very strange. I copied your formulae and changed the cell references to something close, then saved in excel format. You're right: when I load into excel, the two cells have the error result 'value!'. However, it's not necessary to change the formulae to get the correct result. Just editing the cell by pressing f2, then enter will 'fix' the formula. It's not the constants in the formulae. I tried changing them to cell references. The referenced cell can contain 4 or 4.0 and it makes no difference. I'd have to say that this is worth submitting as a bug. Don't ask me how. I've filed one issue only and that was with specific instructions from one of the developers.
tc
Eike Rathke wrote:
Hi Tony,
On Tue, Mar 01, 2005 at 12:51:24 -0600, Tony Reipold wrote:
=SQRT(T201)*(G195)*4*O194+4*G195*G195 =SQRT(T201)*(G198)*4
After receiving your email I played around with this a little more. The root cause problem in Excel seems to be the extra parenthesis around G195 and G198 in the above equations. So it's either an Excel bug or pilot error on my part.
http://qa.openoffice.org/issues/show_bug.cgi?id=3724
Eike
P.S.: Please consider to subscribe to the mailing lists you're posting to. By doing so you won't miss replies that are directed to the list only. Please reply only to the list, not to my personal account. Thanks.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
