[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 Eike Rathke changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #4 from Eike Rathke --- Note: I did not enable macros for the document so cell results may vary. Just analyzing the structure. Budget.E22:E24 try HLOOKUP() in the range's $jan_EIN.$c$9:$jan_EIN.$zz$14 first row so $jan_EIN.$c$9:$zz$9 but there is only some sparse content in that row and the rest is empty, in particular already C9, thus that row's content is not sorted ascending, which it would have to be if HLOOKUP() 4th argument is not given or not 0, otherwise the result is arbitrary. Similar for Budget.H22:H24. See https://help.libreoffice.org/7.4/en-GB/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3151001 That *can't* work. It may already work if you change the HLOOKUP() functions passing a 4th argument 0, like in Budget.E22 =HLOOKUP($B22;INDIRECT(D$1):INDIRECT(E$1);5;0) Not a bug. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 --- Comment #3 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 --- Comment #2 from rupert.graspeunt...@gmail.com --- Created attachment 177123 --> https://bugs.documentfoundation.org/attachment.cgi?id=177123=edit the error can be reproduced on tables "bezeichnung" and "Budget" to vary the occurrence of the error, in Table "Bezeichnung" modify Cells A23, A24, A25 you can see the result in Table "Budget",Cells e.g. e23, e24, e25 If you add in Table "Bezeichnung", Cell A21 a space as the first character, Table "Budget",Cells e.g. e23, e24, e25 show correct results -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146391] hlookup: when the search criteria contains a number, the search result will be NV
https://bugs.documentfoundation.org/show_bug.cgi?id=146391 Xisco FaulĂ changed: What|Removed |Added CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Xisco FaulĂ --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) -- You are receiving this mail because: You are the assignee for the bug.