What users observe
Some comma-formatted numbers are parsed, others are not.
What Sparkflows supports
Valid formats:
-
1,234,567 -
1,23,456 -
-1,23,456.78 -
(123,456)
Invalid formats:
-
12,34,5 -
1,2,3,456 -
Mixed grouping styles
Why invalid formats are rejected
Invalid grouping is ambiguous:
-
Could represent text
-
Could be formatting errors
Sparkflows treats such values as text or null instead of guessing.
Design principle
Incorrect numbers are worse than missing numbers.