Bug 146686 - LINEST with empty parameter for KnownX has different results in LibreOffice than in Excel
Summary: LINEST with empty parameter for KnownX has different results in LibreOffice t...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL: https://issues.oasis-open.org/browse/...
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2022-01-10 19:18 UTC by Regina Henschel
Modified: 2022-08-19 03:43 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
Example to see the problem (30.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-10 19:18 UTC, Regina Henschel 		Details
View All 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 Regina Henschel 2022-01-10 19:18:46 UTC 
Created attachment 177439 [details]
Example to see the problem

Open attached document in LibreOffice and in Excel.
Notice that in case of an empty parameter for KnownX, LibreOffice uses the default values 1,2,3,... row-wise, whereas Excel uses them column-wise.
The same problem exists, if you use an xslt-file generated by Excel.

This bug has two aspects:
a) How should the order be specified in ODF? (see OASIS JIRA issue OFFICE-3949)
b) How can LibreOffice guarantee, that Excel and LibreOffice get the same result?

Eike: Any idea on a) ?
Comment 1 Regina Henschel 2022-01-10 19:21:35 UTC 
Otherway round:
LibreOffice uses the default values 1,2,3,... column-wise, whereas Excel uses them row-wise.
Comment 2 Xisco Faulí 2022-08-18 08:38:24 UTC 
Hi Regina,
Any update on this ?
Comment 3 Regina Henschel 2022-08-18 10:40:39 UTC 
No progress and a solution by the ODF TC in near future is unlikely.

We could implement a function in own namespace, that is compatible to Excel and Gnumeric.