Product and version
FileMaker Pro 14.0.4
OS and version
FileMaker will drop a tab when you cCopy and paste multiple cells from a spreadsheet into a FileMaker text field, if a cell starts with some newlines before the text content.
How to replicate
Create an excel file with some cell contents. One cell should start with newlines before the text content (see cell C1 below):
Select the cells and copy them to the clipboard.
Go into a FileMaker database, enter a text field, and paste the clipboard into the field.
The field content will look like this (→ = tab; ¶ = newline):
For some reason, FileMaker drops the tab between the 2nd and 3rd cell.
Paste the clipboard into a plain text editor, select everything and copy&paste it into FileMaker.
This bug makes it more complicated to work with virtual tables and a simple drag'n'drop / copy&paste approach.