Skip to Content
avatar image
Former Member

SAP Analysis for excel - line break in the header / fixed column size

Hello,

I created some reports which has a "large" heading. The user want me to insert a line break or that the report does not have the automatic column size.

Is this possible and how can I set this.

Thank in advance,

Jochen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 16, 2016 at 11:09 AM

    Assuming the BEx Query is your data source, you could try what Martin suggests in this discussion, back in the Query Designer: https://archive.sap.com/discussions/thread/3796988

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 16, 2016 at 11:12 AM

    Thank you. I will try that out.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 01:44 PM

    Hello,

    that works. But there is a similar question. There are some data "String" in the row, which are very long. How can setup a fix or maximum column size?

    Regards Jochen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 02:04 PM

    Hello Tammy,
    I would like to set that in the analysis for excel - map. I didn´t found how to make that there. Every time when I open the analysis map, the column are resizing with the longest data value.
    Regards Jochen

    Add comment
    10|10000 characters needed characters exceeded