You can expect data to be destroyed when automatically parsing csv/tsv (default behaviour), especially because it's dependent on the last settings used in the text-to-columns wizard.
Then there's all well-known bugs like floating point addition and locale-dependent function names and 1904 dates.
Conditional formatting accidentally pasting is all over the place.