Zero time values are still an issue
As already discussed in some issues here (#1043, #674), zero datetimes are still an issue for this library. And yes, I do understand that excel has a buggy system for handling times, but it would be great if there would be a workaround for this. Setting the `iso_dates` property to `True` does not work in all cases (results in `#VALUE!` in Excel Mac 2016) and just not handling `0` time values is neither an option sometimes. I currently work with a sheet that contains these kind of values (`00:00:00`) and after processing the sheets, the values are all stored as `-1`, even I did not touch them (through my code). The times I am actually writing (`cell(row=1, column=1, value=datetime.time())`) are stored correctly, but because openpyxl is reading / parsing the original cells as `datetime.datetime`, instead of `datetime.time`, they get written as a -1. Is it possible to disable parsing of datetimes, until I really would like to parse it (lazy parsing)? Or add an option to parse some cells as time, instead of datetime? Version: `openpyxl 3.0.4`
issue