[Libreoffice-bugs] [Bug 138070] CELL function does not work as described.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jerzy Moruś <yestok at yestok.pl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #2 from Jerzy Moruś <yestok at yestok.pl> ---
Function CELL have a 2 arguments. First is "type of information" and must be
written in quotation marks, but only when is written directly like text. In my
example this arguments are written in first row (from column F to I) and are
passed as a cell reference. 
The ranges are colored cells. They have names Opel, Opel2 and Opel3 (look at
Sheet -> Names cells adnd references).

Reproduce the problem. In cell e.g. E12, write formula =CELL("address";A1:B2)
The description of the function says that the result should be the address of
cell A1 (upper left corner of the range). However, this is not the case and we
get #VALUE !
The results (but incorrect, not the top right corner) appear only for a vector
region, only in cells that match the rows or columns of the vector (see
attatchment).

-- 
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/20201112/fab1b6a8/attachment-0001.htm>