To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59973 Issue #:|59973 Summary:|SUMPRODUCT function fails Component:|Spreadsheet Version:|1.0.2 Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|code Assigned to:|spreadsheet Reported by:|vchapman
------- Additional comments from [EMAIL PROTECTED] Mon Jan 2 16:45:33 -0800 2006 ------- I have a spreadsheet originally developed in Excel that uses the SUMPRODUCT function as follows: SUMPRODUCT((WEEK=$A43)* Duration) where WEEK is a matrix of names and Duration is the time spent on a task. The function should calculate the total time each person spends on their various tasks. This works as it should in Excel. In calc it produces erroneous results. The Excel spreadsheet is attached. --------------------------------------------------------------------- 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]
