implement the new XLOOKUP function in Jedox Web. The function is present in the latest versions of Excel and does the same as VLOOKUP but more powerful
Provide the ability to define themes for charting in Jedox Web, allowing users to define default styles for chart components such as titles and labels and define custom color palettes to align with corporate branding and style guides.
Influence chart scaling and axis label format dynamically based on the users activity on the report (his filter settings etc.). I would like to set axis min/max based on variables. (see attached mockup)
Format the whole spreadsheet without freezing the report
If you do this currently by selecting all cells of a sheet and change formats (e.g. font, size) Jedox loads the report for minutes as every single cell is changed. To avoid this problem, the behaviour should be different, e.g. take format for all ...
Reports sometimes have a lot of columns and it's hard to recognize the whole row, especially if the cells are locked. It would be very helpful to highlight the row on mouse hover as it is now in Modeler dimension view.
Changing the subset formula should update the Subset editor accordingly
In the Subset editor the formula at the bottom should be adjustable. Adjusting the formula should update the editor accordingly. Just like in the Rule editor! Also, when switching in the Subset settings between formula ans Subset editor, the edito...
When planning functions such as splashing or copy are used, the audit trail does not keep a complete record of what has been entered.
For example, executing the following command “copy Actual;2023” only records the following NUMERIC_VALUE: 12345,...
Concatenate values from variables, functions and named ranges (spreadsheet function)
Currently CONCATENATE.RANGE seems the only (native) way of concatenating a (more or less dynamic) number of values with a delimiter. Unfortunately it only works with a cell / cell range. If a list form element uses a variable as target and the sel...
Sometimes it happens that the button Actions throw the error 'Timeout while executing action'. This happens when you e.g. have big rules which take more time to calculate than the intern timeout setting of the Action is set. In my case it was the ...