[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #23 from Don Anderson --- Created attachment 154882 --> https://bugs.documentfoundation.org/attachment.cgi?id=154882=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #22 from Don Anderson --- Created attachment 154881 --> https://bugs.documentfoundation.org/attachment.cgi?id=154881=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #21 from Don Anderson --- Created attachment 154880 --> https://bugs.documentfoundation.org/attachment.cgi?id=154880=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #20 from Don Anderson --- Created attachment 154879 --> https://bugs.documentfoundation.org/attachment.cgi?id=154879=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #19 from Don Anderson --- Created attachment 154878 --> https://bugs.documentfoundation.org/attachment.cgi?id=154878=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #18 from Don Anderson --- Created attachment 154877 --> https://bugs.documentfoundation.org/attachment.cgi?id=154877=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #17 from Don Anderson --- Created attachment 154876 --> https://bugs.documentfoundation.org/attachment.cgi?id=154876=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #16 from Don Anderson --- Created attachment 154875 --> https://bugs.documentfoundation.org/attachment.cgi?id=154875=edit Supporting file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 Don Anderson 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 --- Created attachment 154874 --> https://bugs.documentfoundation.org/attachment.cgi?id=154874=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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 Alex Thurgood changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED --- Comment #14 from Alex Thurgood --- *** This bug has been marked as a duplicate of bug 89013 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #13 from Alex Thurgood --- (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". -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 Alex Thurgood changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=96 ||280 --- Comment #12 from Alex Thurgood --- It could also be a duplicate of bug 96280, which describes erratic behaviour of the MATCH function. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 Alex Thurgood changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=89 ||013 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 Alex Thurgood changed: What|Removed |Added Version|3.6.7.2 release |6.2.7.1 release --- Comment #11 from Alex Thurgood --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #10 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #9 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #8 from Don Anderson --- Created attachment 154121 --> https://bugs.documentfoundation.org/attachment.cgi?id=154121=edit Explanation of MATCH function usage. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #7 from m.a.riosv --- I can't find any MATCH on the sample file. Verify there are the same options on Menu/Tools/Options/LibreOffice calc/Calculate -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #6 from Don Anderson --- Created attachment 154109 --> https://bugs.documentfoundation.org/attachment.cgi?id=154109=edit Spreadsheet that fails -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #5 from m.a.riosv --- Sorry but pdfs can't help in this case, a minimal spreadsheet sample file where to reproduce the issue is needed. Thks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #4 from Don Anderson --- Created attachment 154107 --> https://bugs.documentfoundation.org/attachment.cgi?id=154107=edit PDF of erroneous results with recalculate -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #3 from Don Anderson --- Created attachment 154106 --> https://bugs.documentfoundation.org/attachment.cgi?id=154106=edit PDF of erroneous results -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 --- Comment #2 from Don Anderson --- Created attachment 154105 --> https://bugs.documentfoundation.org/attachment.cgi?id=154105=edit PDF of correct results -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127487] Incorrect return of data from MATCH function referencing a sheet in another document.
https://bugs.documentfoundation.org/show_bug.cgi?id=127487 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEEDINFO --- Comment #1 from m.a.riosv --- Please attach a sample file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs