Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Weird cell focus change
Hello all,
I encounter a weird problem in Excel: I have a palo.ename function that allows me to select a dimension value.
everytime I select a value using this cell, the focus goes automatically to the cell where my connection/db string is stored ?!
It does not look that it is Palo related cause I cannot reproduce the problem on another computer...
Weird... Did somebody encountered the problem ?
Thanks in advance !
laloune
"To understand recursion, one must understand recursion"
RE: Weird cell focus change
Hi,
do you have an named range for your connection/db? It's excel behaviour that it jumps there within a doubleclick event. to avoid this, make sure the connection/db is on the same sheet in a "normal" cell. There e.g. you can reference a named range on another sheet. in palo.ename reference the "normal" cell.
Holger
Hi Holger,
thanks for your reply.
Actually no, I do not have any named cell for the connection string.
I tried what you said, that is:
1/ set a name for the connection string cell
2 / reference on the palo.ename sheet a connection string that points to the named range
3/ use this cell as the connstring of the palo.ename.
The problem still stands indeed, the focus is now displaced to the cell 2/
thanks !
laloune
"To understand recursion, one must understand recursion"
Hi Laloune,
which OS are you running? I have the same behaviour since I use Windows 7, I never saw that when I still had XP. I posted it in the bug tracker, maybe the Jedox folks can do something (Issue No 7221)
Regards
The other Holger
This post has been edited 1 times, last edit by "holger_b" (Jul 29th 2010, 11:20am)
well OS is Windows XP though...
could it be that it comes from the updates that are installed with the Palo Excel installation ? They should be installed I think
laloune
"To understand recursion, one must understand recursion"
Quite annoying... Let's wait what the support says.
Hi,
as I said, I don't think it's PALO related. See attached xls file. It only got the doubleclick events enabled in, where nothing else happens.
|
Source code
|
1
2
3
|
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'nothing happens at the tavern
End Sub
|
Try do doubleclick on the yellow cell and see what happens also on desktops without palo installed.
Maybe a soloution is to activate "direct cell editing (direkte zellbearbeitung aktivieren)" in excel options. For me that works. Give it a try.
Holger
This post has been edited 1 times, last edit by "h_decker" (Jul 29th 2010, 12:45pm)
Makes no difference for me...
This afternoon I happened to see that TM1 behaves just the same, so I believe you are right, Holger: obviously an Excel issue. Maybe the Jedox developers can think of some tweak in Excel to avoid that.
Regards
Holger
Here is what came from Jedox support:
Known Issue. Possible Workaround: put a reference to connection string on the same sheet where ENAME formula sits, then point ENAME formula to the cell with the reference.
There is another bug report for that, so there is some hope.
Regards
Holger
Isn't the behaviour just caused by the 'Edit directly in cell' Excel option?
If, in Excel, you go to 'Tools'->'Options', tab 'Edit' and unselect 'Edit directly in cell', is the double-click behaviour working as expected again?
Michel
That is what Holger Decker proposed, but it did not make a difference for me. Moreover: If I activate that option, it is deactivated after I clicked on a PALO.ENAME() cell.
Cheers
Holger
This post has been edited 1 times, last edit by "holger_b" (Jul 30th 2010, 2:49pm)
Quoted
Known Issue. Possible Workaround: put a reference to connection string on the same sheet where ENAME formula sits, then point ENAME formula to the cell with the reference.
