https://bugs.documentfoundation.org/show_bug.cgi?id=168297
Bug ID: 168297
Summary: LET()
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In LibreOffice Calc, you cannot assign ranges to LET variables if you intend to
use them with INDEX or MATCH. You need to replace all range variables with
OFFSET directly.
VARIABLE,CELL:INDEX(CELL:CELL,CELL) result it #VALUE!
VARIABLE, OFFSET(CELL, 0, 0, CELL, 1) result it #REF!
SOlution:
for LET() to work in libreoffice using dynamic ranges one must use the syntax "
VARIABLE, INDEX(INDIRECT(HELPER_CELL)", where the helper cell content must be
in text format and may be derived from a CONCAT() function.
so please document this to users OR solve this because i lost a great deal of
time to do it.
--
You are receiving this mail because:
You are the assignee for the bug.
