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
