I have four metadata columns into which I cannot paste data for a bulk upload. A diaglog box: "The selected cells are read only" appears when I try to paste.
The cells are defined as "multiple lines of text" with up to 15 lines.
The largest thing I'm attempting to paste is 200 words, 1140 bytes. The average byte count is around 825 bytes.
I am able to paste, edit, delete and copy from all the other cells in the table, so I'm pretty confident that my Datasheet View & permissions are set up appropriately.
Three of the columns are inherited from my parent site and were created last week, one is defined on the site with which I'm working and was created this morning. I don't think that the logical location of the fields is making a difference.
The only consistency between the three is that they're all long-form text fields.
In doing my research, I discovered this question on stack which states that "It will come up saying "The selected cells are read only" if you have a multiple lines of text field that is anything other than "Plain Text" (Such as the body section of a blog post), as Datasheet view has no idea how to deal with HTML etc." I'm importing from a semi-colon delimited text file, and viewing it in a hex editor doe not reveal any hidden control characters.
I've checked my datasheet, site and column properties, and cannot see anything that would force these fields into a read-only status.
Anyone ever run into this before? Anyone know of some other things to check?