Subscribe Bookmark RSS Feed

how to create 2 text lines in one table cell

Shlomi

Occasional Contributor

Joined:

Mar 23, 2017

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,  

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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
12 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Occasional Contributor

Joined:

Mar 23, 2017

Thanks a lot 

ian_jmp

Staff

Joined:

Jun 23, 2011

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

Occasional Contributor

Joined:

Mar 23, 2017

This one remoce the second part of the string 

Capture.PNG

 

Thanks,

 

ian_jmp

Staff

Joined:

Jun 23, 2011

Increase the cell height by dragging:

Screen Shot 2017-11-08 at 14.40.50.png

Shlomi

Occasional Contributor

Joined:

Mar 23, 2017

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

Super User

Joined:

Jun 22, 2012

You will need to upgrade to get the cell height capability

Jim
Shlomi

Occasional Contributor

Joined:

Mar 23, 2017

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

 

Thanks,

txnelson

Super User

Joined:

Jun 22, 2012

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

Jim