Design Mode

Post Reply
User avatar
macsir
Community Contributor
Posts: 717
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365
Contact:

Design Mode

Post by macsir » Tue Sep 08, 2020 4:36 am

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: 2079
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Design Mode

Post by Steve Rowe » Tue Sep 08, 2020 8:43 am

Just to check you are using the Design Mode on the Pafe toolbar, not the one on the Developer toolbar?

User avatar
macsir
Community Contributor
Posts: 717
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365
Contact:

Re: Design Mode

Post by macsir » Wed Sep 09, 2020 1:20 am

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