https://bugs.documentfoundation.org/show_bug.cgi?id=106151
Bug ID: 106151
Summary: Add a new CELL function for Excel compatibility
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Help for CELL function in LibreOffice :
"Reference (list of options) is the position of the cell to be examined. If
Reference is a range, the cell moves to the top left of the range. If Reference
is missing, LibreOffice Calc uses the position of the cell in which this
formula is located. Microsoft Excel uses the reference of the cell in which the
cursor is positioned."
OASIS specification :
"R : if R is a reference to a cell, it is the cell whose information will be
returned; if R is a reference to a range, the top-left cell in the range is the
selected one; if R is omitted, the current cell is used."
My poor english does not allow me to know if the specifications are met.
What is the meaning of "Current cell"?
Cell where is the formula or active cell...
If we keep CELL how it works in LO and AOO, it should be good to have a new
CELL.XL for compatibility.
--
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
