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: 2024-04-13 12:01 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
Comment 4 QA Administrators 2022-04-13 03:48:39 UTC Comment hidden (obsolete)
Comment 5 m_a_riosv 2022-04-13 20:40:42 UTC
Still alive.
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d34d1db55978bdcff082af1e0f75b18fa6fc94f4
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: threaded
Comment 6 QA Administrators 2024-04-13 03:15:20 UTC Comment hidden (obsolete)
Comment 7 m_a_riosv 2024-04-13 12:01:20 UTC
Still
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded