Skip to Content

Crosstab - wrap text

Hi all,

I would like to wrap text in crosstab with word-break:break-word. I looked at data and data from SAP HANA is comming out with non-breakable text. eg:. "NEWnbsp;YEAR" and you can't break word. What is best solution to solve this issue? How to replace with blank "NEW YEAR"?

Thank you!

image-10.png (12.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 01 at 10:52 AM

    Hi Gregor,

    As far as I know the best way will be replacing the content from "NEWnbsp;YEAR" to "NEW YEAR" using css.

    You can use the below css to change the content of the cell in crosstab.

    .text div#__cell1_textContentDiv

    {

    visibility: hidden;

    position: relative;

    }

    .text div#__cell1_textContentDiv::after

    {

    visibility: visible;

    position: absolute;

    left:0;

    content: 'New Year';

    }

    Note: Use the ID of cell you want to change instead of the ID(__cell1_textContentDiv), I used.

    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05 at 08:18 AM

    Hi Poovarasan,

    Thank you for reply, your solution is to replace one value, but in real case every row which has divided words need replacement. Values are coming from database so you can't predict values and replace all values with css. I was thinking replacing values from database with script, but this will impact performance. Maybe there is some technical setting that is replacing innerHTML with innerText?

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded