vinci1it2000 / formulas

Excel formulas interpreter in Python.
https://formulas.readthedocs.io/
European Union Public License 1.1
342 stars 75 forks source link

discrepancy between visualized value in excel and value read-in the model #132

Open dberardo-com opened 4 months ago

dberardo-com commented 4 months ago

i found out this discrepancy:

i have got an aliased cell with no value:

image

now i have got a cell that references it and displays a "0" instead of an empty cell:

image

and now i have a cell that averages a group of cells which include the cell with a 0 value:

image

the average in this case is 4.33, but when i read the same excel inside formulas i get a value for the cell Z11 of "Empty" and so the average is wrong, being 5.2 instead of 4.33 because the empty cells are excluded from the AVERAGE computation whereas the 0 inside excel is not excluded ...

is this a common problem and is there any way around it ?

vinci1it2000 commented 3 months ago

I have fixed with the latest commit. You can try it out using my dev.

dberardo-com commented 3 months ago

when is the next upstream release on pipy scheduled for ? i mean v1.2.8 ?