[Libreoffice-bugs] [Bug 106151] Add a new CELL() function for Excel compatibility

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from hardcoder <hecho at live.co.uk> ---
In fact Excel help isn't precise about what happens when the second parameter
isn't given. Despite not documented, Ms is aware of that behavior and didn't
change it with time; instead, it was replicated in Excel Online and Excel
Mobile (for Windows). Others are aware of the behavior too, besides LibreOffice
Help. In WPS Office, CELL function works the same way.

Although I don't think this is the best place for such functionality, I'd be
one more to ask for LibreOffice to implement it the way Excel did, as you
didn't invent the function, and you support .xls and .xslx formats.

That feature can be useful for user interaction without requiring macros.
(Functions are way more cross-platform and straightforward than macros in an
additional language, which often defeats the purpose of choosing spreadsheet.)
For example, the user can select a cell in a large table and get extra info
about that value, or via conditional formatting, similar values can be
highlighted (this works in Excel 2010 and Excel Online).

-- 
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/20190812/94446677/attachment.html>