dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph
GNU General Public License v3.0
565 stars 147 forks source link

account for trivial case in sumproduct #133

Closed igheorghita closed 2 years ago

igheorghita commented 2 years ago

I was hoping to change sumproduct to have it account for the trivial usage (i.e., just multiplication). Right now, if you try to use it like eg, =SUMPRODUCT(A1, B1, C1) - this gives an AssertionError, but Excel does evaluate it. Maybe there's a better way to implement this change.