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
- :
- Discussions
- :
- how to keep cell color of JMP table

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
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 4, 2016 6:31 AM
(3905 views)

Hi,

I made a script that check last 30 days average and color in red if its above or bellow 1/3 of my limit

(assuming i keep my limit in 3 sigma it check for one sigma shift)

i can't save the color format into journal or XLS file, is there a way to share it with ppl that do not have JMP?

(I can't change zoom of JMP table so i can't even image capture it since its longer then one page...)

For** ( i **=

If** ( **Column

,Column** ( dt**, "Mean 30 days"

**)**

);

For** ( i **=

If** ( **Column

,Column** ( dt**, "Mean 30 days"

**)**

);

1 ACCEPTED SOLUTION

Accepted Solutions

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

In JMP 12, the cell colors are copied to a journal; Given your above script, you can add:

new window("my journal",<<journal);

dt<<journal;

Here is the journal output for a simple example I ran:

Jim

4 REPLIES

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

Maybe something like this?

NamesDefaultToHere(1);

// Colour some cells in a table

dt = Open("$SAMPLE_DATA/Big Class.jmp");

hCol = Column(dt, "height") << Set Property("Color Gradient", {"White to Blue", Range( 40, 80 )} );

hCol << Color Cell By Value( 1 );

// Make a PDF on the Desktop

nw = NewWindow("My Window", PanelBox("Big Class", dt << getAsReport));

nw << savePDF("$DESKTOP/Big Class.pdf");

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

thanks for the fast reply

the moment i make it into journal i lose the colors (making it to PDF after doesn'tbring the colors back)

* i have JMP 10

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

I guess the answer then is to upgrade to JMP 12.

I am sorry that I don't have a better solution

Jim

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

In JMP 12, the cell colors are copied to a journal; Given your above script, you can add:

new window("my journal",<<journal);

dt<<journal;

Here is the journal output for a simple example I ran:

Jim