improve array functionality
Please improve working with arrays in Jedox Web.
All the time I have problems to remember or even to find out where I have defined arrays in a spreadsheet.
I also find it very unintuitive and complicated to use the combinations of Ctrl+Shift+Enter / Ctrl+Capslock+Enter to define or remove an array.
It would be very helpful if there was a way to highlight array areas.
Even better would it be if the handling of arrays would be improved.
Robert Hagedorn commented
thanks for your comment.
Your suggestion still leaves me with the problem to find arrays in already existing reports which have no named range pointing to their existance.
I still think that a way to highlight arrays within a report would be greatly benefecial for report developers.
why don't you define named ranges on your arrays? By doing so it should be pretty easy to find all arrays defined.
Ctrl+Shift+Enter is common sense for arrays (even in Excel itself), so I dont think it would be smart to change this behaviour unless Mircosoft does.