Page 2 of 2 FirstFirst 12
Results 26 to 41 of 41

Thread: Unable to paste CDG Grid into excel

  1. #26
    Join Date
    Jun 2003
    Posts
    8,545

    Default

    I highlighted the entire page (Edit, Select All) and did a copy. I then did a regular paste into the first cell (not a Paste Special), using Excel 2003. I then deleted the top 'n' lines which contain the HQ banner, etc.

    This also works if I highlight only the table itself (column headings and data), but it's annoying to try to highlight such a long report.

    I do end up with a column of hyperlinked player names, but I can easily copy/paste back onto itself to convert the links to plain text.

    P.S. This worked in both Firefox and IE 6.0, under Windows XP.

  2. #27
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    Quote Originally Posted by TOM@HQ View Post

    This also works if I highlight only the table itself (column headings and data), but it's annoying to try to highlight such a long report.
    Ah, this is what I always do, perhaps that's why I can never get this problem to happen for me.

  3. #28
    Join Date
    Feb 2006
    Posts
    177

    Default

    It still is not working for me today but I did try the select all option that Tom uses and that worked for me even in the Custom Guide spreadsheet. I have to do a little more housekeeping with it once it pastes but at least I can get it there. If there are any developments please let me know.

    Thanks.

    Baz

  4. #29
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    I'm getting closer to this... I've gotten myself into the same box where nothing works, if I'm using Excel 2007 and IE.

    I can't get myself in that state in Firefox, so that's my first suggestion for quick results. And we're working on adding a CSV export option to the CDG results page, which would mitigate the need to copy/paste.

  5. #30
    Join Date
    Feb 2007
    Posts
    471

    Default

    Okay, yeah, if you hit Select All and paste the entire contents of the page, it will go in, but not as Paste Special, only as a regular paste. You then delete the HQ banners. etc. It ends up working, but this isn't how I used to do it, so something must have changed.

  6. #31
    Join Date
    Feb 2006
    Posts
    177

    Default

    I have firefox at home but am unable to download the firefox browser here at work which is where I do the majority of my document downloading and prep work during the down times. I may try it at home if I get the chance.

    Thanks Ray.

    Baz

  7. #32
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    Update: we think we've fixed the issue. I couldn't paste at all with IE 7/Excel 2007, and now I can.

    Make sure to delete your browser cache in IE, then give it a whirl. Let us know here if you still have issues.

  8. #33
    Join Date
    Jun 2003
    Posts
    8,545

    Default

    I tried highlighting just the columns of the report, and pasting into Excel 2003.

    Firefox: Paste Special works. Looks good.
    IE 6.0: Paste Special does not work. Granted, this is an older version of IE, so maybe it's not important.

    Also, the Grid still only works with Paste, not Paste Special, no matter what browser I use.

  9. #34
    Join Date
    May 2003
    Location
    Canada
    Posts
    14,706

    Default

    Quote Originally Posted by TOM@HQ View Post
    Firefox: Paste Special works. Looks good....Also, the Grid still only works with Paste, not Paste Special, no matter what browser I use.
    This is confusing to me. Can you clarify?
    - - - - - - - - - - - - - - - -
    'Put Marvin Miller in the Hall of Fame!'

  10. #35
    Join Date
    Jun 2003
    Posts
    8,545

    Default

    Quote Originally Posted by DAVITT@HQ View Post
    This is confusing to me. Can you clarify?
    CGD, grid view: I used to be able to highlight just the grid itself (from the first column heading of R$ to the last player), and do a Paste Special/Text into Excel. That doesn't work -- all of the names end up in thr first column. I have to do a regular paste, which preserves the HTML formatting and leaves me with hyperlinked player names.

    Come to think of it, I'm not sure when the last time was that I was able to do Paste Special for the grid. I have a feeling it's been this way for at least a couple of years.

  11. #36
    Join Date
    Mar 2010
    Posts
    39

    Default Can't cut and paste grid to Excel.

    I'm trying to copy and paste the grid in excel and having no luck either. Can't you guys make the reports printable via pdf or something?

  12. #37
    Join Date
    May 2003
    Location
    Canada
    Posts
    14,706

    Default

    Quote Originally Posted by TOM@HQ View Post
    CGD, grid view: I used to be able to highlight just the grid itself (from the first column heading of R$ to the last player), and do a Paste Special/Text into Excel. That doesn't work -- all of the names end up in thr first column. I have to do a regular paste, which preserves the HTML formatting and leaves me with hyperlinked player names.
    OK -- your earlier post said that in Firefox (which I use) "Paste Special works. Looks good."

    So should I understand that Paste Special DOESN"t work in Firefox? Or that your comments about Paste vs Paste Special are about IE?
    - - - - - - - - - - - - - - - -
    'Put Marvin Miller in the Hall of Fame!'

  13. #38
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    From what I have seen today, the remaining problem is with the Grid view. I can get that to (mostly) work in Firefox, with a little manual cleanup... but not IE.

    The Full Report and Position Report seem to be working with both browsers. Make sure to clear your browser cache if those are giving you trouble.

  14. #39
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    Another update... Grid View, and all views really, now working in IE. Just do paste, not paste special, with cursor in the top-left cell of your spreadsheet. Delete your browser cache first, too.

  15. #40
    Join Date
    Feb 2009
    Posts
    104

    Default This may sound dumb, but why don't you just add a csv download option ...

    just add a csv download option to the cdg results page and the grid. Just like we download the projections. All we'd have to do it hit the download button and all the 'cut and paste' issues go away. Just a thought.

  16. #41
    Join Date
    May 2003
    Location
    Westwood, MA
    Posts
    47,537

    Default

    We're working on that right now, crotex....

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •