https://bugs.documentfoundation.org/show_bug.cgi?id=31577
Eike Rathke er...@redhat.com changed:
What|Removed |Added
Status|NEW |ASSIGNED
https://bugs.documentfoundation.org/show_bug.cgi?id=31577
Matthew Francis fdb...@neosheffield.co.uk changed:
What|Removed |Added
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=31577
--- Comment #20 from Phil Hibbs sna...@gmail.com ---
Confirming that this bug is still present in 4.4.0.3, both the original example
that returns a blank, and the example from comment 19 that returns the wrong
value from a VLOOKUP.
--
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #15 from Phil Hibbs sna...@gmail.com ---
Bug is still present.
Libre Office version: 4.3.2.2
Operating System: Windows 7 Enterprise SP1
I installed LiO fresh from the web site onto a new Windows 7 VM, followed my
original
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #16 from Phil Hibbs sna...@gmail.com ---
The same thing happens if I delete row 3 first and then type in the formula
with the INDIRECT function call - any row beyond the row that was deleted is
not found by the VLOOKUP.
While
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #17 from Phil Hibbs sna...@gmail.com ---
Created attachment 108347
-- https://bugs.freedesktop.org/attachment.cgi?id=108347action=edit
Screenshot of an incorrect result being returned
--
You are receiving this mail because:
You
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #18 from Phil Hibbs sna...@gmail.com ---
The same behaviour is also observed with the OFFSET function instead of
INDIRECT in step 4:
4. Put formula in B1 =VLOOKUP(A1,OFFSET($C$1,0,0,1048576,2),2,0)
--
You are receiving this mail
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #19 from Phil Hibbs sna...@gmail.com ---
Created attachment 108349
-- https://bugs.freedesktop.org/attachment.cgi?id=108349action=edit
Step 1 for incorrect result demonstration
I have isolated a set of steps that result in the
https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #14 from QA Administrators qa-ad...@libreoffice.org ---
Please read this message in its entirety before responding.
Your bug was confirmed at least 1 year ago and has not had any activity on it
for over a year. Your bug is still set
https://bugs.freedesktop.org/show_bug.cgi?id=31577
Michael Stahl mst...@redhat.com changed:
What|Removed |Added
Attachment #40805|application/octet-stream
https://bugs.freedesktop.org/show_bug.cgi?id=31577
Kohei Yoshida kohei.yosh...@suse.de changed:
What|Removed |Added
Assignee|kohei.yosh...@suse.de
11 matches
Mail list logo