https://bugs.documentfoundation.org/show_bug.cgi?id=151863
Bug ID: 151863
Summary: Array SUM along sheets with INDIRECT, returns #VALUE,
while it works fine with 6.4.6
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 183373
--> https://bugs.documentfoundation.org/attachment.cgi?id=183373&action=edit
Sum through sheets
With an array formula like:
{=SUM((INDIRECT("Week"&COLUMN(A$1:E$1)&".A"&ROW(A$1:A$500))=$A2)*INDIRECT("Week"&COLUMN(A$1:E$1)&".B"&ROW(A$1:A$500)))}
to sum along several sheets.
In the attached sample file, it works for me with:
Versión: 5.4.7.2
Id. de compilación: c838ef25c16710f8838b1faec480ebba495259d0
Subprocs. CPU: 4; SO: Windows 6.2; Repres. IU: GL;
Configuración regional: es-AR (es_ES); Calc: CL
Fails with:
Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 19045; Repres. IU: GL; VCL: win;
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
