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.
Please attach a sample file.
Created attachment 154105 [details] PDF of correct results
Created attachment 154106 [details] PDF of erroneous results
Created attachment 154107 [details] PDF of erroneous results with recalculate
Sorry but pdfs can't help in this case, a minimal spreadsheet sample file where to reproduce the issue is needed. Thks.
Created attachment 154109 [details] Spreadsheet that fails
I can't find any MATCH on the sample file. Verify there are the same options on Menu/Tools/Options/LibreOffice calc/Calculate
Created attachment 154121 [details] Explanation of MATCH function usage.
[Automated Action] NeedInfo-To-Unconfirmed
Maybe in relation with this bug https://bugs.documentfoundation.org/show_bug.cgi?id=89013, but sorry, I don't know how to verify the issue here.
As we don't have the other referenced file "Stock Market SPY 2000.ods", this will be impossible to check/reproduce. Reading the various comments made by Don, it does seem to be a DUP of bug 89013. Why it worked correctly in 6252 and now no longer works in 6271 or 6312 is unknown, as the older bug has been around for a very long time.
It could also be a duplicate of bug 96280, which describes erratic behaviour of the MATCH function.
(In reply to Alex Thurgood from comment #11) > As we don't have the other referenced file "Stock Market SPY 2000.ods", this > will be impossible to check/reproduce. > Of course, I should have written, "without the other referenced files".
*** This bug has been marked as a duplicate of bug 89013 ***
Created attachment 154874 [details] 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.
Created attachment 154875 [details] Supporting file
Created attachment 154876 [details] Supporting file
Created attachment 154877 [details] Supporting file
Created attachment 154878 [details] Supporting file
Created attachment 154879 [details] Supporting file
Created attachment 154880 [details] Supporting file
Created attachment 154881 [details] Supporting file
Created attachment 154882 [details] Supporting file