Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- how to create 2 text lines in one table cell

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 8, 2017 3:33 AM
(3535 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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 12

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Thanks a lot

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

This one remoce the second part of the string

Thanks,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Increase the cell height by dragging:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

You will need to upgrade to get the cell height capability

Jim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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

Thanks,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

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

Jim