Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

text object formatting

Hi,

Just wondering whether or not this is normal ...

I have two text objects with formulas as follows in a report

='test\nformatting\nnew\nline'

and

='test&Chr(13)&Chr(10)&'formatting'&Chr(13)&Chr(10)&'newline'

This displays fine in the designer but when viewed in the ajax client the line breaks are lost. Is there a way to keep line breaks?

Thanks!

7 Replies
d_pranskus
Partner - Creator III
Partner - Creator III

Hi

Use following syntax

='aaa' & chr(13) & 'bbb' & chr(13) & 'ccc'


Cheers

Darius

Not applicable
Author

Hi Darius,

Thanks for the response. Unfotunately this doesn't work either. It's fine in the Java client (not really helpfull as it's apparently disapearing w/v10).

We're using V9SR1. I guess I'll figure out another way of displaying the information.

Thanks for the help.

Not applicable
Author

Hi ukeen

have you found the solution to this problem?

Not applicable
Author

Hi,

You can use this:

='test ' & Chr(10) & Chr(10) &
'nformatting ' & Chr(10) & Chr(10) &
'nline ' & Chr(10) & Chr(10) &
'nnew ' & Chr(10) & Chr(10)

I think this will solve your problem in Ajax.

Regards,

Ravi

georgina_spary
Contributor II
Contributor II

I had the same problem and sadly this solution didn't work for me, would be really keen to see any further ideas

Anonymous
Not applicable
Author

Hello, I'm also looking for a solution to this problem. Did you find any?

Bill_Britt
Former Employee
Former Employee

Take a look at this. Here is another way I taught to do it with out using CHR(10) and (13). I have just used the enter key inside the ' '.

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.