Why splitting spreadsheet clipboard text on newlines breaks pasted tables

A spreadsheet cell can contain a newline. A selected range can also end with empty cells. Both are easy to lose when a web form treats pasted text as text.trim().split('\n') and then splits each line