Issue with entering into empty cell (PAx 2.0)

Post Reply
grusty
Posts: 2
Joined: Thu Oct 11, 2018 10:11 pm
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: 2013 32 bit

Issue with entering into empty cell (PAx 2.0)

Post by grusty » Thu Nov 22, 2018 1:39 pm

Has anyone experienced an issue with PAx where you enter a value or text into an empty cell and it automatically overwrites it with a DBRW formula? If I enter a formulas in the cell this does not happen. I'm trying to determine what exactly is causing this, but it only seems to happen sometimes. If I close Excel and re-open the file, the issue does not persist. I can't figure out if this behaviour is intentional or a bug in the software.

User avatar
Steve Rowe
Site Admin
Posts: 1828
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Issue with entering into empty cell (PAx 2.0)

Post by Steve Rowe » Mon Nov 26, 2018 9:32 am

Yup, not sure if it is a feature or a bug either, certainly its annoying.

Our experience is that it only happens if you start with a slice / DBRW, remove some cells to do some pure excel work and then PAx adds back the DBRW. I assume its an attempt to provide some protection from users deleting formula in error.

Can't find anything documented about this or how to turn it off.

Cheers,

Post Reply