Cell T201 must be positive. If it is negative, the formula will always
fail.
Daniel Rentz wrote:
Hi,
Tony Reipold schrieb:
Here's a couple equations giving me a problem.
=SQRT(T201)*(G195)*4*O194+4*G195*G195
=SQRT(T201)*(G198)*4
^^^^^^
The problem are the single cell references in parentheses. This is not
needed, and it confuses the Excel export filter in the OOo 1.1.x
series. Remove them and all will work fine.
BTW: OOo 2.0 will export these formulas correctly.
http://www.openoffice.org/issues/show_bug.cgi?id=3724
Best regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
