https://bugs.documentfoundation.org/show_bug.cgi?id=159467
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |108827 --- Comment #7 from ady <[email protected]> --- (In reply to Balázs Varga (allotropia) from comment #6) > In Calc if an inner, embedded function gives back an error (like #N/A) the > evaluation of the full formula will stop after the inner function. This is > the basic work of the functions in Calc and also in Excel. But the XLOOKUP > is an exception in excel. :) Thank you for the explanation. Then this is not just the case of (a second) chained XLOOKUP, but any such inner error case would trigger the unexpected result (in comparison to what other tools do). Considering that compatibility in Calc in general, and for this function in particular, is very important, then Calc should have the same way of dealing with XLOOKUP() as Excel regarding errors. @X1sc0, this should also be important for regression tests (at the appropriate time, whenever they will be introduced). FWIW, as I mentioned in comment 4, I have tested 2 other spreadsheet tools that provide the same result as Excel. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
