[Libreoffice-bugs] [Bug 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800
--- Comment #7 from Oliver Brinzing ---
Created attachment 155861
--> https://bugs.documentfoundation.org/attachment.cgi?id=155861=edit
INDEX_test1_with_semicolon.xlsx
(In reply to knittel from comment #6)
> Created attachment 155829 [details]
> inconsistency in function wizard marked
>
> marked important stuff with red circles ;)
i checked with excel 2016:
F9:H9 =INDEX(range2;1) -> {1,1,1}
B9:D9 =INDEX(range1;1) -> REF!
D17:D19 =INDEX(range1;1) -> REF!
but i think i found the root case:
excel needs a trailing semicolon:
F9:H9 =INDEX(range2;1;) -> {1,2,3}
B9:D9 =INDEX(range1;1;) -> {1,2,3}
D17:D19 =INDEX(range1;1;) -> {1,1,1}
and adding a ";" in LO makes F9:H9 work too:
F9:H9 =INDEX(range2;1;) -> {1,2,3}
@eike: you might be interested in this
--
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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 knit...@mailbox.org changed: What|Removed |Added Attachment #155815|0 |1 is obsolete|| --- Comment #6 from knit...@mailbox.org --- Created attachment 155829 --> https://bugs.documentfoundation.org/attachment.cgi?id=155829=edit inconsistency in function wizard marked marked important stuff with red circles ;) -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 knit...@mailbox.org changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 --- Comment #5 from knit...@mailbox.org --- i would also like to emphasize, that these are probably two separate problems? one is the handling of the parameters and the other one is, that the function wizard / tooltip is inconsistent with the actual usage of parameters in the formula. -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 --- Comment #4 from knit...@mailbox.org --- Created attachment 155828 --> https://bugs.documentfoundation.org/attachment.cgi?id=155828=edit INDEX comparison of same formulas with different ranges. example file for clarification. -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 Oliver Brinzing changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #3 from Oliver Brinzing --- Thank you for reporting the bug. I added an excel example spreadsheet, it seems excel calculates same way. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #2 from Oliver Brinzing --- Created attachment 155825 --> https://bugs.documentfoundation.org/attachment.cgi?id=155825=edit index example -- 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 128800] INDEX function behaviour inconsistent with function wizard and 'tooltip'
https://bugs.documentfoundation.org/show_bug.cgi?id=128800 --- Comment #1 from knit...@mailbox.org --- an even more severe problem is that if you change the dimensions of the source range to/from a single column/row the INDEX function changes behaviour without notification. If source is a named ranged you are even less aware of the consequences of your change. aaand it's very incopatible to excels INDEX function: https://support.office.com/en-us/article/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd -- 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
