| Summary: | LINEST with empty parameter for KnownX has different results in LibreOffice than in Excel | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Regina Henschel <rb.henschel> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | normal | CC: | 79045_79045, erack, michael.stahl, winfrieddonkers, xiscofauli |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| URL: | https://issues.oasis-open.org/browse/OFFICE-3949 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108827 | ||
| Attachments: | Example to see the problem | ||
Otherway round: LibreOffice uses the default values 1,2,3,... column-wise, whereas Excel uses them row-wise. Hi Regina, Any update on this ? 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. |
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) ?