At 19:34 03/04/2009 -0500, Oscar Luna wrote:
I am very sorry, I was testing your openoffice application trying to
move from microsoft office to your product but I found it is not as
reliable as I expected.
The reliability of OpenOffice is perhaps not best tested merely by
comparing it with Microsoft Office!
As you can see in the attached image the formula cells has not any
text or zero value, I tripled check this even the original file was
excel and I could see the formula results. but in the open office
file from the row 8 ahead the result of the calculation is div by
zero even the formula is copied from the previous rows and no zero
value in the cells involved.
I think you have discovered a *difference* between Microsoft Excel
and OpenOffice Calc. My guess is that one or other (or both) of the
values in D8 and E8 are actually text values rather than
numbers. Excel interprets numbers entered as text as having their
numeric value when appropriate in formulae, but Calc treats them as
text and sees their value as zero. You can test this easily by going
to View | Value Highlighting: numbers will show in green but text
values will remain black.
If you want your values to be numbers, it will be best to convert
your values in the incorrect rows to numbers, as they evidently
already are in some other rows. If you want a quick fix, you could
change your formula to something like
=Q8/(VALUE(D8)*VALUE(E8))
- where the VALUE() function explicitly interprets the text values as numbers.
I took my time for report this because I was finding a good tool, but....
Millions think OpenOffice is a "good tool"!
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
