Unfortunately in Jedox Web copy&paste is only possible for visible areas of the report.
When working with large dynranges people often export reports to excel first, then they fill in their numbers (e.g. sales revenue planned) and want to paste the values from excel into the web report.
But this paste action will only fill those cells in the web report the user is able to see on his screen. If the underlying dynarange contains more lines than shown, the paste values will simply be ignored in paste action.
It is really hard to explain to users why jedox behaves like this and why they therefore always have to copy only parts of their source to paste it into the visible part of the web report.
Maybe it is possible to add paste action (like strg+v) to a certain group of user actions that triggers the web reports to a complete load (even if it is in the background).
After some testing with the colleagues from jedox support we found out, that PALO.SETDATA has to have such a trigger function. Because even if the SETDATA is below some long dynarange (in the non-visible part of a web report), it is triggered on change like we were expecting it to be.
Hi Team, we are currently exploring the possibility of implementing this in the new Dynatables. We understand that it’s more of a nice-to-have feature, but given how widely Dynatables are now used, we believe this is the right place to begin. Thank you for your patience.
Hi Team
This idea is still in future consideration. Any plans to deliver this in near future? so scrolling to the cells which are not visible on the screen and also pasting data into the cells which are not visible on the screen is what I am referring to.
At least two things are hard to understand:
a) That Jedox even has such an issue.
b) That not more users voice their frustration about it.
Not only does this leave the door open for significant copy + paste errors, but also slows down work speed dramatically.
Dear Jedox Team, please get aware of this situation and provide a user friendly remedy. Thank you.
This topic is very urgent for us and we would very appreciate as a new customer that this standard functionality is available for Jedox web!