Why are accounting-style numbers like (1,23,456) handled correctly but others are not?

Sparkflows explicitly supports:

  • Western grouping: 1,234,567

  • Indian grouping: 1,23,456

  • Accounting negatives: (123,456), -(123,456)

These formats are recognized and normalized safely.


What is intentionally rejected

  • Invalid comma placement

  • Mixed symbols inside numbers

  • Ambiguous formats

Such values are treated as text or null, not forced into numeric types.


Why this matters

Incorrect numeric parsing is worse than missing values.

Sparkflows prioritizes data correctness over visual forgiveness.