https://bugs.documentfoundation.org/show_bug.cgi?id=106151
Carlos <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
--- Comment #2 from Carlos <[email protected]> ---
(In reply to m.a.riosv from comment #1)
> I think LibreOffice help information it's clear
>
> https://help.libreoffice.org/index.php?title=Calc/
> Information_Functions&Language=en-US&System=WIN&Version=5.4#bm_id3159412
> "
> 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.
> "
>
> BTW on the top it's possible select the language.
LibreOffice help is clear. But GerardF is correct that the function is not 100%
compatible with MS Excel.
By the way the current MS Excel help
http://web.archive.org/web/20170403173356/https://support.office.com/en-us/article/CELL-function-51BD39A5-F338-4DBE-A33F-955D67C2B2CF?ui=en-US&rs=en-US&ad=US
states that if the reference is missing, the CELL function uses the reference
for "the last cell that was changed".
--
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
