2 Replies Latest reply on Sep 24, 2013 3:12 PM by disabled_ntaylor

    Paste from Excel to FMP12 is not working correctly

    BowdenData

      Summary

      Paste from Excel to FMP12 is not working correctly

      Product

      FileMaker Pro

      Version

      12.0v4

      Operating system version

      Mac OSX 10.8.5

      Description of the issue

      If I copy a column from Excel (Mac Office 2011) into a single text field in FMP12, it does not give the same result as in FMP11. In FMP11, it pastes the list of values without any extra characters.

      In FMP12, it adds a "tab" character at the end of the text of each line. It still has the return character at the end of each line, so I still get a list in the FMP12 field, but with the added "tab" character. I've tried to paste with or without style, it doesn't make any difference.

      Steps to reproduce the problem

      1) Select multiple values from a single column in MS Excel.
      2) Paste the selected text into a text field in FMP12.
      3) You can see that it has a "tab" character at the end of each line within the text field.

      Expected result

      As in FMP11, no extra "tab" character is needed at the end of each line.

      Actual result

      A "tab" character is added to the end of each line.

      Exact text of any error message(s) that appear

      N/A

      Configuration information

      Have not tested this on a Windows machine.

      Workaround

      None found.