Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel Export Loses Cell Colour

  1. #1
    Join Date
    Jun 2017
    Posts
    1

    Smile Excel Export Loses Cell Colour

    Hi,

    I was hoping somebody could give me a little advice. I've added an extra colour into the main style sheet as per below:

    .pivotTable .cell-style-blue {
    background-color: #0000ff;
    }

    This display perfectly in the report when using the following expression:

    Case
    When [Measures].CurrentMember > 49.00
    Then '|#,##0|style=blue'
    When [Measures].CurrentMember > 19.99
    Then '|#,##0|style=green'
    When [Measures].CurrentMember > 5.00
    Then '|#,##0|style=yellow'
    When [Measures].CurrentMember < 4.99
    Then '|#,##0|style=red'
    Else '|#,##0'
    End

    The problem I am having when I export to PDF or Excel the new style of blue does not get exported through and I end up with a standard white cell.
    Any idea's on what I would need to do to resolve this problem.

    Thanks
    Mike

  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    I haven't created a report using a MDX so perhaps it is different but could you use a style expression in the bg-colour attribute?

  3. #3
    Join Date
    Aug 2006
    Posts
    287

    Default

    The 'style' property only supports red/green/yellow in PDF and Excel. You should use the 'color' property instead.
    Ex.
    ...
    Case
    When [Measures] .CurrentMember > 10000
    Then '|#,##0|"color=#FF00000"'
    ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.