assay

DV-0020

gsheets: function not implemented — IMAGE, IMPORTDATA, IMPORTFEED (+4 more)

Cause
missing-function
Category
value
Diverging engines
gsheets
Behavior signature
{"error":"#REF!"}
Test count
12
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (7)

IMAGE IMPORTDATA IMPORTFEED IMPORTHTML IMPORTRANGE IMPORTXML REGEXMATCH

Tests (12)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
IMPORTDATA/importdata-csv-smoke =IMPORTDATA("https://example.com/data.csv") #NAME? gsheets#REF! excel#N/A lattice#REF! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
IMPORTFEED/importfeed-rss-smoke =IMPORTFEED("https://example.com/feed.xml") #NAME? gsheets#REF! excel#N/A lattice#REF! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
IMPORTHTML/importhtml-table-smoke =IMPORTHTML("https://example.com/page.html", "table", 1) #NAME? gsheets#REF! excel#N/A lattice#REF! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
IMPORTXML/importxml-xpath-smoke =IMPORTXML("https://example.com/data.xml", "//title") #NAME? gsheets#REF! excel#N/A lattice#REF! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
IMPORTRANGE/importrange-cross-sheet-smoke =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1:B2") #NAME? gsheets#REF! excel#N/A lattice#REF! ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
IMAGE/image-url-smoke =IMAGE("https://example.com/pic.png") #NAME? gsheets#REF! excel#N/A lattice#NAME? ironcalc#NAME? hyperformula#NAME? libreoffice— formulas#NAME? pycel#NAME?
REGEXMATCH/match-unicode-property-class-on-non-ascii-letters {"gsheets":"=REGEXMATCH(\"café\", \"\\p{L}+\")","excel":"=REGEXTEST(\"café\", \"\\p{L}+\")","lattice":"=REGEXMATCH(\"café\", \"\\p{L}+\")"} true gsheets#REF! exceltrue latticetrue ironcalc— hyperformula— libreoffice— formulas— pycel—
REGEXMATCH/match-unicode-property-class-rejects-digits {"gsheets":"=REGEXMATCH(\"123\", \"\\p{L}\")","excel":"=REGEXTEST(\"123\", \"\\p{L}\")","lattice":"=REGEXMATCH(\"123\", \"\\p{L}\")"} false gsheets#REF! excelfalse latticefalse ironcalc— hyperformula— libreoffice— formulas— pycel—
REGEXMATCH/match-unicode-property-class-on-cjk {"gsheets":"=REGEXMATCH(\"你好世界\", \"\\p{L}+\")","excel":"=REGEXTEST(\"你好世界\", \"\\p{L}+\")","lattice":"=REGEXMATCH(\"你好世界\", \"\\p{L}+\")"} true gsheets#REF! exceltrue latticetrue ironcalc— hyperformula— libreoffice— formulas— pycel—
REGEXMATCH/lookbehind-in-pattern {"gsheets":"=REGEXMATCH(\"hello\", \"(?<=hel)lo\")","excel":"=REGEXTEST(\"hello\", \"(?<=hel)lo\")","lattice":"=REGEXMATCH(\"hello\", \"(?<=hel)lo\")"} true gsheets#REF! exceltrue latticetrue ironcalc— hyperformula— libreoffice— formulas— pycel—
REGEXMATCH/lookahead-in-pattern {"gsheets":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")","excel":"=REGEXTEST(\"foobar\", \"foo(?=bar)\")","lattice":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")"} true gsheets#REF! exceltrue latticetrue ironcalc— hyperformula— libreoffice— formulas— pycel—
REGEXMATCH/negative-lookahead-in-pattern {"gsheets":"=REGEXMATCH(\"foobar\", \"foo(?!baz)\")","excel":"=REGEXTEST(\"foobar\", \"foo(?!baz)\")","lattice":"=REGEXMATCH(\"foobar\", \"foo(?!baz)\")"} true gsheets#REF! exceltrue latticetrue ironcalc— hyperformula— libreoffice— formulas— pycel—