arnoldkegebein

Copy & Paste Bug (Spreadsheet to FileMaker)

Discussion created by arnoldkegebein on Feb 16, 2016
Latest reply on Feb 17, 2016 by TSGal

Product and version

FileMaker Pro 14.0.4

 

OS and version

MacOS 10.10.5

 

Description

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):

ABCD
alphabeta

 

 

 

gamma

delta

 

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):

alpha→beta¶¶¶gamma→delta

 

For some reason, FileMaker drops the tab between the 2nd and 3rd cell.

 

Workaround

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.

Outcomes