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

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

Highlighted

- 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
(6368 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

Highlighted

- 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

Highlighted
##

- 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

Highlighted
##

- 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

Highlighted
##

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

Highlighted
##

- 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,

Highlighted
##

- 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:

Highlighted
##

- 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,

Highlighted
##

- 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

Highlighted
##

- 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,

Highlighted
##

- 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

Article Labels

There are no labels assigned to this post.