Is it possible to dynamically set the proximity of sheet objects?
I have an example where I have two charts, the top chart varies in height and as a result can overlap the chart object below. Usually I would set the top chart object to a maximum height, but in this case we want to display all the detail in the top table (no vertical scrolling).
Please see below for an example:
Can I set the objects to be 50 pixels apart vertically at all times?
Since each object has fixed size and position parameters, I doubt this is possible.
It would be nice to be able enter relative parameters instead of fixed ones. But that would also mean you must be able to identify each object by its id and then select it's size and position parameters.
Then you could have a y-position parameter that can change according to the max y-value of the object above it on the sheet.