Forum Discussion
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.
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*
5 Replies
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:
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)!
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*
