Bug 169718 - Seems like a bug with the LET() formula
Summary: Seems like a bug with the LET() formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-28 06:18 UTC by aydsys
Modified: 2025-11-28 20:44 UTC (History)
3 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 aydsys 2025-11-28 06:18:34 UTC 
Description:
This works:
=LET(rs; ROWS( OFFSET(A1;0;0;3) );  rs )

but this does not:
=LET(rs; OFFSET(A1;0;0;3);  rows(rs) )

Steps to Reproduce:
1.put "=LET(rs; OFFSET(A1;0;0;3);  rows(rs) )" inside a cell

Actual Results:
#VALUE!

Expected Results:
number of rows


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.8.3.2 (X86_64) / LibreOffice Community
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
Comment 1 Werner Tietz 2025-11-28 08:50:37 UTC 
Cannot confirm!

Both Formulas return the expected result ⇒ 3

```
Version: 25.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
Comment 2 aydsys 2025-11-28 09:19:31 UTC 
OS: Fedora Linux
Comment 3 Xisco Faulí 2025-11-28 09:37:03 UTC 
I can reproduce it in

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fdcc566a017e1b107723b8b40a18088e19a31f04
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded

@Balazs, I thought you might be interested in this issue
Comment 4 Werner Tietz 2025-11-28 12:26:31 UTC 
(In reply to Xisco Faulí from comment #3)
> I can reproduce it in
> 
> Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: fdcc566a017e1b107723b8b40a18088e19a31f04
> CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
> Locale: es-ES (es_ES.UTF-8); UI: en-US
> Calc: threaded
> 
> @Balazs, I thought you might be interested in this issue

oh… I see now a tiny differnce between the 2 Formulas:
the first doesnt need triggerd as arrayformula!
the second needs triggered as arrayformula!

if you edit the second inside the Formulawizard its goes itself to array-mode.
Comment 5 Telesto 2025-11-28 20:44:33 UTC 
I don't grasp why this bug being set RESOLVED NOTABUG. Appears to be accidental