[Libreoffice-bugs] [Bug 118561] Calc: How to do this special lookup in external file? Arrays on IF function.
https://bugs.documentfoundation.org/show_bug.cgi?id=118561
Eike Rathke changed:
What|Removed |Added
Assignee|libreoffice-b...@lists.free |er...@redhat.com
|desktop.org |
Status|NEW |ASSIGNED
--- Comment #10 from Eike Rathke ---
This boils down to an external reference not being supported in the THEN or
ELSE paths of an IF jump if in array/matrix mode. Short reproducer:
=IF('problem_2_external_file.ods'#$external_data.B$1:B$9=B14,'problem_2_external_file.ods'#$external_data.C$1:C$9)
entered in any cell of problem_2_main_file.ods as array formula (closed with
Shift+Ctrl+Enter) for the preselected fruits case in B14 displays the first 5
values as Err:502 (which should be the matching 5 fruits) followed by 4 values
FALSE (as there are no more matches for fruits in the range).
Taking.
--
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 118561] Calc: How to do this special lookup in external file? Arrays on IF function.
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 Xisco Faulí changed: What|Removed |Added Version|5.3.7.2 release |4.1 all versions CC||er...@redhat.com, ||winfrieddonkers@libreoffice ||.org, ||xiscofa...@libreoffice.org OS|Windows (All) |All --- Comment #9 from Xisco Faulí --- Reproduced back to Version: 4.1.0.0.alpha0+ Build ID: 64dafbe584fe7644ec29b96b6a9a9588ba4619b @Eike, @Winfried, I thought you could be interested in this issue... -- 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 118561] Calc: How to do this special lookup in external file? Arrays on IF function.
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 m.a.riosv changed: What|Removed |Added Summary|Calc: How to do this|Calc: How to do this |special lookup in external |special lookup in external |file? |file? Arrays on IF ||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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #8 from m.a.riosv --- Version: 6.2.0.0.alpha0+ Build ID: 67c88e284af74c88e37cc8f66cdfc0e346de45ac CPU threads: 4; OS: Windows 10.0; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2018-06-19_23:41:55 Locale: es-ES (es_ES); Calc: CL -- 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #7 from m.a.riosv --- Created attachment 143337 --> https://bugs.documentfoundation.org/attachment.cgi?id=143337=edit Sample showing the issue on the IF function issue with array to external file for the IF function on THEN or OTHERWISE (Using the same linked 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #6 from marcusman --- Created attachment 143336 --> https://bugs.documentfoundation.org/attachment.cgi?id=143336=edit 4th screenshot (4 of 4) -- 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #5 from marcusman --- Created attachment 143334 --> https://bugs.documentfoundation.org/attachment.cgi?id=143334=edit 3rd screenshot (3 of 4) -- 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #4 from marcusman --- Created attachment 14 --> https://bugs.documentfoundation.org/attachment.cgi?id=14=edit 2nd screenshot (2 of 4) -- 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #3 from marcusman --- Created attachment 143332 --> https://bugs.documentfoundation.org/attachment.cgi?id=143332=edit 1st screenshot (1 of 4) -- 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #2 from marcusman --- Created attachment 143331 --> https://bugs.documentfoundation.org/attachment.cgi?id=143331=edit simple testcase - second (external) .ods 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 118561] Calc: How to do this special lookup in external file?
https://bugs.documentfoundation.org/show_bug.cgi?id=118561 --- Comment #1 from marcusman --- Created attachment 143330 --> https://bugs.documentfoundation.org/attachment.cgi?id=143330=edit simple testcase - first (main) .ods 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
