[sc-issues] [Issue 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 User er changed the following: What|Old value |New value CC|'er' |'' Status|NEW |RESOLVED OS/Version|Windows XP|All Platform|PC|All Resolution| |FIXED Subcomponent|code |programming Target milestone|--- |OOo 3.4 --- Additional comments from e...@openoffice.org Fri Nov 12 18:08:35 + 2010 --- Thanks a lot! The ending missing parameter ;) needs to be attacked on a lower level within the compiler. Excel import is yet another construction site. We talked about that during the Hackfest. In cws dr78: changeset 8e91176b3b0e http://hg.services.openoffice.org/cws/dr78/changeset/8e91176b3b0e M sc/source/core/inc/interpre.hxx M sc/source/core/tool/interpr4.cxx M sc/source/core/tool/interpr5.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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:10:52 + 2010 --- Created an attachment (id=72834) Testcase for accuracy of LINEST - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:12:26 + 2010 --- Created an attachment (id=72836) Testcase for accuracy of LOGEST - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:10:13 + 2010 --- Created an attachment (id=72833) Testcase for TREND and GROWTH - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:14:28 + 2010 --- Created an attachment (id=72838) Patch for LINEST|LOGEST and TREND|GROWTH against DEV300m90 - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:11:51 + 2010 --- Created an attachment (id=72835) testcase for accuracy of LINEST for special case polynomial regression - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Wed Nov 3 09:13:34 + 2010 --- Created an attachment (id=72837) testcases with different ways to call LINEST - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 User regina changed the following: What|Old value |New value Assigned to|regina|er Issue type|TASK |PATCH --- Additional comments from reg...@openoffice.org Wed Nov 3 09:22:17 + 2010 --- I have attached a patch that should work. Please have a look and tell me, whether you want me to change something. I do not manage to catch the cases where the function is called with an ending semicolon. Is seems, that the needed isMissing-Token is not set in those cases. LINEST follows the Excel way in handling a missing third parameter. A better way would be, to be strict ODF conform. But I do not find, where I have to change the Excel import filter. - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 Issue #|115189 Summary|Improve LINEST/LOGEST Component|Spreadsheet Version|DEV300m86 Platform|PC URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|TASK Priority|P3 Subcomponent|code Assigned to|regina Reported by|regina --- Additional comments from reg...@openoffice.org Thu Oct 21 21:35:56 + 2010 --- The current implementation of LINEST/LOGEST has some errors (issues 109264, 112324, and 112447) and is less accurate than Gnumeric and Excel. I'll attach a file with a first draft of my solution. Please use the mailing list d...@sc.openoffice.org to discuss this draft. - 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 115189] Improve LINEST/LOGEST
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115189 --- Additional comments from reg...@openoffice.org Thu Oct 21 21:40:21 + 2010 --- Created an attachment (id=72144) A first draft of a new implementation of LINEST/LOGEST - 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