please support access to the precomputed value and the formula simultaneously in cell
Created originally on Bitbucket by Robert L (Rob Letzler)
I am writing code to non destructively add thoughtful numeric formats to excel sheets, typically produced in Python or Stata. it’s not possible to apply thoughtful formats to formulas without access to the result; the precomputed / cached value in the Excel sheet is fine for my purposes ; but if I give openpyxl the data_only flag, then the sheet loses the formulas. opening two copies of the excel sheet and building code to use them thoughtfully together seems to require reinventing much of openPyXL. I decided I could do without supporting formulas in my current project, but it would be great to have a field like “precomputed_value” alongside “value” in cell, perhaps only populated if the coder specified a load_data flag when loading the excel sheet.