DV-0028

ironcalc: different error code — HOUR, MINUTE, SECOND

Cause
error-code
Category
value
Diverging engines
ironcalc
Behavior signature
{"error":"#VALUE!"}
Test count
6
Seeded
2026-04-25
Last confirmed
2026-04-25

Subjects (3)

HOUR MINUTE SECOND

Tests (6)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
date/62c61f =HOUR("13:30:45") 13 gsheets13 excel13 lattice13 ironcalc#VALUE! hyperformula13 libreoffice13 formulas13 pycel13
date/64933c =HOUR("00:00:00") 0 gsheets0 excel0 lattice0 ironcalc#VALUE! hyperformula0 libreoffice0 formulas0 pycel0
date/56627a =MINUTE("13:30:45") 30 gsheets30 excel30 lattice30 ironcalc#VALUE! hyperformula30 libreoffice30 formulas30 pycel30
date/d7207e =MINUTE("13:00:00") 0 gsheets0 excel0 lattice0 ironcalc#VALUE! hyperformula0 libreoffice0 formulas0 pycel0
date/a18a6a =SECOND("13:30:45") 45 gsheets45 excel45 lattice45 ironcalc#VALUE! hyperformula45 libreoffice45 formulas45 pycel45
date/a99bfd =SECOND("13:30:00") 0 gsheets0 excel0 lattice0 ironcalc#VALUE! hyperformula0 libreoffice0 formulas0 pycel0