formula calculation
Created originally on Bitbucket by Anonymous
The openxml spec specifies that cells with a formula must also provide a cached value. If it is not provided, excel is forced to recompute the value when the document opens. In the current version of openpyxl, a blank value is specified so the cell is empty when a formula is specified.
Proposal:
-
comment line 166 in writer/worksheet.py but this may cause a performance issue when the spreadsheet is opened.
-
implement phpexcel's calcumtaions of cached values (more a long term goal I guess)