I'll have to test this out Laura, but my understanding is that you shouldn't have a problem with inserting a null value into anything provided that the data column doesn't have a "NOT NULL" constraint attached to it.

Let me do some quick testing and see if that's the case with the numeric double fields in a list. I'll check both R and also our Javascript API to see how the InsertRows works with both.

Regards,

Jon