chr(10) -- line break failed

[emilyrabbit]

Hi ,I want to a line break in the subtitle.

I write like below: ='Ratio:Mini order qty per company/all mini order qty'&chr(10)&'Ratio(qty)'

however, it failed. pls help me .thanks.

[MatheusC · Accepted solution]

@emilyrabbit 

I believe you will find a limitation for this.

using the Repeat() function with chr(160) you can insert spaces, you should be able to jump to the next line as soon as the text reaches the end of the grid.

210 is a number X that I use in this example:

='Ratio:Mini order qty per company/all mini order qty ' & Repeat(Chr(160), 210) & ' Ratio(qty)'

However, the spaces are fixed ( chr(160),X) so if you resize this break it will not fit.

Another idea would be to work with the text object for the subtitle, but I don't think that is what you are looking for.

Maybe someone else has another idea or alternative.


- Matheus

[Qrishna]

= 'This is a long Header' & chr(10) & 'hence using a Line Break Using chr(10)' & chr(10) & 'And Another Line break for the display'

Set the Wrap text property to 2 or 3. 

Navigating to Appearance > Presentation > Multiline text wrapping and toggling the "Wrap text in headers" option on. This setting allows the header text to wrap onto multiple lines if the text is too long for the available space. Additionally, you can control the number of lines for the header by adjusting the "Wrap Text Header Height n Lines" setting in the advanced field settings. 

[emilyrabbit]

Hi ,in the below screenshot, we can see we already tick the "Wrap text in headers" and "Wrap text in cells",but the line break still failed. Can you help me check it ? thansk .

[Qrishna]

• Row height: Set the height of rows in lines. - change this as needed from default.

[MatheusC]

If I'm not mistaken, the row height in Presentation > Style will change in the table content and not in the title or subtitle.

[emilyrabbit]

Thanks. I tried your way . it works.