I hope I'm just missing something obvious. I have a google Sheet with several sections of columns that are beeing hidden to simulate sort of different views. Each of these sections have buttons (drawings) to trigger scripts which may or may not hide columns (they do hide columns). Now when I hide all columns to the left, all the buttons (drawings) that were in those, now hidden, columns will cluster on the remaining visible columns and even with drawing.setPosition they refuse to move to the hidden columns. When the columns to right are beeing hidden this does not occur.

I want to either hide or move the buttons to hidden columns, I don't want to see buttons that are supposed to be in hidden columns. They haunt me, please help!

(Removing them is not an option since I'll need them back when the columns are no longer hidden)

Regards, Woof

I tried moving them to the hidden columns and expected that to work because in the case of the columns to the right beeing hidden the drawings can obviously occupy a hidden column.

CodePudding user response：

Since I couldn't find a solution I solved my issue with a workaround instead. As I have already described, the issue only arrises, when the Buttons (Drawings) I try to hide are in hidden columns to the left, not to the right. My workaround now is: I added more Columns to the right, which are alway hidden, and move all Buttons (Drawings) which I currently don't need over there. I can identifiy the drawings via the function attached to them, maybe this helps people with similar issues.

If someone finds an actual solution to this problem I would be very interested!