assay
regex

0779a6

Subject
REGEXMATCH
Category
value
Formula
{"gsheets":"=REGEXMATCH(\"HELLO\", \"(?i)hello\")","excel":"=REGEXTEST(\"HELLO\", \"(?i)hello\")","lattice":"=REGEXMATCH(\"HELLO\", \"(?i)hello\")"}
Canonical
true

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match true
excel match true
lattice match true
ironcalc no-data —
hyperformula no-data —
libreoffice no-data —
formulas no-data —
pycel no-data —