Cannot set formula with address of another worksheet!
Status: Alpha
Brought to you by:
rvk
Menu
▾
▴
#1 Cannot set formula with address of another worksheet!
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'
))
ws_data.write(0, 0, '4000')
wb.save('not_parsing.xls')
Is this a bug or am I doing something wrong?
Regards,
Marco
Logged In: YES
user_id=1240217
This is not a bug. This is by design. pyExcelerator does not
unerstand such syntax. Try Formula("HYPERLINK(address; name)")
Logged In: YES
user_id=1281416
well it does the trick... leaves me with "hyperlinks" though
which can't be summed for example.
Thanks anyway for your hint,
Regards,
Marco
Logged In: YES
user_id=1281416
By the way the Formular has a little mis-typer it should be:
Formula('Data!A1'))
An exclamation mark instead of a colon!
Sorry for that,
Marco
Logged In: NO
Mmhh, i don't that? How do you use HYPERLINK to access a Cell from an other sheet? Maybe i should pass the !-Syntax via Text and not by formula.
PS: In Visual Basic the !-Syntax works via formula.
Can some on help me? :O)
Logged In: NO
I think this is a huge design mistake. Hyperlinks are not made for this kind of stuff, because you cant calculate with them. So !-Expression is needed in pyExcelerator!
Logged In: NO
Ah, by the way =HYPERLINK(Page1!D44;) is not working! It allways shows 0.
Logged In: NO
Coment: Date: 2007-03-20 02:20
Dont write =HYPERLINK(Page1!D44;) it should be =HYPERLINK(Page1!D44).
Also you have to remove the blue color and the underline. It's not nice to use hyperlinks for that!
Logged In: NO
Pass it like that =HYPERLINK(;Page1!D44). This will work!
Logged In: NO
=HYPERLINK(;Page1!D44). Will work in Excel, also =HYPERLINK(Page1!D44) does.
But when written as Formula in pyExcelerator this wont work. pyExcelerator expects " around Page1!D44, or you'll get an error.
When you write =HYPERLINK("Page1!D44") or =HYPERLINK(;"Page1!D44") pyExcelerator accepts the Formula. But Excel wont show you a Value, because it's a wrong Hyperlink.
So this is a BIG BUG in pyExcelerator. I will correct the parser and post you my results. I hope i find it!
Logged In: YES
user_id=866238
Originator: NO
Take a look at this patch in the tracker:
https://sourceforge.net/tracker/index.php?func=detail&aid=1687510&group_id=134081&atid=730645
Ruben Mendes
Logged In: NO
I couldn't apply the patch (see https://sourceforge.net/tracker/index.php?func=detail&aid=1687510&group_id=134081&atid=730645\)
Logged In: NO
The patch applies to the svn trunk and fixes this issue