https://bugs.documentfoundation.org/show_bug.cgi?id=160711
Bug ID: 160711
Summary: problems with LOOKUP function in search for empty cell
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rb.hensc...@t-online.de
Created attachment 193730
--> https://bugs.documentfoundation.org/attachment.cgi?id=193730&action=edit
File for testing
Open attached document. It shows the used formula and right from it as text how
the formula looks in Excel and how the result looks in Excel.
Notice, that XLOOKUP as parameter in CELL does not work at all.
Correct the formula of the CELL function rows to the value shown as text.
Still there is no result.
Save the file into ods format and open the ods file. Notice that now none of
the formulas has a result.
I have tested it with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice
Community
Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997
CPU threads: 32; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
