Keeping spreadsheet formatting with a TableView
Hi all
I have a tableview that retrieves cube data and adds the stage data for the cube data. It is displayed in a spreadsheet which has conditional formatting to highlight the stage records. My problem is that all the formatting is wiped when the tableview is executed. I have tried to format the rows in the tableview but the only option I can find is for column format.
Does anyone know if it is possible to retain the formatting in a spreadsheet when using tableviews. Failing that anyone know how to format the rows in a tableview (I want to format some not all rows).
Any suggestions appreciated. Thanks Marcus
Hi Marcus,
with 8.4, the option to preserve Excel formatting for table views has been introduced:
This allows for row-based formatting by adding conditional formatting to the sheet. Previous to 8.4 this would be removed with each refresh as you noticed.
With that one can now also use Excel drop down lists which do not get removed anymore after a refresh (adding this as a good to know FYI).
Hope that helps!
