iter_worksheet attempts to convert formula text to float
Created originally on Bitbucket by Nougat (Jason Palm)
I ran into the issue described in #264 (closed) - after upgrading to get the fix, a similar problem occurs. I have a cell containing a formula; the cell is formatted as a date. iter_worksheet correctly identifies the date formatting, but is trying to call float() on the formula text instead of the numeric formula result.
(I am using default values for issue fields; please alter as appropriate.)
File "C:\Python27\lib\site-packages\openpyxl\reader\iter_worksheet.py", line 219, in get_squared_range cell = cell._replace(internal_value=self._shared_date.from_julian(float(cell.internal_value))) ValueError: could not convert string to float: =TODAY() + 3