[ http://tools.oasis-open.org/issues/browse/OFFICE-2290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17968#action_17968 ]
Andreas Guelzow commented on OFFICE-2290:
------------------------------------------
I guess the conflict you see has to do with the Constraint. We should use the exact same constraint as in LINEST. INTERCEPT returns one specific value calculated by LINEST.
> INTERCEPT
> ---------
>
> Key: OFFICE-2290
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2290
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Sub-task
> Components: OpenFormula
> Reporter: Robert Weir
> Assignee: Andreas Guelzow
> Fix For: ODF 1.2 Part 2 CD 2
>
>
> == 6.17.37 INTERCEPT ==
> Only some editorial remarks to the text "Calculates the point at which a
> line will intersect the y-values by using known x-values and y-values."
> 1. It calculates no point but a single value. 2. The line does not
> intersect the y-values but the y-axis. 3. It does not say, that the line
> is the linear regression of the known values.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
