https://bugs.documentfoundation.org/show_bug.cgi?id=161399
Bug ID: 161399
Summary: Support Spilled range operator in Calc
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
URL: https://support.microsoft.com/en-us/office/spilled-ran
ge-operator-3dd5899f-bca2-4b9d-a172-3eae9ac22efd
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 150900
Created attachment 194521
--> https://bugs.documentfoundation.org/attachment.cgi?id=194521&action=edit
Example file from Exceljet
Add support to the "spilled range operator" in Calc functions.
1. Open attached file, taken from
https://exceljet.net/formulas/dynamic-summary-count
2. Notice the COUNTIF function ( =COUNTIF(data[];_xlfn.anchorarray(E5)) ) in
Sheet1:F5 does not work: it refers to the spilled range starting in E5
Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: d804d6aff49054bad1719ec3c2d136b545bbc7e7
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded
This is a missing feature related to dynamic arrays.
See also:
https://www.ablebits.com/office-addins-blog/excel-spill-range/
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=150900
[Bug 150900] [META] Excel Functions
--
You are receiving this mail because:
You are the assignee for the bug.
