diff options
| author | Eike Rathke <erack@redhat.com> | 2019-02-05 12:59:49 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2019-02-05 13:07:45 +0100 |
| commit | f8c4459bbda62cb905d0c007cac044f3410ab76b (patch) | |
| tree | ecf260fae631f3b427dcdaa25379eccabaf3beed /sc/README | |
| parent | 00da9792c51e2dd36c81e66493b8cafc1588104b (diff) | |
Functions supporting Wildcards or Regular Expressions
Change-Id: I1e23f382e343d73a0d28ad0b88b0dc31fb75008d
Diffstat (limited to 'sc/README')
| -rw-r--r-- | sc/README | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/sc/README b/sc/README index 5928b78ba159..fdee3df23ee3 100644 --- a/sc/README +++ b/sc/README @@ -41,3 +41,44 @@ ColumnBlock: * for each cell: 32 bit signed string length followed by string length bytes of the string (UTF-8) - 3 : formula * for each cell: 32 bit signed string length followed by the formula in R1C1 notation as a string + + +=== Functions supporting Wildcards or Regular Expressions === + +As this comes up every now and then, and rather should be documented in an +extra list of the Help system, functions that support Wildcards or Regular +Expressions *and* depend on the setting under +Tools -> Options -> Calc -> Calculate are those that in ODF OpenFormula (ODFF) +are defined to depend on the HOST-USE-REGULAR-EXPRESSIONS or HOST-USE-WILDCARDS +properties, see +https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html + +* Database Functions + * DAVERAGE + * DCOUNT + * DCOUNTA + * DGET + * DMAX + * DMIN + * DPRODUCT + * DSTDEV + * DSTDEVP + * DSUM + * DVAR + * DVARP +* Information Functions + * COUNTIF + * COUNTIFS +* Lookup Functions + * HLOOKUP + * LOOKUP + * MATCH + * VLOOKUP +* Mathematical Functions + * SUMIF + * SUMIFS +* Statistical Functions + * AVERAGEIF + * AVERAGEIFS +* Text Functions + * SEARCH |