Forum Discussion

MarcusH's avatar
MarcusH
Contributor III
2 days ago

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 pro...
Reports
  • Henning's avatar
    Henning
    2 days ago

    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!

     

Henning's avatar
Henning
Valued Contributor II
2 days ago

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!

 

  • MarcusH's avatar
    MarcusH
    Contributor III
    2 days ago

    Thanks Henning. At least it means I can stop looking for a solution.