Action Buttons Resizing

Post Reply
chewza
Posts: 147
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Action Buttons Resizing

Post by chewza »

Hi

I’m having issues with Action buttons resizing when I open my active reports.
It is quite a “wide” report with action buttons above a few columns.

When I re-open the report, the button are really tiny and I then have to resize.
Googled this, and found stuff about this being logged as a bug as far back as 2015. Client is running 10.2.2 FP6.

Any ideas?

Thanks!!
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Action Buttons Resizing

Post by Wim Gielis »

Action button problems date back to before 2015, and still not solved unfortunately.

Currently we have a customer (also on TM1 10.2.2.6) logging a case with us, because:

- the buttons resize
- the buttons become a picture and not clickable anymore
- the font size increases to 975 (go figure !)
- some PC's work while others give these issues
- and so on

Most of the time working with Action buttons is just "trial and error and not touching the buttons again"

The Print report wizard is similarly crappy. Another customer is logging a case on it currently. The customer moved to PAL.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Action Buttons Resizing

Post by tomok »

I've been dogged with the action button resizing for years. It's a real PITA. Strangely enough It's related to the display resolution on your PC. As long as the person editing the actions buttons have the same type machine with identical display resolutions as the person who created them then everything is stable. Once that switches then all heck breaks loose. It's really bad when you have used action buttons to create a nice looking menu. The resizing messes up your layout. What I've ended up having to do is document the coordinates and size of each button so that whenever the menu needs editing I can fix all the "resized" action buttons, one by one. Not an ideal situation.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Action Buttons Resizing

Post by Mark RMBC »

Normally I would have expected the response to this to be along the lines of change the Placement property to 1 on the Active Form (I did notice Chewza said Active Report and not Active Form).

So my question is, what am I missing here? Which given the responses above from the experts is clearly something!
User avatar
gtonkin
MVP
Posts: 1198
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Action Buttons Resizing

Post by gtonkin »

I saw this quite often when pluggin in an additional screen, whilst the TM1 add-in is open. Standard practice used to be close down, plug in, restart client.
Saying that, there are still times when the inexplicable happen, per above posts. To this end, in my aresenal of macros in my Personal.xlsb, I have one as follows:

Code: Select all

Public Const iButtonWidth As Integer = 85
Public Const iButtonHeight As Integer = 26

Sub FormatTIButtons()
Dim TIButton
For Each TIButton In ActiveSheet.Shapes
    If TIButton.Type = 12 Then
        If Left(TIButton.OLEFormat.progID, 5) = "TM1XL" Then
            TIButton.Top = (TIButton.TopLeftCell.Height - TIButton.Height) / 2 + TIButton.TopLeftCell.Top
            TIButton.Left = TIButton.TopLeftCell.Left + 1
            TIButton.Width = iButtonWidth
            TIButton.Height = iButtonHeight
        End If
    End If
Next
End Sub
At least it is temporary relief for the symptoms.
Andy Key
MVP
Posts: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Action Buttons Resizing

Post by Andy Key »

Mark RMBC wrote:Normally I would have expected the response to this to be along the lines of change the Placement property to 1 on the Active Form (I did notice Chewza said Active Report and not Active Form).

So my question is, what am I missing here? Which given the responses above from the experts is clearly something!
I'm with you. I always set any Action Button's Placement to 1 and don't have any re-sizing problems.
Andy Key
Post Reply