Forum Discussion

psc's avatar
psc
New Contributor III
7 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...
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
    6 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*

      • CAIGuySeanF's avatar
        CAIGuySeanF
        Contributor
        4 days ago