rubysolo/dentaku

Cast nil to zero?

dleavitt opened this issue · 1 comments

Excel seems to treat null values as zero for the purposes of arithmetic. Dentaku does not, it raises a Dentaku::ArgumentError.

Screen Shot 2021-07-12 at 17 37 53

Screen Shot 2021-07-12 at 17 37 58

Would you accept a PR to this behavior to match Excel? It would be a pretty consequential change, so perhaps behind a flag?

similar motivation to #18