To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=42893
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Feb 17 08:20:36 -0800
2005 -------
Hi,
not a bug of OOo Calc but from Excel which try's to calculate with text values.
Please load the document and press CTRL+F8 (Value Highlighting, Blue are
numbers, Black is text, Green are Formula results) now have a look at column E.
It's black indicating this is text. Calc doesn't calculate with text. Cell F2
takes the content from E2 and other cells are calculating with this result. As
the result in this case is a text and text is treated with the value zero, you
get a division by zero Error or Err:503.
To solve the problem make column E an nummeric column in Excel or remove the
quote in front of the values in OOo Calc.
Frank
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
