When copying multiple cells from an excel sheet to the GridView, empty cells are skipped and following non-empty cells are moved forward. See attached screenshots for an illustration.
This behavior is undesirable for obvious reasons. Is this a bug or a feature. If it's a feature, is there a workaround?