I have a problem with the datasheet view and I would just like to confirm my findings.
We have a document library with multiple content types. Each content type may have some extra columns which may be required.
If the list is opened in datasheet view it appears to me that ALL columns that are required in at least one content type, independent of the content type of the selected row, are now treated as required columns.
Content Type A:
Columns: A, B, C, D
Required: A, D
Content Type B:
Columns: A, B, E, F
Required: A, F
If i edit a row, it appears that I have to fill out columns A, D and F no matter the content type on the current row.
Am I correct? I will conduct more tests on this, but if someone has a quick answer, I would appreciate it.
Do you know someone who can help? Share a link to this thread on twitter, or facebook.