I’m using LibreOffice Calc Version: 6.3.6.2 (x64) Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
Tried to locate a column in a different file with the MATCH function using a regular expression for further processing with OFFSET but got “#N/A” instead of a position value. The option "enable regular expressions in formulas is switched on for both files.
To reproduce the problem I created two simplified files:
-
C:\fakepath\TestMATCHfunction.ods|attachment TestMATCHfunction.ods contains the tested MATCH functions and local data in the same and a different sheet -
C:\fakepath\TestMATCHdata.ods|attachment TestMATCHdata.ods contains a copy of the data sheet in a different file
The cells with a MATCH function for the file TestMATCHdata.ods show “#N/A”.
This is the first time, that I place a question. So if I should prepare it in a better way, please let me know. I tried to search for this problem. If this is “works as designed” or a known bug, please let me know as well. I don’t want to spoil your time with questions which are already answered.(Is it possible to delete the files /upfiles/16127844378870018.ods and /upfiles/1612784609101015.ods as they contain the wrong file path in the formulas?)
Thank you so much for your effort.
[Edit - Opaque] Made /upfiles/16127852609473133.ods a real link to a file and marked strikethrough what I understand OP assumes to be incorrect sample files.
