Sparkflows explicitly checks for Excel formula errors:
-
#DIV/0! -
#N/A -
#VALUE! -
#REF! -
#NUM! -
#SPILL!
Any such value is converted to null.
Why this is intentional
Excel visually hides errors behind formatting.
Sparkflows exposes them as missing data instead of corrupting columns.
Benefit
-
Prevents invalid values entering numeric columns
-
Makes data quality issues visible and traceable