Keeping spreadsheet formatting with a TableView

Question

Hi allI 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

Henning · Accepted Answer

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!
&nbsp;

Forum Discussion

Keeping spreadsheet formatting with a TableView

2 Replies

Related Content

TableView - Setting data type to TableView columns

Reading the BiBlend view in a Spreadsheet (TableView) business rule

Prompting for parameters for Tableview

Create Excel spreadsheet from Business Rules

Linking external Excel Spreadsheet to cube view input spreadsheet