Issue 96461

Summary: Trendline cannot be forced go go through zero - or any other specified intercept
Product: Calc Reporter: dskene <listmail.oo>
Component: codeAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOO300m9Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description dskene 2008-11-23 00:32:00 UTC
Often when using trendlines there is a need to allow to user to specify a y 
intercept, often 0. Currently this is not an option. The user does not have the 
capability to input the required y intercept. As such, the trendline produced 
is often inadequate for the user - thus forcing them to have to use another 
program such as Excel.
Comment 1 Regina Henschel 2008-11-23 01:13:55 UTC
This problem is already tracked in issue 34093. Please read the discussion
there. The problem is not so clear as you might think.

*** This issue has been marked as a duplicate of 34093 ***
Comment 2 Regina Henschel 2008-11-23 01:17:02 UTC
closing duplicate
Comment 3 dskene 2008-11-23 03:13:22 UTC
Actually, the problem is quite clear. The understanding of why it is important 
is not clear in issue 34093. There are many scientific examples where the data 
is supposed to go through zero. I will describe a real life example in issue 
34093 and you will understand.