diff options
| author | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-02-26 16:13:33 +0100 |
|---|---|---|
| committer | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-03-01 18:31:35 +0100 |
| commit | b0791dd9216224bdb266fd0d8c87df253b6d0583 (patch) | |
| tree | 8279e411a1777c1cc6427ba038dc32a3d12f1a86 /sc/README.md | |
| parent | f3d4328e6a0c7b9792883c3b3d49ea5468e9898f (diff) | |
tdf#126573 Add Excel2021 array function FILTER to Calc
https://issues.oasis-open.org/browse/OFFICE-4156
TODO: add dynamic arrays would be useful: Older array formulas,
known as legacy array formulas, always return a fixed-size result
- they always spill into the same number of cells. The spilling behavior
described in this topic does not apply to legacy array formulas.
More info about it:
https://support.microsoft.com/en-gb/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
Related Bug: https://bugs.documentfoundation.org/show_bug.cgi?id=127808
Change-Id: I1c3769ef33fa0207f55e1c96083717c2d90402e5
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/163955
Tested-by: Jenkins
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
Diffstat (limited to 'sc/README.md')
| -rw-r--r-- | sc/README.md | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sc/README.md b/sc/README.md index 9740a6f4fa12..050d84ea4c54 100644 --- a/sc/README.md +++ b/sc/README.md @@ -77,6 +77,7 @@ https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocume * XMATCH * VLOOKUP * XLOOKUP + * FILTER * Mathematical Functions * SUMIF * SUMIFS |