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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138070
           Summary: CELL function does not work as described.
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: yestok at yestok.pl

Created attachment 167097
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167097&action=edit
Result of using the CELL function with a range reference

The function description is as follows:Returns information on a cell such as
its address, formatting (...). Reference is the address of the cell to be
examined. If Reference is a range, the cell reference moves to the top left of
the range. If Reference is missing, Calc uses the position of the cell in which
this formula is located. 

This description is discordant for 2D range and vector's range.
When reference is a 2D range, result is allways  #VALUE!. When reference is a
vector, the result is displayed only when the formula is stored in the rows or
columns corresponding to the range.
An example is attached

-- 
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/20201108/e94cf3c1/attachment.htm>