In order to easily maintain complex print reports, I would need up to 5 nested Dynaranges in one report. One of the latest requirements could use 3 nested vertical Dynaranges with 2 horizontal ones intersecting only the inner vertical Dynarange (t...
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...
Vertical text allignment in cells (Top, center and bottom)
It is today possible to allign the text horizontaly (left, center and right) but expecially with merged cells it would be great to have the possibility to allign the text vertically in the top, down and center direction.
This would make the repo...
It would be super helpful if the reports are shown to the user fit to their respective screen.
There is rarely one screen size used in a company, and that way one could see the whole report zoomed in or out without having to use scroll bars
Hide row automatically when Dynarange/Subset returns 0 rows
There should be an option in the Dynarange editor to hide the involved rows if the (vertical) dynarange returns no result.
This is especially valid for nested Dynaranges.
Right now it is always additional effort to simulate this via HIDEROW func...
Canvas - Freeze panes or pin column(s) e.g. PnL Accounts
Request from Consulting: Some reports are very large and so it is necessary to hide and show columns (works!) and use freeze panes (Not working yet). Example: Finance Report shows PnL Accounts on the left side and if the user scrolls to the right ...
There are several known issues/limitations with the current implementation of merged cells:
Thick border problem on merged cells
If formatted gets white border.
Problem with merged cell when scrolling
Merged cells and freeze pane
Merged ...
It should be possible to preselect the alias as the default value to avoid confusing users with IDs defined as base elements.
The setting should be made user-specific.