https://bugs.documentfoundation.org/show_bug.cgi?id=163614
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|[email protected] |[email protected] |desktop.org | Status|NEW |ASSIGNED --- Comment #14 from Eike Rathke <[email protected]> --- The underlying problem is that data in ElectrodevArtNr_copy.ods is in Artikelregister.A7:E102 but the lookup uses $Artikelregister.A$7:A$110 i.e. encounters 8 empty rows at the end. That worked by accident with the old code that copied to an interim vector, where empty elements were implicitly converted to empty strings and strings compare greater than numeric, whereas the non-copied elements have the original empty elements and empty compares less than anything else, which then confuses the binary search that suddenly encounters a less-than value where a greater-or-equal value is expected. To fit and fix this, specifically for LOOKUP() empty elements must compare greater than anything else as is the case when sorting a range that contains empty cells, which sorts them to the end. -- You are receiving this mail because: You are the assignee for the bug.
