Hi,
I'm trying to create a table in which besides having an unknown number of rows in the Data Source I might have too a unknown number of columns (up to a max) so I decided to add the maximum amount of columns I could have and hide them using conditional formatting on all the cells of that column if the value returned by processing the row in a user-defined function are < 0.
I've made sure that the rule on the conditional formatting is being applied as if I change the Background this one changes, however when I set the Layout to not visible (unchecked) the cells don't hide.
Any idea on how this could be done or why it's not working?
I'm trying to create a table in which besides having an unknown number of rows in the Data Source I might have too a unknown number of columns (up to a max) so I decided to add the maximum amount of columns I could have and hide them using conditional formatting on all the cells of that column if the value returned by processing the row in a user-defined function are < 0.
I've made sure that the rule on the conditional formatting is being applied as if I change the Background this one changes, however when I set the Layout to not visible (unchecked) the cells don't hide.
Any idea on how this could be done or why it's not working?