https://bugs.documentfoundation.org/show_bug.cgi?id=161496
Bug ID: 161496
Summary: Names defined in LET() cannot be used for ranges in
INDEX()
Product: LibreOffice
Version: 24.8.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If you try to connect areas with each other using INDEX(), you will receive an
error when using names defined in LET().
Steps to Reproduce:
With the INDEX function, I can use the following formula
=INDEX((A2:A4~C2:C4~E2:E4),MOD(SEQUENCE(9,1,0),3)+1,0,INT(SEQUENCE(9,1,0)/3)+1)
to create a matrix that writes all three ranges one below the other. First the
range 1 then 2 and then 3.
The ranges are connected in Index with the tilde.
If you now try to define these three ranges in advance and assign them to a
name with LET(), this no longer works with the names in INDEX().
=LET(a,A2:A4,b,C2:C4,c,E2:E4,INDEX((a~b~c),MOD(SEQUENCE(9,1,0),3)+1,0,INT(SEQUENCE(9,1,0)/3)+1))
results in Error 502.
In Excel, this also works with the names defined in LET().
In Excel there is the function VSTACK() which performs the same task.
Actual Results:
Error 502
Expected Results:
my three ranges
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 6d39b1a6068bbbd5ca4947f668f989dbfb73342d
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
Skia/Vulkan; VCL: win
Locale: en-GB (de_DE); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
