Bug 164998 - ISERROR(LET(...)) creates an array formula unconditionally
Summary: ISERROR(LET(...)) creates an array formula unconditionally
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency tree / graph
 
Reported: 2025-02-02 14:51 UTC by Mike Kaganski
Modified: 2025-02-14 11:26 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2025-02-02 14:51:33 UTC 
In A1, type "=ISERROR(LET(a;1;a))" (without quotes), and press Enter (without any modifiers). Check the formula in A1.

Besides the unexpected result of TRUE (which is bug 164997), the formula in A1 is unexpectedly the array formula (i.e., it's shown in braces, like "{=ISERROR(LET(a;1;a))}").
Comment 1 Roman Kuznetsov 2025-02-02 19:11:57 UTC 
no repro in 24.8.0.3

but repro in

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a8ec21adf255b70bb6eeb0a1717190df303d8b26
CPU threads: 16; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded

=> regression
Comment 2 Roman Kuznetsov 2025-02-02 19:13:10 UTC 
No repro in

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 16; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded

too
Comment 3 Gabor Kelemen (allotropia) 2025-02-03 21:31:26 UTC 
I can not reproduce a different behavior since implementation in 

https://git.libreoffice.org/core/+/521a56d8d1e12b7471fda6b62b21d51776c9fbaf%5E%21
tdf#137543 - Add new LET function to Calc

If I press F2 and paste the formula, it always becomes an array formula.
If I press Ctrl-V, press OK on the Import Options dialog, it becomes a normal formula.

Maybe you saw this difference? But these are consistent ever since the commit above. Clearing keywords.

(In reply to Roman Kuznetsov from comment #2)
> No repro in
> 
> Version: 25.2.0.3 (X86_64) / LibreOffice Community
> Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
> CPU threads: 16; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
> Skia/Vulkan; VCL: win
> Locale: ru-RU (ru_RU); UI: ru-RU
> Calc: CL threaded
> 
> too