Unable to paste CDG Grid into excel

[Bazkar]

I haven't been using the initial results screen but instead have been using the custom report function to get just the columns that I want copied and pasted. Could that be the difference and shouldn't I be able to copy and paste from there? I also have just been highlighting just the data and not selecting all.

Not sure what to do....will try it this afternoon again and report back.

Thanks.

Baz

[RAY@HQ]

I just tried it on Firefox 3.6 and Excel 2007, no problems. Note that I highlighted the Full Report (i.e. initial results screen) on the CDG. I didn't just do a select all on the page, I just highlighted the results data. Regular Paste worked, didn't even need Paste Special. Give it a whirl this afternoon and let us know.

[Bazkar]

I am using Internet explorer and Excel 2007 (I think....where do I check the version as I am doing this at work...sshhhh). I can try at home with Firefox and I KNOW I have Excel 2007.

Thoughts? I will try again this afternoon when I get the chance.

Baz

[RAY@HQ]

Bazkar, what web browser, what version of Excel? The "Paste Special/Text" option I suggested above has worked for just about everyone we've heard from here, and via email. You tried that?

[Bazkar]

I am having the same issue and none of the "fixes worked for me. I am not sure how to do the "text to column" conversion tool in excel. I have been copy and pasting from the CDG since early February and now all of a sudden it doesn't work....other thoughts?

Baz

[MikeK@HQ]

May be related to our new release of CDG too.

Another idea may be to use the "Text to Column" conversion tool in excel. <Don't mind me if this sounds foreign, I've been using Office 2010 for the past 4 months and forget what older versions are like>

[bolton wanderers]

Thanks, Ray. Copying almost all of the CDG Grid page worked.

[RAY@HQ]

I think I just sent you an email... but try the "Paste Special" option instead of just the basic Paste function. And choose "text" for the format in "Paste Special".

Alternatively, highlight the whole spreadsheet before pasting.

One of those two solutions helps the majority of people with this problem. Let us know if you're one of them.

[bolton wanderers]

Tom - no offense taken. I am using IE7 and have been cutting and pasting since the projection have come out this year with a vaiety of league settings with no issue. Last time was on 3 March. Thanks.

[Tom_T]

If it's March, it must be time for a "can't paste the grid into Excel" post.

Sorry, I'm not poking fun at you -- this is one of those technical issues that comes up every year, and I don't know that there's a programming solution.

What browser do you use? We've seen different behavior with IE vs. Firefox, and with how the copy/paste is performed. Maybe we can find a combination that works for you.

[bolton wanderers]

Done it hundreds of times, but now it only copies into one column. When I tried to do it row-by-row it worked foe the first 4 (header and $50/$45/$40 tiers).

I sorted by position and set up a rough grid as a work-around, but I do like the simplicity of the real CDG grid. Thanks.