470,648 Members | 1,552 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,648 developers. It's quick & easy.

PyExcelerator - mishandling of formulas?

Hi,

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!

<example>

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
chokes!
ws_data.write(0, 0, '4000')

wb.save('not_parsing.xls')

</example>

Is this a bug or am I doing something wrong?

Regards,
Marco

Nov 22 '05 #1
4 3493
Marco Aschwanden wrote:
Hi,

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!

<example>

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
chokes!
ws_data.write(0, 0, '4000')

wb.save('not_parsing.xls')

</example>

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

Nov 22 '05 #2
Marco Aschwanden wrote:
Hi,

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!

<example>

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
chokes!
ws_data.write(0, 0, '4000')

wb.save('not_parsing.xls')

</example>

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

Nov 22 '05 #3
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Se*********@gmail.com>
wrote:

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)")
[...]

Which means:

ws_summary.write(0,0, pyExcelerator.Formula('HYPERLINK("Data!A1"))

does the trick, but the text shown is a hyperlink now!

Thanks for your help,
Regards,
Marco

Nov 22 '05 #4
On Thu, 17 Nov 2005 09:27:26 +0100, Serge Orlov <Se*********@gmail.com>
wrote:

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)")
[...]

Which means:

ws_summary.write(0,0, pyExcelerator.Formula('HYPERLINK("Data!A1"))

does the trick, but the text shown is a hyperlink now!

Thanks for your help,
Regards,
Marco

Nov 22 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Marco Aschwanden | last post: by
2 posts views Thread by tkpmep | last post: by
5 posts views Thread by susan | last post: by
3 posts views Thread by tkpmep | last post: by
1 post views Thread by aneesh.goel.rbtx | last post: by
1 post views Thread by patrick.waldo | last post: by
1 post views Thread by A_H | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.