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...
when writing macros or script code in ETL it is often difficult to find out what went wrong and when it went wrong.
The only way at the moment is to scan the log files for error messages.
For development it would be helpfull to have a debug mode ...
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
Such a function is standard for all other Reporting Tools.
You only state a start and enddate and the all data in between are selected.
With that functionality Jedox would reach another level of usability.
Working with the reports would be much m...
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...