Please login or join to use the Hideout!

 

Forums Network Stuff Support
  • Topic: Unable to Paste Spreadsheet Columns

    Back To Topics
    (0 rates)
    • February 8, 2014 4:39 PM CST
      • Post(s)
        290
      • Like(s)
        0
      • Liked
        3
      • cR(s)
        0 0

      Untitled

      In a forum reply I have been trying to post a playlist in by pasting a two column spreadsheet.  No matter how I format the spreadsheet, I am unable to have the artist and song show up as two separate columns.  Instead the artist and song are separated only by a space like below:

      Creation For All That I Am
      Five Americans Western Union
      Who Run Run Run
      Les Fleur de Lys Circles

      Never had this problem in the past. Any suggestions?

       

    • February 12, 2014 2:44 PM CST
      • Post(s)
        1,994
      • Like(s)
        24
      • Liked
        53
      • cR(s)
        0 0

      Untitled

      I think that's probably because the text box strips out any sort of spreadsheet formatting and just pastes in the text from those cells. I don't think I have ever been able to copy from a spreadsheet and past it into an HTML box and just have it magicly appear the way it would in a spreadsheet, not without first converting the cells to an HTML table, anyway.

      ____________________________________

      I run this taco stand.

    • February 12, 2014 2:58 PM CST
      • Post(s)
        290
      • Like(s)
        0
      • Liked
        3
      • cR(s)
        0 0

      Untitled

      The strange thing is that pasting plain old .xls files always worked fine in the past. I did try saving it as .html instead of .xls, but it still did not work.

      It is not that important. I'm just wondering if I was doing anything wrong and if it was easily fixable. Thanks!

    • February 12, 2014 3:00 PM CST
      • Post(s)
        1,994
      • Like(s)
        24
      • Liked
        53
      • cR(s)
        0 0

      Untitled

      Did you try using the "<>" source code button on the text editor when pasting in the html code?

      ____________________________________

      I run this taco stand.

    • February 12, 2014 3:03 PM CST
      • Post(s)
        290
      • Like(s)
        0
      • Liked
        3
      • cR(s)
        0 0

      Untitled

      Not sure what you mean.

    • February 12, 2014 3:03 PM CST
      • Post(s)
        290
      • Like(s)
        0
      • Liked
        3
      • cR(s)
        0 0

      Untitled

      Oh there it is.

       

    • February 12, 2014 3:04 PM CST
      • Post(s)
        290
      • Like(s)
        0
      • Liked
        3
      • cR(s)
        0 0

      Untitled

      I do not know how to edit source code.

       

    • February 14, 2014 9:12 AM CST
      • Post(s)
        1,994
      • Like(s)
        24
      • Liked
        53
      • cR(s)
        0 0

      Untitled

      Jeff of the Future said:

      I do not know how to edit source code.

       

      Well, the source code area is simply where you would paste in any HTML you have that was exported from the spreadsheet.

      This post was edited by køpper at February 14, 2014 9:12 AM CST
      ____________________________________

      I run this taco stand.

    Icon Legend and Forum Rights

  • Topic has replies
    Hot topic
    Topic unread
    Topic doesn't have any replies
    Closed topic
    BBCode  is opened
    HTML  is opened
    You don't have permission to post or reply a topic
    You don't have permission to edit a topic
    You don't have the permission to delete a topic
    You don't have the permission to approve a post
    You don't have the permission to make a sticky on a topic
    You don't have the permission to close a topic
    You don't have the permission to move a topic

Add Reputation

Do you want to add reputation for this user by this post?

or cancel