PyExcelerator - mishandling of formulas?
Serge.Orlov at gmail.com
Thu Nov 17 09:27:26 CET 2005
Marco Aschwanden wrote:
> Yesterday I placed a bug report on PyExcelerators-Sourceforge-page... but
> I am not so sure anymore, whether this is really a bug - I could imagine
> that I missed something, but I don't see what. Please confirm that my bug
> is due to mishandling and I will gladly retreat my bug report.
> In a formula, I would like to point to a field on another worksheet.
> pyExcelerator chokes on these references!
> import pyExcelerator
> wb = pyExcelerator.Workbook()
> ws_summary = wb.add_sheet('Summary')
> ws_data = wb.add_sheet('Data')
> ws_summary.write(0,0, pyExcelerator.Formula('Data:A1')) <--- Here it
> ws_data.write(0, 0, '4000')
> Is this a bug or am I doing something wrong?
I think you're doing it wrong. ":" character means range, to refer to a
sheet use "!" charater: Data!A1
More information about the Python-list