https://bugs.documentfoundation.org/show_bug.cgi?id=89013
Bug ID: 89013 Summary: Regular expressions doesn't work with MATCH and VLOOKUP when searched range is in other file. Product: LibreOffice Version: Inherited From OOo Hardware: Other OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Spreadsheet Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mari...@miguelangel.mobi Created attachment 113022 --> https://bugs.documentfoundation.org/attachment.cgi?id=113022&action=edit Source data file MATCH and VLOOKUP don't work when the look up array is in other file. It works without regular expression, and seems doesn't matter how the options for regular expression are in Menu/Tools/Options/LibreOffice calc/Calculate. Attached source data file, and in the next comment target file. All versions affected and Aoo 4.1 Strange this issue hasn't been reported. At least I can find it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs