[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Don Anderson <don.anderson.pub at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #154105|0                           |1
        is obsolete|                            |
 Attachment #154106|0                           |1
        is obsolete|                            |
 Attachment #154107|0                           |1
        is obsolete|                            |
 Attachment #154109|0                           |1
        is obsolete|                            |

--- Comment #15 from Don Anderson <don.anderson.pub at gmail.com> ---
Created attachment 154874
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154874&action=edit
File with incorrect result, see row 3

I am send a folder with a set of nine(9) .ods file which consistently produce
the erroneous results on ver 6.2.7.1 and 6.3.1.2.  They seem to run correctly
on ver 6.2.5.2.  For the purpose of this problem report the sheets are filed
with random numbers except for the first column with sequential dates.

The Risk/Return Data.ods file accesses the eight(8) other files via a hard
coded "='file:///Users/donanderson/Desktop/Problem/Stock Market SSO-SDS
2006.ods'#$Control.$B$9" path in row 3. The name of the file changes with each
column.

The correct results from ver 6.2.5.2 are B3, 4979; C3, 4979; D3, 4145; E3,
3354; F3, 3354; G3, 3354; H3, 3354; I3, 3339.

Ver 6.2.7.1 and 6.3.1.2 produce B3, 4979; C3, 4979; D3, 4145; E3, 3354; F3,
4979; G3, 4979; H3, 4979; I3, 4979.

-- 
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/20191009/c7b7ff02/attachment.html>