Document behaviour of built-in functions with complex criteria
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
- Issue type
- Documentation
- Clarity
- Needs clarification
- Activity status
- Stale
- Domain
- documentation
Research direction
Start with the linked ExcelJet formula and Excel-DNA discussion, then locate the repository's documentation entry point; the issue names no file or test. Done means documenting the version-dependent behavior of LEFT, MONTH, implicit intersection, and dynamic arrays clearly enough to distinguish older Excel from Dynamic-Array-aware Excel.
Written by the indexing model from the issue text.
Description
See https://exceljet.net/formula/xlookup-with-complex-multiple-criteria
and https://groups.google.com/g/exceldna/c/bwXlP-OXfPM
If seems that a formula like
=XLOOKUP(1,(LEFT(B5:B16)="x")*(C5:C16="east")*NOT(MONTH(D5:D16)=4),B5:E16)
is evaluated differently in Dynamic-Array aware Excel vs older Excel.
In particular, the LEFT and MONTH functions don't return arrays to the formula in the older Excel, but instead only the interpolated row / column value.
It would be good to sort this out and document a bit.
Keywords would be "implicit intersection" and "dynamic arrays".
- Dominant language
- C#
- Stars
- 48
- Forks
- 24
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Excel-DNA/XFunctions
-
last to firstOpen
Difficulty 4/5 3-5 days Newbie friendliness 20/100
Excel-DNA/XFunctions#13 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#10 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#9 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
Excel-DNA/XFunctions#8 · 5 comments ·
-
Difficulty 3/5 1-2 days Newbie friendliness 28/100
Excel-DNA/XFunctions#4 · 2 comments ·
All issues in Excel-DNA/XFunctions
Similar issues
-
area:jobads-cv BE mvp P2
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
klasolsson81/jobbliggaren#2099 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Maintainers usually reply within 1 day
-
0 - Backlog Bug
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
BrighterCommand/Brighter#4581 ·
Maintainers usually reply within 1 day
-
Difficulty 1/5 Under an hour Newbie friendliness 92/100
Esri/calcite-dotnet-toolkit#30 · 1 reaction ·
-
kind:docs simplification size:S status:todo
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
elsa-workflows/elsa-foundation#2604 ·
Maintainers usually reply within 1 day