topic Clear cell colors in Discussions

Clear cell colors

EndersGame — Mon, 02 Dec 2024 01:08:20 GMT

How do I script to clear all cell colors (not marker or row colors)? I know I can highlight all rows manually and right click and "clear color", but how I do this using script? Thanks in advance!

Re: Clear cell colors

jthi — Mon, 02 Dec 2024 05:30:29 GMT

JMP is able to script that for you

// Clear color for selected cells
Data Table("Untitled") << Select All Rows;
For Each({col}, {:Column 1, :Column 2}, col << Color Cells(""));

so with slight modification

For Each({colname}, Current Data Table() << Get Column Names("String"),
	Column(Current Data Table(), colname) << Color Cells("");
);

Re: Clear cell colors

txnelson — Mon, 02 Dec 2024 05:38:50 GMT

Select the column(s) you want to Clear the Cell Colors from, and then go to

Cols=>Clear Cell Colors