Bug 147685 - Wildcard in a formula with reference to another workbook not working
Summary: Wildcard in a formula with reference to another workbook not working
Status: RESOLVED DUPLICATE of bug 89013
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-27 09:51 UTC by snowboard975
Modified: 2022-07-31 03:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description snowboard975 2022-02-27 09:51:30 UTC 
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
Comment 1 raal 2022-07-30 23:03:30 UTC 
Hello,

Thank you for submitting the bug. The bug has previously been reported, so this bug will be added as a duplicate of it. You will automatically be CCed to updates made to the other bug.

*** This bug has been marked as a duplicate of bug 89013 ***