Websheet rendering on different devices

Post Reply
CRP0021
Posts: 35
Joined: Mon Aug 21, 2017 2:14 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Websheet rendering on different devices

Post by CRP0021 »

Hi everyone,
Wondering if there is a way to make a websheet in PAW render the same regardless of what type of device it is being viewed on?

When a user views a particular book from a laptop it renders with vertical/horizontal scroll bars as compared to when viewing on a larger desktop monitor.

I’m wondering if there is an aspect ratio setting or something similar that can be set either on the tm1web config file or in PAW that would present a websheet the same regardless of where it’s being viewed from?

Any advice or thoughts on possible workarounds would be appreciated!
burnstripe
Regular Participant
Posts: 227
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Websheet rendering on different devices

Post by burnstripe »

If you use a template (not free form), you can set the workbook to a screen resolution aspect ratio eg. 4:3, 16:9 and then drag in the page and set it to 100% width and 100% height.

As long as the aspect ratios are the same proportion between users, no matter how big or little the screen it'll display as desired to the end user.

Of course if people use different aspect ratios some some users may see additional scroll bars or white space, I don't think this can be avoided, so you'll have to see which is most acceptable.

If you want to show more on the screen you can shrink the size of the websheet content via the browser and zooming out, this is controlled by the user
Post Reply