Issue 96461 - Trendline cannot be forced go go through zero - or any other specified intercept
Summary: Trendline cannot be forced go go through zero - or any other specified intercept
Status: CLOSED DUPLICATE of issue 34093
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO300m9
Hardware: PC Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-11-23 00:32 UTC by dskene
Modified: 2008-11-23 03:13 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.