Issue 96461

Summary:	Trendline cannot be forced go go through zero - or any other specified intercept
Product:	Calc	Reporter:	dskene <listmail.oo>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, rb.henschel
Version:	OOO300m9	Keywords:	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.