To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53833
User andy999 changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Sep 21 19:52:48 -0700
2005 -------
"sorry to say, but you're wrong. Changing a2 to format numbers doesn't make the
text a number as the possibity exist that this 'number' is supposed to be a
text. To make it a real number you have to remove the apostrophe in front of the
number to make it a 'real' number."
Your're right. You're right. A few things puzzle me, though. As you have
thought out this so throughly, maybe you could fill in the blanks for me?
1. Why are numeric fields that are changed to text fields kept as numeric fields
for calculations?
2. If a numeric cell contains a formula using a reference to a non-numeric cell,
why isn't an error message generated?
---------------------------------------------------------------------
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]
