Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte Führt man im ETL einen Excel extract auf eine wss Datei aus, so werd
Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte
Führt man im ETL einen Excel extract auf eine wss Datei aus, so werden momentan nur fix eingetragene Zellwerte ausgelesen.
Von Zellen die eine Formal, eine Palo Formal oder...
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...
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 serv...
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...
Currently the groovy function editor is not reflecting the high maturity which Jedox Integrator has reached now. You cannot even resize it if you have to develop a more extended logic. More real-time validation of the code and debugging support wo...
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 ...
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 deplo...