To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113183 Issue #|113183 Summary|COUNTIF in a linked document when the condition is a d |igital string Component|Spreadsheet Version|OOo 3.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|fyva
------- Additional comments from [email protected] Fri Jul 16 10:17:39 +0000 2010 ------- If a cell contains only digits and is formatted as text (ie 123) or has an "'" before the digits (ie '123) and the COUNTIF contains a link to another document (ie =COUNTIF('file:///F:/Shared/original.ods'#$Sheet1.A9:B10;A2)) then the formula doesn't work. COUNTIF does not count 123 in the linked document to be equal to 123 in the current document. COUNTIF() don't work in this case (but IF() still works). See attachment below. --------------------------------------------------------------------- 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]
