https://bugs.documentfoundation.org/show_bug.cgi?id=146391
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #4 from Eike Rathke <er...@redhat.com> ---
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.
