topic Re: How do I unlock a column? in Discussions

How do I unlock a column?

Jimbo — Sun, 11 Jun 2023 12:25:11 GMT

I have never used the lock feature and do not know how I got here. How do I unlock a locked column?

Re: How do I unlock a column?

txnelson — Fri, 14 Aug 2020 12:31:01 GMT

I am making the assumption that the data table you are having an issue with, is one that you created from the Summary Platform, or maybe from the Subset Platform. In both cases, the Locking came from having the "Link to Original Data Table" selected. You can remove the lock by either deleting the table, and rerunning the Summary or Subset with the "Link to Original Data Table" unchecked, or Save and close the data table, then reopen it, and go to the Column Info for the column in question, and unselecting the "Lock" check box.

Re: How do I unlock a column?

new_2_JMP — Wed, 30 Sep 2020 19:37:57 GMT

Hi
I am having this same problem. I exported data from a .csv file into .jmp and the column I am interested in is locked and I can not unlock it. I do not have any link to the original data as you mentioned above. It is just a .csv file that brought up into JMP for plotting

What do you mean by Summary Platform and Subset Platform?

Thanks
new_2_JMP

Re: How do I unlock a column?

Jimbo — Wed, 30 Sep 2020 21:56:23 GMT

@new_2_JMP See attached.

The summary and subset screenshot area is attached.

I found my answer by right clicking on the problem column, selecting column info and unchecking the lock button.

Re: How do I unlock a column?

new_2_JMP — Wed, 30 Sep 2020 19:56:56 GMT

Thanks a lot for your helps. A picture do worth a thousand lines. I did not know what he meant by Table Summary and table Subset. I got it now and it fixes my problems

Thanks again

new_2_JMP

Re: How do I unlock a column?

Jimbo — Wed, 30 Sep 2020 20:02:00 GMT

@new_2_JMP you are welcome!

Re: How do I unlock a column?

owg — Wed, 03 Nov 2021 03:44:29 GMT

I thought the fixes here didn't work but I found that with a formula column it's more complicated. After saving, closing & re-opening, the column still would not unlock. But I noticed that formula evaluation was suppressed. Unchecking suppress evaluation made the the formula update using only the subset data. This was much better than deleting my formulas!

Re: How do I unlock a column?

ndowidar — Wed, 24 Aug 2022 16:26:41 GMT

I am having a similar problem. I would like to apply a new formula to a subset of the data in the column, but when I highlighted the rows that need to the new formula, the formula was changed to the entire data set. So I made a new column with the new formula to adjust it manually but the forumula is locked & not supressed, so I'm not sure what to do.

Thanks for your help!