https://bugs.freedesktop.org/show_bug.cgi?id=71589
--- Comment #7 from John Smith <[email protected]> --- (In reply to comment #4) > String was always "E" in double quotes and never in single quotes. With 'E' > in single quotes it is a column/row label, looked up in the defined labels > (Insert->Names->Labels...) or as sheet cell content, which depends on the > position of the formula cell and if a range or an automatic intersection is > to be obtained in context. As seen on the screenshot that can't work in this > case because the formula is entered in the same column so no intersection > can be obtained to resolve to a single cell search criterion. If this > appeared to work in other cases it probably was due to luck that the formula > cell and the column label formed the proper intersection. Sorry but I don't follow the explanation above. If E is entered as the search criterion, in double quotes as "E", the result returned is an error. It should be found in the search vector A2:D2 in column D. The function should then return the contents from column D from the result vector A6:D6 shouldn't it? The position of the formula makes no difference. It can be moved around the sheet with the same error result. You can replace the "E" with the word "cow" and you still get an error. If you replace the contents of the search vector's cells with text entries, then the correct result is returned. See the two new attachments which are screenshots illustrating these points. I believe this is a bug, and request that it be re-opened. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
