Forum Discussion

lrayTalen's avatar
lrayTalen
Contributor
8 years ago
Solved

how do I cut and paste from excel into a field in a test case?

When I try to copy and paste something from Excel it constantly tells me it is too large to fit in the field. Not sure how it calculates the size but it is not based on the number of text characters....
  • mpourali's avatar
    mpourali
    8 years ago

    Hi Again,

    One way I know to get rid of a hidden char is copy the section into a notepad, then copy all from Notepad and attempt to paste it to the desired field.

     

    If you still have issues withe the length, you may want to break down the text and put into multiple fields (i.e., Comment1, Comment2, etc).

     

    cheers...

mpourali's avatar
mpourali
Occasional Contributor
8 years ago

For a custom field:

1. Log in as an admin.

2.  Go to System Configuration > Screen Layouts.

3. Select the desired page. Eg, Requirements.

4. Click on the Custom Field link.

5. Adjust the Field Size, then Submit the changes.

6. Go back to the page you were entering data, and paste.

 

  • lrayTalen's avatar
    lrayTalen
    Contributor
    8 years ago

    Yes I know how to increase the field size and have done that – several times.  But like a prior post mentioned – I have less characters to paste that the size limit allows – but it flags the error anyway.  What hidden characters does it use – how can you get rid of them?

    • mpourali's avatar
      mpourali
      Occasional Contributor
      8 years ago

      Hi Again,

      One way I know to get rid of a hidden char is copy the section into a notepad, then copy all from Notepad and attempt to paste it to the desired field.

       

      If you still have issues withe the length, you may want to break down the text and put into multiple fields (i.e., Comment1, Comment2, etc).

       

      cheers...

      • CGangloff's avatar
        CGangloff
        Moderator
        8 years ago

        Hello,

         

        I see you are mentioning that you currently paste the information into Notepad as a workaround. Instead of needing to have a Notepad open, you can also use the "Paste Text" button.

         

        The Paste Text button pops up a window where you can paste in copied, formatted text: the formatting is removed when the text is inserted into the field.

         

        > Paste_Text.swf video attached

         

        Thank you,

        Christiane