Unhide/Unexclude rows without changing other row states using JSL

ih — Thu, 04 Jan 2018 13:27:52 GMT

How can you clear a specific row state (ex: excluded) without modifying any other states (ex: color)?

Today I get the table's row states, convert the applicable row states to binary, clear the appropriate digits, convert it back to decimal and set the row state again using As row state().

The reverse, excluding a row leaving other sates intact is pretty straight forward:

//Open table and set a row to selected/hidden
Names default to here( 1);
dt = Open( "$Sample_data/iris.jmp" );
Row state(3) = As row state( 5 );

//Exclude the row without changing other states of the row
Row state(3) = Combine States(Row state(3), Excluded State(1));

Re: Unhide/Unexclude rows without chaning other row states using JSL

txnelson — Fri, 29 Dec 2017 19:27:27 GMT

When I have had to do these kind of thing, I have done as you are currently doing.

topic Re: Unhide/Unexclude rows without chaning other row states using JSL in Discussions

Unhide/Unexclude rows without changing other row states using JSL

Re: Unhide/Unexclude rows without chaning other row states using JSL