Change scale of Planning Analytics Workspace Websheets

Issue

When adding a websheet to a PAW book, there is often a scroll bar on the websheet widget if it is bigger than the book canvas. A websheet can sometimes appear more zoomed in on PAW than Excel so it is often easier to consume the content in PAfE and not so easy in PAW - thus putting off users from deploying a solution in PAW. Sometimes only a couple of rows or columns don't fit on the page and makes it harder to consume the content as scrolling is required and can't see as much of the report as you can in Planning Analytics for Excel.

When exporting a PAW book to a PDF, the websheet content which has scrollbars is cut off as it doesn't fit on the page and therefore can't use exported content.

Proposed solution

Have a setting that allows adjustment to the fit or scale of a websheet used in PAW, either allow it to dynamically fit to the window or set the zoom level manually e.g. 80%.

Workaround

I have tried using 'fit page' property but that only applies to the book canvas and not to the websheet widgets that go onto it. I have tried to save the Excel file zoomed out but that doesn't affect the scaling when it is applied to a book in PAW. The workaround is to get the users to scroll up and down or consume it in PAfE where you can zoom out, but then you can't benefit from the all the great features within PAW.

Needed By

Month

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Change scale of Planning Analytics Workspace Websheets