Post Reply 
Copy/Paste between Spreadsheet and Stats1/2
08-03-2014, 10:47 AM
Post: #1
Copy/Paste between Spreadsheet and Stats1/2
While there are ways to move datasets between Spreadsheet and Stats 1/2Vars applications using reserved variables and Home, would it make sense to directly enable Copy/Paste of ranges?

For example: copy range in Spreadsheet (a list) they click on variable header in Stats and paste the range.

Similarly, click on a variable header in Stats to copy the variable, then paste it as a range into spreadsheet.

If technically possible, I'd think that this would be quite intuitive and universally useful.

Cheers.
Find all posts by this user
Quote this message in a reply
08-03-2014, 11:05 AM
Post: #2
RE: Copy/Paste between Spreadsheet and Stats1/2
I just discovered that in Spreadsheet, if I press Vars key, it's easy enough to paste any dataset from Stats apps just by choosing it (I have to remember which one is which).

But I'm still struggling to do the reverse process easily: i.e. copying and pasting a range from the spreadsheet into a Stats variable. Paste in Stats doesn't seem to allow pasting lists.

The best I can think of is to copy a range from Spreadsheet, go to Home and paste a list on the stack. Then Store the list in the appropriate Stat's variable (e.g. D1-D0, C1-C0 - one has to memorize which one).
Find all posts by this user
Quote this message in a reply
08-04-2014, 05:37 AM
Post: #3
RE: Copy/Paste between Spreadsheet and Stats1/2
Hello,

Smallest way to do it:
start stat aplet and type on the command line: D1:=Spreadsheet.A1:A5 and it should work...

simpler command line:
spreadsheet beeing current app: A1:A5 ENTER, then start stats and type D1:=Ans

Cyrille
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)