[Libreoffice-commits] core.git: sc/README

[Libreoffice Gerrit user]

 sc/README |   41 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)

New commits:
commit f8c4459bbda62cb905d0c007cac044f3410ab76b
Author:     Eike Rathke <erack at redhat.com>
AuthorDate: Tue Feb 5 12:59:49 2019 +0100
Commit:     Eike Rathke <erack at redhat.com>
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