[sc-issues] [Issue 113183] COUNTIF in a linked docum ent when the condition is a digital string
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113183 User helen_russian changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |regression --- Additional comments from helen_russ...@openoffice.org Sat Jul 17 07:02:26 + 2010 --- confirm with OOo DEV300m84. It works fine with OOo 2.4.3. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113183] COUNTIF in a linked docum ent when the condition is a digital string
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113183 User fyva changed the following: What|Old value |New value CC|''|'dr_faust,helen_russian,sy | |zygy' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113183] COUNTIF in a linked docum ent when the condition is a digital string
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 f...@openoffice.org Fri Jul 16 10:21:35 + 2010 --- Created an attachment (id=70643) zipped documents - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113183] COUNTIF in a linked docum ent when the condition is a digital string
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 f...@openoffice.org Fri Jul 16 10:17:39 +
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
