Summary: | Incorrect return of data from MATCH function referencing a sheet in another document. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Don Anderson <don.anderson.pub> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | miguelangelrv, oliver.brinzing |
Priority: | medium | ||
Version: | 6.2.7.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | macOS (All) | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=89013 https://bugs.documentfoundation.org/show_bug.cgi?id=96280 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
PDF of correct results
PDF of erroneous results PDF of erroneous results with recalculate Spreadsheet that fails Explanation of MATCH function usage. File with incorrect result, see row 3 Supporting file Supporting file Supporting file Supporting file Supporting file Supporting file Supporting file Supporting file |
Description
Don Anderson
2019-09-11 01:01:09 UTC
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
|