To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74377
User fst changed the following:
What |Old value |New value
================================================================================
Status|RESOLVED |CLOSED
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Feb 13 15:02:29 +0000
2007 -------
Hi,
the description of this Issue is verry missleading. The file opens just fine but
shows some Errorvalues. These Values are caused by formulas trying to calculate
with text values. This is simply impossibel even if Excel will do so. A text is
a text and not a number even it looks like a number. The responisble cells can
be easily discovered by using the Value Highlighting Feature (have a look at the
Help system for information about it).
The use of this feature discovered the folowing cells as text value:
Sheet1: E4 and O3 are text values
Sheet2: E4 and O3 are text values
Sheet3: E4 and L3 are text values
Sheet4: E4 and L3 are text values
Sheet5: E4 and L3 are text values
Sheet6: F4 and L5 are text values
Sheet7: F4 and L5 are text values
Sheet8: F4 and L5 are text values
Changing these values to real numbers resolves the errors and gives the expected
results.
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]
