Design Mode

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Design Mode

Post by macsir »

Hi, I am trying to test the design mode in Custom Report or Dynamic Report. But neither of them work as to the descriptions from the document.
Whenever I copy and past any static value into cells with DBRW formulas inside it already in the reports, it always replace it with those static values. It didn't preserve any DBRW formulas at all regardless of the design mode was turned on or off.

Preserve or clear DBRW formulas when you are pasting values into cells
When Design Mode is on, you can copy and paste values into cells and clear any DBRW formulas in those cells.

When Design Mode is off, you can preserve the DBRW formulas when you are copying and pasting into cells that contain DBRW formulas.



Do I miss anything here? I am using PAfE 55 on PAL2.0.9.1 with PAW 46. Thanks.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Design Mode

Post by Steve Rowe »

Just to check you are using the Design Mode on the Pafe toolbar, not the one on the Developer toolbar?
Technical Director
www.infocat.co.uk
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Design Mode

Post by macsir »

Thanks, Steve. After several testing, I just realized this function doesn't work with just only one cell's copying and pasting. If more than one cells, it works as expected. :)
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply