greempel

FM12 - copy paste from Excel trims tabs

Discussion created by greempel on Aug 1, 2012

I just made a big jump from FM8 to FM12 (was high time to do it!) and noticed some strange behaviour when copy-pasting information from an excel spreadsheet into a text field.

 

I'll try to illustrate with an example:

 

Excel source (2 cols, 3 rows):

1 11

2 21

3 31

 

In 12.0v2, when copy-pasting the above into a text cell, it merges row cells as follows:

111

221

331

 

[This is already better than 12.0v1 (that was simply copying the first column and ignoring the second) but is unworkable for processing information.]

 

Is this a system bug or am I missing an object configuration parameter?

 

Many thanks.

Outcomes