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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
