I've made a spreadsheet, and needed to get the standard deviation "STDEV.P" of some values.
I've set the cell value to: "=STDEV.P(...)", however, when I open excel, it gives me a 'name' error.
On further investigation, "=STDEV.P(...)" gets mapped within openpyxl or excel (I don't know which) to "=_xludf.STDEV.P(...)", which is incorrect. It should get mapped to: "=_xlfn.STDEV.P(...)"
When I explicitly set the value to "=_xlfn.STDEV.P(...)" the function works.
I believe that openpyxl should do this mapping, rather than the user...