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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
