Issue 106118 - LINEST uses incorrect default parameter
Summary: LINEST uses incorrect default parameter
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO310m19
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: ...
Keywords: oooqa
Depends on:
Reported: 2009-10-21 03:42 UTC by robert_rossi
Modified: 2013-01-29 21:40 UTC (History)
3 users (show)

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

Example of the LINEST default parameter issue (11.25 KB, application/vnd.sun.xml.calc)
2009-10-21 03:43 UTC, robert_rossi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description robert_rossi 2009-10-21 03:42:57 UTC
The OOo implementation of LINEST works correctly if the optional third and
fourth parameters are omitted, however the third parameter incorrectly defaults
to FALSE if the fourth parameter is specified but not the third.  That is,
incorrectly returns the results for
rather than the expected
(per LINEST helpfile)

This is demonstrated in the document linked through the URL above.  (I prepared
it thinking I could send an attachment, but don't see a way to do so here.)
Comment 1 robert_rossi 2009-10-21 03:43:48 UTC
Created attachment 65488 [details]
Example of the LINEST default parameter issue
Comment 2 Regina Henschel 2009-10-21 08:48:17 UTC
If I read ODFF 6.17.40 correct, it should not be possible to omit the third
parameter and use the forth parameter. So acting strongly to ODFF, OOo should
generate an "error in parameter list".

Excel allows to omit the third parameter and uses the default TRUE. When
importing such spreadsheet, OOo should set the third parameter to TRUE.

It has to be discussed whether OOo should allow to omit the third parameter,
when the forth parameter is used. When OOo allows it, the default has to be TRUE.

The help says that the default is TRUE, but it also says that it is not possible
to omit the third parameter when the forth parameter is used. So currently the
OOo does not act as described in the help.
Comment 3 robert_rossi 2009-10-24 15:23:32 UTC
Thanks Regina - you hit the nail on the head!  This issue became apparent to me
in importing an Excel spreadsheet into OOo, and finding (after much confusion)
that it gave a different LINEST result than that obtained in Excel.  I believe
any fix preventing such from occurring would be an important improvement.