[Libreoffice-bugs] [Bug 127487] New: 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

            Bug ID: 127487
           Summary: Incorrect return of data from MATCH function
                    referencing a sheet in another document.
           Product: LibreOffice
           Version: 3.6.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: don.anderson.pub at gmail.com

The the Calc document consists of one sheet which references and summarizes
sheets in 8 other documents.

This document/sheet works correctly in LibreOffice Calc 6.2.5.2.  It does not
work in 6.2.7 or 6.3.1.

In cell $B$3, $C$3, ...$I$3 is 'file:///Users/donanderson/Desktop/New
Highs/Stock Market SSO-SDS 2006.ods'#$Control.$B$9  The file name changes for
each of the 8 files.

In 'file:///...$Control.$B$9 is =MATCH(999999,$'Base Data'.$A$1:$'Base
Data'.$A$9999,1)  Column $A consists of dates in date sequence.  The purpose of
this function is to return the row number of the last entry in the 'Data Base'
sheet.

The first 4 'Data Base' sheets have columns A thru BT with various number of
rows(3334-4960) and return the correct value.  The last 4 'Data Base' sheets
have columns A thru CI with various number of rows (3319-3334) and return a 0
value (Date 12/30/1899).

When using 6.2.7 or 6.3.1 pressing Fn9 Recalculate multiple times will get the
correct value for some of the files sometimes.

This occurs with and without multi-threaded calculation enabled and with and
without Iterations.

-- 
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/20190911/2410c338/attachment-0001.html>