To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=5658





------- Additional comments from [EMAIL PROTECTED] Wed Feb 20 17:41:22 +0000 
2008 -------
@daxkelson: Malicious? You just lost your credibility. Expecting bug-for-bug
compatability with Excel is unreasonable and unachievable.

@kohei:
>we would still need to provide some solutions to
>those users who rely on that behavior of Excel.  We can't just leave them in 
>the dust.

You have users who rely on SUM(A1:A2) not including a text cell that contains a
number? I'm a little surprised. Fixing both aspects of the issue - making it
calculate in both A1+A2 and SUM(A1:A2) - will fix far, far more cases than it
will break. I even think it will fix more cases than just patching the first
behaviour would, I'd expect that most spreadsheets that are failing to include
text cells in their calculations are doing so in variance to the creator's 
intent.

>By the way, that's the _existing_ behavior.  My patch won't touch it.  I just
>merely covered it to keep my intention clear.
>So, your above statement is incorrect.

If a patch deliberately introduces a discrepancy between A1+A2 and SUM(A1:A2)
then I call that a bugged patch. "Incorrect" is only true in a purely semantic
sense.

---------------------------------------------------------------------
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]

Reply via email to