https://bugs.documentfoundation.org/show_bug.cgi?id=166610
Bug ID: 166610
Summary: IFERROR() wrongly treats valid LET() expressions as
errors
Product: LibreOffice
Version: 24.8.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: thomas.bern...@gmx.net
Description:
In LibreOffice Calc (tested with version 24.8.7.2 Community Edition), the
IFERROR() function incorrectly evaluates valid LET() expressions as errors and
triggers the fallback value, even though the expression itself calculates
correctly outside of IFERROR().
Steps to Reproduce:
1.Enter the following formula in a Calc cell:
=IFERROR(LET(x;1;x+1);"LibreOffice too old")
Actual Results:
The formula returns "LibreOffice too old" as if an error had occurred.
Expected Results:
The formula should return 2.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The LET() function works correctly on its own.
Example:
=LET(x;1;x+1) → returns 2
This behavior occurs regardless of whether it's used as an array formula or
regular formula.
The bug is not related to formatting, cell type, or other wrappers like
TEXT()—they were tested and ruled out.
The workaround using IF(ISERROR(...);...;...) works correctly.
Workaround:
=IF(ISERROR(LET(x;1;x+1));"LibreOffice too old";"LET() works")
--
You are receiving this mail because:
You are the assignee for the bug.
