To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113183
------- Additional comments from [email protected] Sun Jan 23 19:15:12 +0000 2011 ------- I was also able to replicate the problem by using the supplied attachment in both of the following test environments: Open Office 3.2.1 Build: 9502 OS: Windows 7 Ultimate (32-bit) Open Office 3.2.1 Build: 9502 OS: Mac OS X Version 10.6.5 Several other tests were done, which included: 1. Including the "'" before each cell that contains a digit in one or both files. 2. Creating new files with different numbers. 3. Creating a new case within Microsoft Excel 2003 (that works) and trying it within Calc. In every case, COUNTIF() failed but IF() worked within Calc. This issue is important as it could possibly hamper user's ability to accurately produce documents and reports when using this version of OO, especially if porting documents over between applications. --------------------------------------------------------------------- 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]
