Closed Spectre5 closed 2 years ago
Hi @Spectre5 thank you for considering using pylightxl. It does in deed look like a bug, let me address it this week and ill get back to you. Thanks for submitting this!
Hi @Spectre5, thank you for submitting this comprehensive issue. It was really easy to go back and make the changes. I have updated the master, but will hold off on releasing a new version till we get a more more improvements in.
Pylightxl Version: 1.58 Python Version: 3.7
Summary of Bug/Feature: When using
sheet.row
withoutput='f'
, I get the traceback shown below. I've printed thesheet._data
dictionary and it does in fact haveNone
for some of the formulas. It is an array formula that I see it.Traceback:
Suggestion for fix (Option 1): Fix the immediate issue only
Change this https://github.com/PydPiper/pylightxl/blob/3729d0a056770809da46f88fb83bc87772a6e3d3/pylightxl/pylightxl.py#L1656 to:
Suggestion for fix (Option 2): Avoid None earlier in the code for values, formulas, and comments
Change this https://github.com/PydPiper/pylightxl/blob/3729d0a056770809da46f88fb83bc87772a6e3d3/pylightxl/pylightxl.py#L494 to: