[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

--- Comment #7 from Eike Rathke  ---
It's not fixed, the commits were only related to comment 3 case #1.
Missing is the actual behaviour that Excel either ignores error values (or just
#DIV/0! in this case?) or internally sorts an array before evaluating.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org

--- Comment #6 from Xisco Faulí  ---
A polite ping to Eike Rathke:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ?
Otherwise, Could you please explain what's missing?
Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

--- Comment #5 from Commit Notification 
 ---
Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-6-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=cc2c11c2e4a99adf00d184507d6925c9af37e1bd=libreoffice-6-1

Related: tdf#117016 DoubleRefToVars: always put in order

It will be available in 6.1.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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.2.0|target:6.2.0 target:6.1.0.2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.2.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

--- Comment #4 from Commit Notification 
 ---
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=6db5e1bdd67531fab14b375d6c624237d38de297

Related: tdf#117016 DoubleRefToVars: always put in order

It will be available in 6.2.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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Eike Rathke  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||6216

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
   Hardware|x86-64 (AMD64)  |All
Version|6.0.3.2 release |Inherited From OOo
 Ever confirmed|0   |1

--- Comment #3 from Eike Rathke  ---
This is almost a duplicate of bug 116216 but with two additional quirks.

0. Use master / 6.1 alpha as a prerequisite for the following
1. Instead of
   =LOOKUP(2,1/(NOT(ISBLANK(A1:A$1))),A1:A$1)
   write
   =LOOKUP(2,1/(NOT(ISBLANK(A$1:A1))),A$1:A1)
   and pull/copy that down.
   It seems the wrong order in the references adds to some confusion,
   e.g. if
   =LOOKUP(2,1/(NOT(ISBLANK(E6:E$3))),E6:E$3)
   in G6 is replaced with
   =LOOKUP(2,1/(NOT(ISBLANK(E$3:E6))),E$3:E6)
   the expected result is returned.
   Having done so, the formulas in the range G3:G6 return the expected
   result.
2. The lookup-vector has to be sorted, and error values usually sort
   behind numeric and string values. Starting from G7 down the vector is
   not sorted anymore as it is {1,#DIV/0,#DIV/0,#DIV/0,1,...} which
   yields arbitrary results when queried with a binary search algorithm.
   2a) Excel seems to either completely ignore error values in the case
   of LOOKUP, at least in this constellation, or it ignores that the
   range is not strictly sorted.
   This seems to be nowhere specified. It just "happens" to be an
   implementation detail. In fact in OOXML ECMA-376-1:2016
   18.17.7.202 LOOKUP error values are not mentioned at all. (which
   they are also not for 18.17.7.343 VLOOKUP but appear to be
   significant there).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

raal  changed:

   What|Removed |Added

 OS|Mac OS X (All)  |All

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=117016

raal  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||r...@post.cz,
   ||winfrieddonkers@libreoffice
   ||.org
Summary|Formula to Get value of |Formula to Get value of
   |last non-empty cell does|last non-empty cell does
   |not return expected result  |not return expected result
   ||(lookup function)

--- Comment #2 from raal  ---
It works in excel, not in LO. Confirm with Version: 6.1.0.0.alpha0+
Build ID: 5289441ffa227f5f358ca4dc28df416be922aa66
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 


https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html
https://exceljet.net/formula/get-value-of-last-non-empty-cell

Not sure if it's bug or not. Adding cc to devs.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs