REGEXMATCH

The page prints REGEXMATCH("Spreadsheets", "S.r") and NO result, so TRUE is DERIVED. "S.r" matches the substring "Spr" at the start of "Spreadsheets". THE PAGE NEVER SAYS WHETHER THE MATCH IS ANCHORED OR A SUBSTRING SEARCH -- there is no such sentence on it. Two things settle it: RE2's linked syntax reference defines an unanchored match, and the page would not print this pattern as its one and only sample if the answer were FALSE. That reasoning is recorded here rather than presented as a Google claim. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The companion to the case above, and the reason it is here: with ^ and $ the pattern must consume the whole string, and "Spreadsheets" is twelve characters, not three. If both this case and the unanchored one return the same answer, the engine is not honouring anchors. Anchors are RE2 syntax; the page itself says nothing about them. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

THE PAGE SAYS NOTHING ABOUT CASE SENSITIVITY -- searched for twice, on two separate fetches; there is no such sentence. FALSE is derived from RE2's linked syntax reference, under which matching is case sensitive unless a flag says otherwise. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The pair that makes the previous case mean something: (?i) is RE2's inline flag for case-insensitive matching, from the linked syntax reference. Google's page mentions neither the flag nor the default. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The page states: "This function only works with text (not numbers) as input and returns a logical value, i.e. TRUE or FALSE, as output. If numbers are used as input, convert them to text using the TEXT function." It names NO error value for the rejected numeric case, so this corpus asserts nothing about REGEXMATCH(123, ...) and instead executes the workaround the page prescribes. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The page prints REGEXMATCH("Spreadsheets", "S.r") and NO result, so TRUE is DERIVED. "S.r" matches the substring "Spr" at the start of "Spreadsheets". THE PAGE NEVER SAYS WHETHER THE MATCH IS ANCHORED OR A SUBSTRING SEARCH -- there is no such sentence on it. Two things settle it: RE2's linked syntax reference defines an unanchored match, and the page would not print this pattern as its one and only sample if the answer were FALSE. That reasoning is recorded here rather than presented as a Google claim. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The companion to the case above, and the reason it is here: with ^ and $ the pattern must consume the whole string, and "Spreadsheets" is twelve characters, not three. If both this case and the unanchored one return the same answer, the engine is not honouring anchors. Anchors are RE2 syntax; the page itself says nothing about them. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

THE PAGE SAYS NOTHING ABOUT CASE SENSITIVITY -- searched for twice, on two separate fetches; there is no such sentence. FALSE is derived from RE2's linked syntax reference, under which matching is case sensitive unless a flag says otherwise. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The pair that makes the previous case mean something: (?i) is RE2's inline flag for case-insensitive matching, from the linked syntax reference. Google's page mentions neither the flag nor the default. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The page states: "This function only works with text (not numbers) as input and returns a logical value, i.e. TRUE or FALSE, as output. If numbers are used as input, convert them to text using the TEXT function." It names NO error value for the rejected numeric case, so this corpus asserts nothing about REGEXMATCH(123, ...) and instead executes the workaround the page prescribes. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The page prints REGEXMATCH("Spreadsheets", "S.r") and NO result, so TRUE is DERIVED. "S.r" matches the substring "Spr" at the start of "Spreadsheets". THE PAGE NEVER SAYS WHETHER THE MATCH IS ANCHORED OR A SUBSTRING SEARCH -- there is no such sentence on it. Two things settle it: RE2's linked syntax reference defines an unanchored match, and the page would not print this pattern as its one and only sample if the answer were FALSE. That reasoning is recorded here rather than presented as a Google claim. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The companion to the case above, and the reason it is here: with ^ and $ the pattern must consume the whole string, and "Spreadsheets" is twelve characters, not three. If both this case and the unanchored one return the same answer, the engine is not honouring anchors. Anchors are RE2 syntax; the page itself says nothing about them. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

THE PAGE SAYS NOTHING ABOUT CASE SENSITIVITY -- searched for twice, on two separate fetches; there is no such sentence. FALSE is derived from RE2's linked syntax reference, under which matching is case sensitive unless a flag says otherwise. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The pair that makes the previous case mean something: (?i) is RE2's inline flag for case-insensitive matching, from the linked syntax reference. Google's page mentions neither the flag nor the default. THE AUTHORITY FOR REGEX SEMANTICS ON THIS PAGE IS A LINK, AND IT IS CITED AS ONE. The page states: "Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching", and links the syntax to https://github.com/google/re2/wiki/syntax. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.

The page states: "This function only works with text (not numbers) as input and returns a logical value, i.e. TRUE or FALSE, as output. If numbers are used as input, convert them to text using the TEXT function." It names NO error value for the rejected numeric case, so this corpus asserts nothing about REGEXMATCH(123, ...) and instead executes the workaround the page prescribes. Google's REGEXMATCH page, read live on 2026-08-31 at https://support.google.com/docs/answer/3098292.