Bug 97613 - EDITING: CELL() function doesn't work as array inside arrays or in array functions like SUMPRODUCT()
Summary: EDITING: CELL() function doesn't work as array inside arrays or in array func...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2016-02-07 01:59 UTC by m.a.riosv
Modified: 2020-04-12 09:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample CELL() inside arrays (10.18 KB, application/vnd.oasis.opendocument.text)
2016-02-07 01:59 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m.a.riosv 2016-02-07 01:59:26 UTC
Created attachment 122420 [details]
Sample CELL() inside arrays

As indicate in the title, CELL() function doesn't work with as array inside arrays or in array functions like SUMPRODUCT(), seems that only return the first value of the range in the function, like is how it works in non array cells.

Attached a basic sample file.
Comment 1 Buovjaga 2016-02-11 09:07:55 UTC
Confirmed.

Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+
Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38
Locale: fi-FI (fi_FI)
Comment 2 QA Administrators 2018-07-24 02:36:26 UTC Comment hidden (obsolete)
Comment 3 m.a.riosv 2020-04-12 09:47:45 UTC
Strill
Version: 7.0.0.0.alpha0+ (x64)
Build ID: b1da67699bd05b26ee11460347ca7077d366c2fc
CPU threads: 4; OS: Windows 10.0 Build 19592; UI render: Skia/Raster; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL