1 Reply Latest reply: Nov 26, 2012 8:23 PM by Johannes Sunden RSS

    How to display text in Pivot Table using "Wrap Cell Text"

    Hui Ming Wang

      Hi,

       

      When I use pivot table to display long text, the mouse over text will be chop off at around 500 char in IE.

       

      In order to overcome this, I increace the value for "Wrap Cell Text" to a bigger number, but this causes all the other cell height to expand also.

      qv_wraptext.JPG

      And this caused the data in the pivot table to be hard to read and scroll.

      qv_qvtext.JPG

      Is there any way to make the pivot table behave like the table in MS Excel where the cell height is adjusted automactically?

      qv_office.JPG