assay
regex

119bb9

Subject
REGEXMATCH
Category
value
Formula
{"gsheets":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")","excel":"=REGEXTEST(\"foobar\", \"foo(?=bar)\")","lattice":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")"}
Canonical
true

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge #REF!
excel match true
lattice match true
ironcalc no-data
hyperformula no-data
libreoffice no-data
formulas no-data
pycel no-data