| Summary: | matrix formula wrong calculation from names, also wrong saving of names | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | y1360555 |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | xiscofauli |
| Priority: | high | ||
| Version: | 5.3 all versions | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=58874 | ||
| Whiteboard: | target:6.1.0 target:6.0.2 target:5.4.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | testing file with bug shown | ||
|
Description
y1360555
2018-02-06 17:37:38 UTC
Created attachment 139643 [details]
testing file with bug shown
Investigating. These are actually two issues. 1. The names are not damaged during save, but when loading the document and compiling a named expression a contained name is not found if not already loaded, which is resolved in a second step later, but here the name is identical to a cell content (e.g. "start" and "end") and "Automatically find column and row labels" is switched on for this document (Tools->Options->Calc->Calculate, General calculations). These labels then lead to errors in the named expression context they are used. 2. The unexpected calculation of both array results as 6 when names are intact. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=30083601334279f33a3021dfe7d22970d02c8e9e tdf#115493 postpone name resolution after unsuccessful IsNamedRange() It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review of this part https://gerrit.libreoffice.org/49396 for 6-0 https://gerrit.libreoffice.org/49397 for 5-4 Effectively the result in this example should be the same as =SUM(IF(EXACT(A7:A9,A$1),B7:B9,0)) entered as array formula, delivering one element of 4. Expecting 2 as a second result element is not correct. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e0a94ded5d1635fa2a2d9e222bfcfa0a2289a01f Resolves: tdf#115493 use matrix as result of jump command, tdf#58874 related It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/49464 for 6-0 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=04835fd953d28e44843e9473be4f4d99a24eddf0&h=libreoffice-6-0 tdf#115493 postpone name resolution after unsuccessful IsNamedRange() It will be available in 6.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ec9bfbaaa642b911b121b99ff509e82c19777fc4&h=libreoffice-5-4 tdf#115493 postpone name resolution after unsuccessful IsNamedRange() It will be available in 5.4.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4b938c558d004537cf73ca4319019ff64f052270 Use angle quotation marks (Guillemets) for [*-CH], tdf#115493 related It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Ignore last commit, wrong bug number. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b05e4eab225a536c3e5bdae2ca991ee9f53ad1a6 Unit test tdf#115493 use matrix as result of jump command, tdf#58874 related It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ed2a66a2ccace13c3d85490300cd623109214b0e&h=libreoffice-6-0 Resolves: tdf#115493 use matrix as result of jump command, tdf#58874 related It will be available in 6.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |