first arg to SUMIF requires vars to have underscore

Thread: first arg to SUMIF requires vars to have underscore

Search this list only Search all lists
first arg to SUMIF requires vars to have underscore
	2007-09-30 01:18:43
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82104 Issue #\|82104 Summary\|first arg to SUMIF requires vars to have underscore Component\|Spreadsheet VersionOo 2.2 Platform\|PC URL\| OS/Version\|Linux Status\|UNCONFIRMED Status whiteboard\| Keywords\| Resolution\| Issue type\|DEFECT Priority\|P3 Subcomponent\|editing Assigned to\|spreadsheet Reported by\|hunteke ------- Additional comments from huntekeopenoffice.org Sun Sep 30 06:18:41 +0000 2007 ------- version string from Help->About: openoffice.org 2.2.0-1ubuntu4, Mon Jul 2 13:17:52 UTC 2007 $ uname -a Linux lina 2.6.20-16-generic #2 SMP Sun Sep 23 19:50:39 UTC 2007 i686 GNU/Linux Distro: Ubuntu Fiesty I didn't test this thoroughly, because I'm in sort of a rush, but I noted while developing an example spreadsheet for some buddies of mine that the first argument to SUMIF seems to require an underscore. If you need a tester of 2.3, since that version is now out, I can do that, but not for about a month. It's probably easier to have you experience the problem than me try to explain it exactly, so I'll attach a sample spreadsheet that showcases the bug. I've defined a bunch of variables, the relevant of which are WhoPaid and Who_Paid. WhoPaid == Who_Paid == $Sheet1.$D7:$D65535 Look at cells Sheet1.D2 and Sheet1.D3. The difference showcases the bug. ------------------------------------------------------------ --------- 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-unsubscribesc.openoffice.org For additional commands, e-mail: issues-helpsc.openoffice.org

first arg to SUMIF requires vars to have underscore
	2007-09-30 01:21:02
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82104 ------- Additional comments from huntekeopenoffice.org Sun Sep 30 06:21:01 +0000 2007 ------- Created an attachment (id=48605) Showcases bug where first argument to SUMIF, if it's a variable, must have an underscore. ------------------------------------------------------------ --------- 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-unsubscribesc.openoffice.org For additional commands, e-mail: issues-helpsc.openoffice.org

first arg to SUMIF requires vars to have underscore
	2007-10-01 04:27:42
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82104 User fst changed the following: What ld value \|New value ============================================================ ==================== Status\|UNCONFIRMED \|RESOLVED ------------------------------------------------------------ -------------------- Resolution\| \|INVALID ------------------------------------------------------------ -------------------- ------- Additional comments from fstopenoffice.org Mon Oct 1 09:27:41 +0000 2007 ------- Hi, not a bug of Calc but misconfigured named ranges. With SUMIF the ranges for Range and Sum Range must be equal in size to give correct results. If they are not equal in size a summation can't give a result as either the range or the summation range is to short. in your case WhoPaid is smaller as AmmountPaid $Sheet1.$C$7:$C$65358 and $Sheet1.$D$2:$D$65358. the named range Who_Paid ist defined with the same size as AmountPaid $Sheet1.$C$2:$C$65358 and $Sheet1.$D$2:$D$65358. So this is not a defect and invalid. I close it as such. Frank ------------------------------------------------------------ --------- 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-unsubscribesc.openoffice.org For additional commands, e-mail: issues-helpsc.openoffice.org

first arg to SUMIF requires vars to have underscore
	2007-10-01 04:28:07
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82104 User fst changed the following: What ld value \|New value ============================================================ ==================== Status\|RESOLVED \|CLOSED ------------------------------------------------------------ -------------------- ------- Additional comments from fstopenoffice.org Mon Oct 1 09:28:06 +0000 2007 ------- closed invalid ------------------------------------------------------------ --------- 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-unsubscribesc.openoffice.org For additional commands, e-mail: issues-helpsc.openoffice.org

first arg to SUMIF requires vars to have underscore
	2007-10-01 14:17:51
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82104 ------- Additional comments from huntekeopenoffice.org Mon Oct 1 19:17:51 +0000 2007 ------- Hot damn, when you're right, you're right; and you're right. I thought I had checked that multiple upon multiple times looking for exactly that. C'est la vie, and thanks for pointing that out. Just takes another pair of eyes, eh? Thanks. ------------------------------------------------------------ --------- 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-unsubscribesc.openoffice.org For additional commands, e-mail: issues-helpsc.openoffice.org

[1-5]

about | contact Other archives ( Real Estate discussion Medical topics )