Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go ยป
No member browsing this thread
Thread Status: Active
Total posts in this thread: 11
Posts: 11   Pages: 2   [ Previous Page | 1 2 ]
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 1913 times and has 10 replies Next Thread
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: Protected data

Ctrl-V versus Ctrl-Shift-V according Lifehacker http://lifehacker.com/5639828/google-chrome-n...s-built+in-text-stripping is supposed to strip the text attributes during pasting. Does nothing on my Excel [no pasting at all, not in their manual but for Ctrl-V/Ctrl-Alt-V, to bring up the paste special manual]. Works fine in Wordpad though.

Trick for Firefox is [did this Ctrl-Shft-V change happen upgrading to 18.01 that came out as a security fix release last week?]. Hold the Ctrl Key, then with mouse select single column or multiple columns of data.

Querying with Excel from WCG stats pages I've been doing for a long time [all the stats graphs build on them], but the setup I do quite different to jonnieb, via the Data menu selecting "From Web", pasting the address from the browser, update [Go], then pick the areas that I wish to fetch/refresh each time running the query update macro [selected yellow arrows turn green]. Convenient, no messing with xml, csv, or anything.

Well, guy, I fixed my problem. No, I have no idea what fixed it other than I reprogrammed the whole application. Now, I can import data even with Firefox. I did redo it in Excel vice OpenOffice. Was that the problem, I don't know and right now I don't care. It works. laughing

I do want to thank the members who gave me such good help and advice. wink
----------------------------------------
[Edit 2 times, last edit by Former Member at Jan 29, 2013 3:34:42 PM]
[Jan 29, 2013 3:32:45 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Posts: 11   Pages: 2   [ Previous Page | 1 2 ]
[ Jump to Last Post ]
Post new Thread