Problem using hidden columns in query

Hi Mehmet Fatih,

You can hide columns to prevent them from being displayed to the user. However, when you try to interact with a cell that is hidden, you might encounter the warning "The current cell cannot be set to an invisible cell." This warning occurs because you are trying to set a hidden cell as the current cell, which is not allowed.

To avoid this warning, ensure that you do not attempt to set a hidden cell as the current cell. Instead, manipulate the data without focusing on the hidden cells. You can still perform operations on hidden columns without setting them as the current cell. By following this approach, you can work with hidden columns in your dataset seamlessly without triggering the warning message.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mehmet Fatih2y ago
Thanks for your advice.
+1
Jayraj Chhaya2y ago
Hi Mehmet Fatih,

You can hide columns to prevent them from being displayed to the user. However, when you try to interact with a cell that is hidden, you might encounter the warning "The current cell cannot be set to an invisible cell." This warning occurs because you are trying to set a hidden cell as the current cell, which is not allowed.

To avoid this warning, ensure that you do not attempt to set a hidden cell as the current cell. Instead, manipulate the data without focusing on the hidden cells. You can still perform operations on hidden columns without setting them as the current cell. By following this approach, you can work with hidden columns in your dataset seamlessly without triggering the warning message.
+2