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

Shlomi · Nov 8, 2017 06:33 AM

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,

txnelson · Nov 18, 2017 10:01 AM

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 );

Jim

View solution in original post

txnelson · Nov 8, 2017 07:06 AM

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.

Jim

Shlomi · Nov 8, 2017 08:52 AM

Thanks a lot

ian_jmp · Nov 8, 2017 09:01 AM

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";

Shlomi · Nov 8, 2017 09:13 AM

This one remoce the second part of the string

Thanks,

ian_jmp · Nov 8, 2017 09:43 AM

Increase the cell height by dragging:

Shlomi · Nov 8, 2017 01:59 PM

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,

txnelson · Nov 8, 2017 02:02 PM

You will need to upgrade to get the cell height capability

Jim

Shlomi · Nov 9, 2017 10:00 AM

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

Thanks,

txnelson · Nov 9, 2017 10:15 AM

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

Jim