To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75433
User billmichaelson changed the following:
What |Old value |New value
================================================================================
Status|RESOLVED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Mar 16 20:43:50 +0000
2007 -------
OO Calc 2.1 works with numbers that begin with leading spaces and a dollar sign.
Try it. Open an empty spreadsheet and key in: " $123" OO Calc will treat it
like a numeric value. Enter a formula in another cell that references the
value. It will work.
In the case of OO, the new cell is assigned the format "Currency" without
explicit user instruction. In the case of Excel, it is assigned the format
"General", yet Excel will operate successfully with the value as I suppose it
would with any "General" value that can be reasonably interpreted as numeric.
Both behaviors are reasonable or justifiable; this isn't religion.
Now, I suppose I could say that if it's a bug for Excel to interpret a
particular string as numeric, then it must be a bug for OO Calc to interpret the
identical string as numeric when it is keyed in (as I described in my original
report). But I don't care to point a finger; I live in the real world and need
to solve a real problem while competing in a real marketplace...
And that is why this all misses the most important point. Perhaps there is a
reference document for Excel that I am not aware of, but my definition of what
must happen when I import data in .xls format is that OO can interpret it in
such a way that is functionally equivalent to Excel. It's .xls format. If
Excel does the "wrong" thing, then so should OO Calc!
All around me there are organizations that I can't convince to use OO instead of
Microsoft. They are not interested in geeky philosophical discussions about who
is to blame when their applications don't work. They want applications that
solve their problems. And now, for practical purposes, OO cannot use Excel
spreadsheets, because someone might be too stubborn to make the process work.
Are you suggesting I complain to Microsoft? Yeah, right. They've already got
most of the customers, so they can be as arrogant as they want!
---------------------------------------------------------------------
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]
