Bug 95434 - LINEST function shows error if empty cells are in range
Summary: LINEST function shows error if empty cells are in range
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-30 08:29 UTC by Lovro
Modified: 2015-11-11 12:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Lovro 2015-10-30 08:29:38 UTC 
Contrary to expected behaviour, (like SLOPE and INTERCEPT), LINEST shows error if there are empty cells in a range. It would be very useful if it would still work, despite empty cells.
Comment 1 raal 2015-10-31 22:08:38 UTC 
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018698_715980110

6.18.41 LINEST
If any of the entries in knownY and knownX do not convert to Number, LINEST returns an error.
Comment 2 A (Andy) 2015-11-07 12:07:05 UTC 
Can we with the comment from raal close this bug report or should we keep it open despite the OASIS specification?
Comment 3 Eike Rathke 2015-11-11 12:09:53 UTC 
What raal said. Excel behaves the same.