Created attachment 194552 [details] Example file with SCAN from exceljet.net Add the SCAN function to Calc for interoperability with Excel 365 This seems to be useful with LAMBDA. Attached example file is from https://exceljet.net/formula/dynamic-summary-count
+1 I think we need to establish a systematic plan, to add to Calc the new functions and other new capabilities, such as those found in pivot tables.
(In reply to m_a_riosv from comment #1) > +1 > > I think we need to establish a systematic plan, to add to Calc the new > functions and other new capabilities, such as those found in pivot tables. Is seems that the paradigm of implementing a set of functions that are mutually beneficial at the same time is required. An ad hoc function implemented without the complementary helper functions seems to no longer work. Perhaps implementing bug 138749 "Add function LAMBDA for interoperability with MS Excel" includes LAMBDA, BYCOL (ByCol), BYROW (MyRow), MAKEARRAY (MakeArray), MAP, REDUCE, SCAN, ISOMITTED (IsOmitted). The whole is greater than the sum of the parts. In the way that the issue is written: Bug 126573 - Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY Perhaps the title of the issue: Bug 138749 - Add function LAMBDA for interoperability with MS Excel Should be updated to Bug 138749 - Add function LAMBDA, BYCOL (ByCol), BYROW (MyRow), MAKEARRAY (MakeArray), MAP, REDUCE, SCAN, ISOMITTED (IsOmitted) for interoperability with MS Excel
This function has been added in commit 76c9c81b02fd1159d03133e5dbcb488d3a659d13.