Often you hide columns/rows in web spreadsheets for simplification of reports. But sometimes you put values in hidden cells, you never ever want the users to see those values. If the user export this report to excel, he could simply unhide those r...
In many reports I need to consider date intervals. for example beginning is
2012-11 and end is 2015-03
Calendar is
- All Years
- Year
- Quar.
- Month
So a macro calculates all needed Elements:
- 2011-11, 2011-12, 2012, 2013, 2014, 2015-Q1
This is...
Allow Install of Excel Plug-in subsequently to install of Server components on the same machine
On most servers Excel is not installed. Hence, during the install of Jedox it is not possible to install the Excel plug-in. We just install OLAP, Web, Tomcat etc.
Subsequently it is not possible to add the Excel Plugin to the install on the serve...
Sometimes it is needed to fill variables from a datasource.
For this task right now you always need a Groovy Job.
which has 2 disadvantages:
- it is not supported by a graphical user interface
- it is somehow disconnected from your dataflow in ter...
Move buttons, charts, comboboxes etc. with arrow keys
The efficiency of final report layouting could be improved:
Positioning of buttons, charts, comboboxes via mouse is not exact enough.
Positioning of buttons, charts, comboboxes via the control properties dialog is to inefficient if you have to a...
If you need the same macro in different workbooks you currently have only 2 options:
- copy & paste the macro into all relevant workbooks
- use external PHP files.
But external PHP files are not really handy when you want to provide deploymen...
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.
Unfortunately Jedox Web does not support cell overlap like Excel does. If the cell content exceeds cell border in Excel the content will overlap to the adjacent colum cell.
It would be great to also have this functionality in Jedox Web because esp...