Action button: eliminate borders

Post Reply
Patrick Gr
Posts: 10
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Action button: eliminate borders

Post by Patrick Gr »

Hello community,

I've changed action buttons on Excel (published on TM1 web) by putting background images, but the aesthetic is not clean.
I want to remove borders for these specific TIButtons but don't find any option in perspective.
Can you please help me find a way to embellish the buttons by removing borders.

Thank you in advance!
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Action button: eliminate borders

Post by Elessar »

Hi,

You can change the default action button appearance to any picture you want:
https://www.ibm.com/support/knowledgece ... ppear.html
(Show Background Image)
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Patrick Gr
Posts: 10
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Action button: eliminate borders

Post by Patrick Gr »

Thank you Elessar for your reply.
The problem actually is not putting an image: It is already done.
The problem is to remove borders from this image. like shown bellow:
what I have :
Before.png
Before.png (5.76 KiB) Viewed 4288 times
What I want:
After.png
After.png (5.66 KiB) Viewed 4288 times
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 button: eliminate borders

Post by Mark RMBC »

Hi,

We are still on 10.1 and I have found images on action buttons to be problematical, particularly when trying what you are doing.

So I have 2 alternative ways to deal with this

Option 1 - embed the image on the actual worksheet (not on the action button) and put an action button underneath the image with the relevant text.

Option 2 - Create a simple image in excel (or wherever you like), which is purely the relevant wording with background colour (needs trial and error to get sizing correct), save as a jpeg and add image to action button. Then resize action button in websheet as required, but the resizing in action button will only really work if the correct size is set when creating image in excel!

From a look and feel point of view I personally prefer option 2!

cheers, Mark
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Action button: eliminate borders

Post by David Usherwood »

Enable the Developer menu
Select Properties of the object
Format Shape
Shape Options\Line\No Line

I've tested this with PAX Action Buttons but I believe this would work with Perspectives Action Buttons
Patrick Gr
Posts: 10
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Action button: eliminate borders

Post by Patrick Gr »

@David:
it is such option that I'm looking for, but don't find it in TM1 10.2
@Mark:
For the option 1, when I put an action button underneath the image and publish my worksheet on web, the button is not operational anymore.
For the option 2, it is actually what I did, I created the image on paint, save it as jpg, add it to the action button, then had as a result the image with right and bottom borders. I think these borders are related to the action button configuration.
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Action button: eliminate borders

Post by David Usherwood »

it is such option that I'm looking for, but don't find it in TM1 10.2
I should have made clear that the Developer toolbar is an Excel option - not a TM1 option:
https://www.techonthenet.com/excel/ques ... ab2013.php
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 button: eliminate borders

Post by Mark RMBC »

Hi

Watch the start of this video (https://www.youtube.com/watch?v=pxjnKz9-h7M) for the general idea of putting the button below the image (though in this case they use hyperlinks but it can easily be done with action buttons). If your button no longer works try deleting and recreating it

For option 2 (see image below), if you use a normal image you are going to struggle to get rid of the border affect, at least that is my experience. We moved away from images with pictures toward images with wording, as you can see from the image. I admit the image still isn't perfect by any stretch but I think it does look cleaner than a picture and getting a picture to size correctly is a headache I can do without!

I created the image in excel via a textbox with a black outline, copied the textbox into word and saved it as a jpeg. After trial and error I determined the jpeg should be 182 x 87 pixels (but in order to get this sizing in the jpeg I had to get the sizing correct in word). Basically it involves trial and error, at least it did for me!
Option2 example.jpg
Option2 example.jpg (4.82 KiB) Viewed 4210 times
The other alternative is that you live with the border!

cheers, Mark
Post Reply