https://bugs.documentfoundation.org/show_bug.cgi?id=174206
Bug ID: 174206
Summary: Possible regression: IFERROR inside LET does not catch
a bound error
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Steps to reproduce:
In a new Calc document, enter:
1. A1: =IFERROR(NA();7)
2. A2: =LET(t;NA();IFERROR(t;7))
Use commas instead of semicolons if required by your separator settings.
Actual results:
A1 returns 7; A2 returns #N/A.
Expected results:
Both cells return 7, as confirmed in LibreOffice 26.8.1.1 on Windows
(Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1) and Excel.
Reproduced by manual entry in this development build:
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: 27da0c9e2f4d1af401a9a759dde0b8385dacafe2
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
