https://bugs.documentfoundation.org/show_bug.cgi?id=168297
Rico <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |implementationError --- Comment #1 from Rico <[email protected]> --- LibreOffice LET() limitation with dynamic ranges LibreOffice Calc does not fully support storing OFFSET arrays inside LET variables LET variables cannot hold raw multi-cell ranges created by OFFSET() or direct references. Using OFFSET inside LET as an array variable in Calc does not work as expected when combined with INDEX/MATCH Do not try to store ranges as text and convert with INDIRECT in LET — Calc won’t allow it SOLUTION To use dynamic ranges in LET, you must wrap the range in an INDEX(INDIRECT(...)). The helper cell must contain a text representation of the range -- You are receiving this mail because: You are the assignee for the bug.
