sc/README | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+)
New commits: commit f8c4459bbda62cb905d0c007cac044f3410ab76b Author: Eike Rathke <[email protected]> AuthorDate: Tue Feb 5 12:59:49 2019 +0100 Commit: Eike Rathke <[email protected]> CommitDate: Tue Feb 5 13:07:45 2019 +0100 Functions supporting Wildcards or Regular Expressions Change-Id: I1e23f382e343d73a0d28ad0b88b0dc31fb75008d 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 _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
