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]
