https://bugs.documentfoundation.org/show_bug.cgi?id=169718
Bug ID: 169718
Summary: Seems like a bug with the LET() formula
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.