https://bugs.documentfoundation.org/show_bug.cgi?id=147685
Bug ID: 147685 Summary: Wildcard in a formula with reference to another workbook not working Product: LibreOffice Version: 7.2.5.2 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: snowboard...@gmail.com Description: Using a wildcard such as * in a formula with reference to another workbook does not work. Steps to Reproduce: 1. Insert below data in an empty spreadsheet document and save it as "example.ods" Cell A1: "ABC" Cell A2: "DEF" Cell A3: "GHI" 2. Create a new spreadsheet, and input a formula at cell A1 as below =MATCH("D*",'example.ods'#$Sheet1.A1:A3,0) 3. The expected return value is 2, however, it returns #N/A. Actual Results: #N/A Expected Results: 2 Reproducible: Always User Profile Reset: No Additional Info: None -- You are receiving this mail because: You are the assignee for the bug.