I for one would think that importing values and not formulas would be ideal. I’m out and about and can’t test it, but I suspect this could be quickly achieved in the source code by adding an option to the loadWorkbook() call in data.py.
On github on line 2670 of psychopy/psychopy/data.py , in the importConditions() method, we have this line:
wb = load_workbook(filename=fileName)
If the last poster on this question is right, it could just be changed to this:
wb = load_workbook(filename=fileName, data_only=True)
… and openpyxl won’t read in the formulas.
I wonder what the developers think about adding this change to the next version of psychopy if it works?
If you, @jacanterbury wanted to test it, I think you can edit (carefully!, maybe save a copy somewhere) the source code yourself on your machine. I don’t know what your operating system is, and I’m not sure if this varies depending on how you installed psychopy, but if it’s similar to my setup, the psychopy source is in a folder under python2.7/dist-packages/psychopy/data.py . You just have to find out where python2.7 is on your system. I think running “python -v” in the terminal will print out all of the folders that python uses when it runs.
Or you could just export your spreadsheet to csv, or make a duplicate spreadsheet, copy the column with the formulas, and “paste special” them back in with only the values. Of course you would have to do this every time you changed your spreadsheet, so ya know.