PyExcelerator - mishandling of formulas?
PPNTWIMBXFFC at spammotel.com
Thu Nov 17 17:11:04 CET 2005
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Serge.Orlov at gmail.com>
>> ws_summary.write(0,0, pyExcelerator.Formula('Data:A1'))
>> ws_data.write(0, 0, '4000')
> I think you're doing it wrong. ":" character means range, to refer to a
> sheet use "!" charater: Data!A1
Right you are. It "changed" somehow... anyhow, even if you change it, it
will choke on the same line. I received an answer... a workaround which
doesn't make me happy, but it is, as it is!
This is not a bug. This is by design. pyExcelerator does not
unerstand such syntax. Try Formula("HYPERLINK(address; name)")
does the trick, but the text shown is a hyperlink now!
Thanks for your help,
More information about the Python-list