Created attachment 90416 [details] Shows the vlookup wizard. Hi, When using the wizard to fill the parameters in the vlookup function is shows in '#REF!.A3:A3' in the search criterion. In the past it would only show A3 as an example. This is how it works in 4.1.4.1.
Hi p_kongstad, thanks for reporting. Please what is your detailed LibreOffice version. It is in Menu/Help/AboutLibreOffice, and it is possible to copy for paste here. Can you detail the steps to reproduce the bug. Recently has been fixed some issues about wizard. https://bugs.freedesktop.org/show_bug.cgi?id=71667
Hi, I can no longer reproduce this error.
Hi, thanks for the information, then we can change the status. Please, if you see the bug again, reopen it.
(In reply to m.a.riosv from comment #3) > Hi, thanks for the information, then we can change the status. > > Please, if you see the bug again, reopen it. The bug is back in versions 5.4.2 and master. Works in LO 5.3.4. The wizard does not find the sheet name if criterion or matrix is on another sheet. So reopen. Best regards. JBF
Created attachment 136971 [details] VLookup
Hi all, I reproduce with LO 5.4.0.0.alpha1 Build ID: 0b9f9bef65bb21ebb6a64aafad448f7f62dc824a Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: CL and upper versions but not with LO 5.3.6.1 Build ID: 686f202eff87ef707079aeb7f485847613344eb7 Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: CL and later versions To make appear the bug, the formula has to be located in a sheet after the sheet where you search, and the wizard has to be used. Other functions, as the Sum function, produce the same result with the same conditions.
*** Bug 113086 has been marked as a duplicate of this bug. ***
Created attachment 136973 [details] Screenshot wizard I can't reproduce Version: 5.4.2.2 (x64) Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group
Created attachment 136981 [details] screenshotwizard Problem still there Version: 5.4.2.2.0+ Build ID: SlackBuild for 5.4.2 by Eric Hameleers CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.0.0.0.alpha0+ Build ID: 8eacd3be08bf6e1a97900624611822de9b00a379 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
LO 5.4.3.2 In reply to Jacques Guilleron comment 6 Quote: "To make appear the bug, the formula has to be located in a sheet after the sheet where you search, and the wizard has to be used. Other functions, as the Sum function, produce the same result with the same conditions." The wizard works well when the formula is located in the sheet and the information looked for is in an after sheet. F.i. Sheet1 - sheet2 - sheet3 - sheet 4 - sheet 5. The wizard works well if the f0rmula is place in sheet1 and the search is in sheet2, sheet3, sheet4 or sheet5. However when the formula is placed in sheet3 and the search is in sheet4 of sheet 5, the wizard fails.
Edited Summary to reflect the issue.
Just to clarify, this happens to all functions which allow range parameter. Copying the steps to reproduce explained in bug 113086. Steps to Reproduce: 1.Create a new Spreadsheet 2.Create a new sheet named "Sheet2" 3.Switch to sheet "Sheet2" 4.Select any Cell in Sheet, then click function wizard 5.Choose any function, for example ABS, then click "Next >>" button. 6.Click "Select" button right at Number textbox 7.Choose a range in Sheet1 Actual Results: In select Dialog, show "$Sheet1.A1:A19" Expected Results: In select Dialog, show "$#REF!.A1:Sheet1.A19"
(In reply to Kevin Suo from comment #12) > Actual Results: > In select Dialog, show "$Sheet1.A1:A19" > > Expected Results: > In select Dialog, show "$#REF!.A1:Sheet1.A19" The other way round ;)
works OK indeed in 4.0.6 > regression
Created attachment 138696 [details] tail of terminal output from bibisect Working on debian-buster in the till54 bibisect repository, I see that the the bug came into LO somewhere in the 56 or so commits: commit date s-h -------- ---------- -------- good 2bb2885d 2017-04-19 e175f9f4 bad e3c4358c 2017-04-20 d11746a8 In that range I notice commit ca8f4a66 Resolves: tdf#90799 generate absolute sheet for pointer-selected references". I am removing keyword bibisectRequest and adding bibisected.
@erack: (In reply to Terrence Enger from comment #15) > In that range I notice commit ca8f4a66 Resolves: tdf#90799 generate > absolute sheet for pointer-selected references". can you please have a look?
/me noting that the patch is from 2017-04-19, I don't expect it influences 4.2.0, but ..;)
Hi all, issue still present in LO 6.1.0.0.alpha0+ Build ID: 6fc9d4a482ab50a1bf8fefb1dae2a6ded3c7e3dd CPU threads: 2; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-01-24_04:37:19 Locale: fr-FR (fr_FR); Calc: CL when the VLOOKUP function is located in a sheet located after the lists where to search.
Laurent BP committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d69017c8a17be21657ea7ab9d37023ee59116799 tdf#72440 Abs sheet ref must be given 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.
Laurent BP committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c5647bd503b1d72229492b55257b0e3eb8f42464&h=libreoffice-6-0 tdf#72440 Abs sheet ref must be given 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.
Laurent BP committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=505832b92e0e2a395ef22424de33168a76bcc2c3&h=libreoffice-5-4 tdf#72440 Abs sheet ref must be given 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.
Verified fixed on LibreOffice 6.0.2.0+ and master, both built at home under Ubuntu 16.04 x86-64. Thank you very much for this patch. Best regards. JBF
Work as aspected with LO 6.1.0.0.alpha0+ Build ID: 3c913c3844acae8ee0d80ab174133bdc7677efea CPU threads: 2; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-02-14_00:19:27 Locale: fr-FR (fr_FR); Calc: CL Thank you Laurent.
*** Bug 115721 has been marked as a duplicate of this bug. ***
*** Bug 116691 has been marked as a duplicate of this bug. ***
*** Bug 116922 has been marked as a duplicate of this bug. ***