A Sunday quickie – Tip on collapsing sheets in a container

Most of you will be aware of how to swap sheets with parameters so I am not going to dive into this.

One thing that you may have stumbled upon, however, is when you are trying to swap a sheet that is text only or a chart like a pie that does not have a dimension on rows or columns. In this case, the sheet will not entirely collapse and take about 30px of the container making things look odd.

Simple solution: just add a fake dimension on rows like a 1 or even a simple ”, define as dimension and your sheet will collapse.

Hope this might be useful and as always, appreciate your feedback.

Until next time.

Steffen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s