Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Apr 30, 2020

HIDEROW(), HIDECOLUMN() performance

We have major frontend performance issues, which stems from the HIDEROW() and HDECOLUMN() functions are not performing well. However, with the current Jedox functionality, these are key to nice UI, so increasing performance would really help out.

    Mar 28, 2024

    Thanks for the idea. This feature has been evaluated by us and we will not implement it at this time.

  • Guest
    Sep 11, 2020

    Well the performance hit is 10's.

    I do not think I have the patience for waiting on this on the other side of 100 hiderows.

    I got the recommendation from a Jedox consultant to aviod these whenever possible to gain performance.

    Observation: I've notice (while avoiding these functions) that if I use a dynarange, then hiderow directly in the sheet is overridden even if the dynarange is set to not autosizing. This forced me to use the hiderow() function to achive the needed result.

  • Admin
    Dominik Lenz
    Jul 25, 2020


    thanks for this idea. In the scenarios you're thinking of, can you roughly quantify on which scale you're using these functions? In an end-user facing report, would you have tens / hundreds or even thousands of rows / columns which are hidden?