Move objects (button,chart,checkbox) when (un-)hiding rows/columns
When you use the functions HIDECOLUMN and HIDEROW to hide/unhide columns and rows certain objects on the spreadsheet stay in their position and are not moved accordingly ..this affects charts, Buttons, checkboxes etc.
It would be great to be able to configure the behaviour:
- keep position on screen after hiding/unhiding rows or columns
- change position on hiding/unhiding
(respectively stay connected to the original row/column)
In an advanced mode it would also be great to configure this differently for design mode and user mode ..but this is really nice to have.
This Feature request might be also connected to another feature request:
"positioning of charts related to cell position & size (dynarange)"