topic Re: how to create 2 text lines in one table cell in Discussions

how to create 2 text lines in one table cell

Shlomi — Wed, 08 Nov 2017 11:33:23 GMT

Hello

I wolud like to write into one table cell long string. Is there any option to write the string in 2 lines and put it into same cell (similar to Alt+enter in excel)?

Thanks,

Re: how to create 2 text lines in one table cell

txnelson — Wed, 08 Nov 2017 12:06:51 GMT

JMP does not have such an option. The row height can be changed, which will allow long strings to wrap within a cell, however, when you change one rows height, all rows will be changed to the same height.

Re: how to create 2 text lines in one table cell

Shlomi — Wed, 08 Nov 2017 13:52:30 GMT

Thanks a lot

Re: how to create 2 text lines in one table cell

ian_jmp — Wed, 08 Nov 2017 14:01:25 GMT

Perhaps you could put the escape seequence '\!N" in your text?

dt = New Table( "Double Height",
				Add Rows( 1 ),
				New Column( "Column 1", Character, Nominal)
			);

Column(dt, "Column 1")[1] = "The quick\!Nbrown fox";

Re: how to create 2 text lines in one table cell

Shlomi — Wed, 08 Nov 2017 14:13:48 GMT

This one remoce the second part of the string

Thanks,

Re: how to create 2 text lines in one table cell

ian_jmp — Wed, 08 Nov 2017 14:43:24 GMT

Increase the cell height by dragging:

Re: how to create 2 text lines in one table cell

Shlomi — Wed, 08 Nov 2017 18:59:55 GMT

I am using JMP11 with windows , and does not success to change the hight of the cell.

Is there a JSL code to change the cell height ?

Thanks,

Re: how to create 2 text lines in one table cell

txnelson — Wed, 08 Nov 2017 19:02:13 GMT

You will need to upgrade to get the cell height capability

Re: how to create 2 text lines in one table cell

Shlomi — Thu, 09 Nov 2017 15:00:58 GMT

Is there jsl splrict to do it in JMP12 or 13 ?

Thanks,

Re: how to create 2 text lines in one table cell

txnelson — Thu, 09 Nov 2017 15:15:06 GMT

The Cell Height() setting for JSL was first implemented in JMP 12, therefore, you can use JSL to set it.

Re: how to create 2 text lines in one table cell

Shlomi — Sat, 18 Nov 2017 12:04:30 GMT

Hey,

I tried to use the Cell Height() in JMP 13, but still it is not working.

Can you please send me an example of how to use it ?

Thanks

Re: how to create 2 text lines in one table cell

txnelson — Sat, 18 Nov 2017 15:01:47 GMT

Here is an example, taken directly from

Help==>Scripting Index

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Set Cell Height( 20 );

Re: how to create 2 text lines in one table cell

Shlomi — Sat, 18 Nov 2017 18:11:24 GMT

Thanks a lot for you help !!!