[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.documentfoundation.org/show_bug.cgi?id=71325 Holger Klene changed: What|Removed |Added CC||h.kl...@gmx.de

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.documentfoundation.org/show_bug.cgi?id=71325 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.documentfoundation.org/show_bug.cgi?id=71325 --- Comment #11 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.documentfoundation.org/show_bug.cgi?id=71325 --- Comment #10 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #8 from raal r...@post.cz --- According to comment 7 should be Component = Documentation? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 Ady ady...@hotmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #6 from John Smith clicks...@yahoo.co.uk --- (In reply to comment #5) (In reply to comment #3) Perhaps this can be put forward as a bug to have the Array check-box automatically selected as it is for functions such as MMULT,

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #7 from Ady ady...@hotmail.com --- (In reply to comment #6) I believe this should be an array formula. The first argument, 'reference' is always required. Only as 'array' is a result returned when this parameter is used on its own.

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #3 from John Smith clicks...@yahoo.co.uk --- (In reply to comment #2) I think the issue is the help may need a better explanation. When the range has more than one row or column, respective default options or zero value need to

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #4 from mariosv mari...@miguelangel.mobi --- If you are agree, please adapt the title and change the importance from normal to enhancement. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #5 from Ady ady...@hotmail.com --- (In reply to comment #3) Perhaps this can be put forward as a bug to have the Array check-box automatically selected as it is for functions such as MMULT, GROWTH and TREND I have to disagree.

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 --- Comment #1 from Ady ady...@hotmail.com --- I confirm inadequate behavior, in LO 4.1.3.2 on Windows. Additionally, explicitly using zero values for row and/or column (instead of leaving them empty, which should be equivalent to zero according

[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

https://bugs.freedesktop.org/show_bug.cgi?id=71325 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO