To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51068 Issue #:|51068 Summary:|Count should ignore errors Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|navvy
------- Additional comments from [EMAIL PROTECTED] Tue Jun 21 12:48:13 -0700 2005 ------- When Excel counts a range using =COUNT(D4:D191) the result is the number of valid numbers only. Any cells that contain calculation errors, and display #N/A are ignored. The result is a number. Open Office Calc recognises the errors and shows an error in its own result. Count is supposed to show the number of valid numbers. Errors are not valid numbers, and therefore should be ignored. --------------------------------------------------------------------- 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]
