Forum Discussion

psc's avatar
psc
New Contributor III
6 days ago
Solved

Headers in center of excel

Hello,

I know you can center columns in a report, but is there a way to do this for cube views exporting to excel? I've only found a workaround where you go to export it to report and then change it to excel, but this won't work for us longterm.

Would like to be able to do this - ok with either embedded or just exporting.

 

Cube View
Excel Add In
Reports
  • CAIGuySeanF's avatar
    CAIGuySeanF
    4 days ago

    Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

    *Having trouble getting images to upload, but hopefully you can see visuals now*

  • MarcusH's avatar
    MarcusH
    Contributor III
    6 days ago

    What software version are you using? I know there have been enhancements for exporting to Excel - I don't know what was added in which release. These are the options in V8.2.2 which should centre the text:

     

    • psc's avatar
      psc
      New Contributor III
      5 days ago

      Hi Marcus, I mean to have the entire column in the center - so let's say periodic on the left then the account names in middle and ytd on the right. The above just centers the name of the cell within the cell. I'm on version 8.5 (exciting)!

      • CAIGuySeanF's avatar
        CAIGuySeanF
        Contributor
        4 days ago

        Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

        *Having trouble getting images to upload, but hopefully you can see visuals now*