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...
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...
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.
When printing PDF pages it is sometimes needed that you can define where the page are broken, so that you can control what is shown on page 1, 2 etc. This is a feature which will improve the usability for the viewer of the reports made in Jedox.
Especially on opening or reloading a workbook for a short moment there may be displayed lots of #VALUE errors, while Jedox is retrieving data.
Only possibility to hide these currently is an optional formatting for text color to match background co...