Page 1 of 1
SUBNM requires enter after selection
Posted: Tue Oct 06, 2009 5:54 am
by jed
What is it that causes a perfectly normally functioning excel TM1 report to suddenly require ENTER after selecting a different element in a SUBNM formula (when it was not required previously)???
I've seen it many times before but I can't remember what causes it...
Re: SUBNM requires enter after selection
Posted: Tue Oct 06, 2009 7:04 am
by lotsaram
9.4.1 FP2 has a few bugs in how it handles incomplete SUBNM formulas. The issue you describe is usually preceded by a "VBA error 13: Type mismatch" in the tm1p.xla VBA module, this disables TM1 handling the double-click event that fires the subset editor until the code break is reset (usually be performing another action such as a fresh slice or possibly a recalculate would work as well).
Re: SUBNM requires enter after selection
Posted: Tue Oct 06, 2009 7:18 am
by Gregor Koch
Hi
Might want to give the good old 'Edit directly in cell' option a try.
Cheers
Re: SUBNM requires enter after selection
Posted: Wed Oct 07, 2009 1:44 am
by jed
HA - had a brain wave and I've cracked it!!!
It must be a bug (not sure if specific to this version - client version I'm on is 9.4 MR1). It is caused when you have a SUBNM formula in a merged cell. Unmerge the cells and SUBNM works normally again. It's a pain though cause frequently you need to merge cells in reports with SUBNM.
Does anyone know if this a bug logged with IBM or is it a "documented feature"?!