[sc-issues] [Issue 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 User er changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.4 --- Additional comments from e...@openoffice.org Fri Dec 3 21:11:36 + 2010 --- With a little modification. In cws dr78: changeset 297b5255c27a http://hg.services.openoffice.org/cws/dr78/changeset/297b5255c27a M sc/inc/column.hxx M sc/inc/dociter.hxx M sc/inc/document.hxx M sc/inc/table.hxx M sc/source/core/data/dociter.cxx M sc/source/core/tool/interpr2.cxx You can observe the progress and possible integration date of CWS dr78 at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdr78 - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 User er changed the following: What|Old value |New value Issue type|DEFECT|PATCH --- Additional comments from e...@openoffice.org Wed Jul 1 12:41:46 + 2009 --- A patch is a patch. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from lv...@openoffice.org Mon Jun 29 03:14:21 + 2009 --- Created an attachment (id=63261) Patch 2. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from lv...@openoffice.org Wed Jun 10 07:03:08 + 2009 --- Created an attachment (id=62898) Another test case. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from lv...@openoffice.org Wed Jun 10 07:06:11 + 2009 --- I found another problem with NPV(), see the attached file i92774_NPV_singleref.xls, in Excel, the results of C4 and D4 are the same, but in OOo, they are not. Please check this. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 User er changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from e...@openoffice.org Wed Jun 3 09:41:23 + 2009 --- As discussed on IRC, a row-wise value iterator may be better suited that then could be reused in other statistical functions needing to evaluate data row-wise. The challenge is to not lose the performance benefit of the ScValueIterator that accesses the data column-wise as it is stored internally. Setting up an array of ScValueIterators, one per column, comes to mind; that then could be iterated through for each row. Just a quick idea.. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from e...@openoffice.org Wed Jun 3 10:08:17 + 2009 --- Take a look at ScHorizontalCellIterator, that combined with the functionality of ScValueIterator might be it. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from lv...@openoffice.org Fri May 22 07:37:53 + 2009 --- Created an attachment (id=62428) Patch 1, small change. - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 User lvyue changed the following: What|Old value |New value CC|''|'lvyue' - 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 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 Issue #|92774 Summary|ODFF: NPV() must evaluate arguments in the order given | and row-wise Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|er Reported by|er --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 18:40:47 + 2008 --- In NPV() the order of values is significant and affects the result. Evaluation of arguments must be in the order given and range reference and array arguments must be evaluated row-wise starting from top left to comply with ODFF and be compatible with other spreadsheet 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]
[sc-issues] [Issue 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 18:48:42 + 2008 --- Created an attachment (id=55754) test case, result in D6 is wrong - 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]
[sc-issues] [Issue 92774] ODFF: NPV() must evaluate arguments in the order given and row-wise
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92774 User er changed the following: What|Old value |New value Keywords| |ms_interoperability Target milestone|--- |OOo 3.x - 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]