simple formula write not working
Created originally on Bitbucket by tbnorth (Terry Brown)
This simple test case isn't working for me, and I can't tell whether it should or not:
{{{ #!python from openpyxl.workbook import Workbook wb = Workbook() dest_filename = r'xp/empty_book.xlsx' ws = wb.worksheets[0] ws.cell('a1').value = 42 ws.cell('b1').value = '=a1+10' wb.save(filename = dest_filename) }}}
Excel 2007 (running on XP SP3) reports 'Excel found unreadable content in 'empty_book.xlsx'. Do you want to recover...
Recovery leaves b1 blank. Everything else seems to be working (making large sheets etc), but anything that sets _data_type to 'f' (strings starting with "=", set_value_explicit type='f') has the above result.
I'm using openpyxl 1.5.6 in Ubuntu 11.10 Python 2.7