[Libreoffice-bugs] [Bug 132105] New: Certain functions fail with external references

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132105

            Bug ID: 132105
           Summary: Certain functions fail with external references
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: villeroy at t-online.de

Description:
See attached files. 
COUNTBLANK('file:///path/source.ods'#Sheet.A1:A99) fails with Err:504
Match(A1 ; 'file:///path/source.ods'#Sheet.A1:A99 ; 0) fails with #N/A if the
matching value is a nummber.

Tested with LO 6.0 (Ubuntu PPA), LO 6.4 
AOO 4.1.7 shows the 2 Err:504 with COUNTBLANK but not the #N/A error with
MATCH.

Steps to Reproduce:
1. Put both attachments into one directory
2. Open both files
3. Update links of links.ods

Actual Results:
3 Error values in links.ods

Expected Results:
No error values.


Reproducible: Always


User Profile Reset: No



Additional Info:
No more info

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200414/d04168e6/attachment-0001.htm>