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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=71325

Holger Klene <h.klene at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |h.klene at gmx.de

--- Comment #13 from Holger Klene <h.klene at gmx.de> ---
Created attachment 140986
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140986&action=edit
strange index value error

I'm having trouble to make the returned arrays intersect with the current row.
It works for non-empty cells, but fails on empty cells (red in the given
document).

I thought it is due to the strange behavior of the function wizard sometimes
giving the result as a preview or failing with a value error. So clicking
different locations inside the function wizard it will suck up parameters or
add spaces.

But trying to replicate this manually, I could not make it work. Only
explicitly giving row and column solved it.

Could you please have a look at my instructions in the given document, if you
can reproduce the strange screenshots also embedded in the document?

Thanx

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180330/5c865e95/attachment-0001.html>