Here's a couple equations giving me a problem.
=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.
Tony
Anthony Chilco wrote:
Hi Tony,
What's the formula that you're using? I did a quick test, dividing 6.58912 by 4 in OOo, saved as xls and loaded into excel 97 with no trouble.
tc
Tony Reipold wrote:
Hi,
I'm creating equations in Calc that will multiply or divide a float by an integer (4 in my case). Everything works perfectly fine in Calc. But when I save the spreadsheet in Excel format and send it to a co-worker who is using Excel, Excel reports errors in the cells which mix interger and float in the equation. The simple fix in Excel is to change the '4' to '4.0'.
It's highly annoying that Excel is too stupid to upcast from integer to float in this case, so I tried fixing my Calc spreadsheet to take care of the problem.
When I try to change the equation in Calc to use '4.0' in the offending equations, Calc converts it back to '4'. I can't seem to find a formating option that will prevent this from happening.
Any ideas?
Tony Reipold
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- POPI Classification [x]General Business Information [ ]Freescale Internal Use [ ]Freescale Confidential Proprietary
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
