[rkward-tracker] [ rkward-Feature Requests-2869028 ] IMPLEMENTED IN SVN: paste data into script editor

[SourceForge.net]

Feature Requests item #2869028, was opened at 2009-09-28 19:12
Message generated for change (Settings changed) made by tfry
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=459010&aid=2869028&group_id=50231

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: Ralf  Tautenhahn (rtautenh)
>Assigned to: Thomas Friedrichsmeier (tfry)
>Summary: IMPLEMENTED IN SVN: paste data into script editor

Initial Comment:
Since many people end up copying data from Excel sheets into R, 
it would be great to have the possibility to paste the data not only into the data set editor,
but also as 'R-encoded'-text (e.g. vector: c(x1,x2, ...), or matrix: rbind(c(x1,x2,...), c(y1,y2,...))) into an R script. 

Thanks!
Ralf.

----------------------------------------------------------------------

>Comment By: Thomas Friedrichsmeier (tfry)
Date: 2010-03-18 09:31

Message:
As you've found out, I've recently implemented this in SVN.

Note that we put a "cbind" around the vectors, so when you run the
inserted code, the results should be like the copied data. In a first
attempt, I used "rbind" instead, which makes the rows of pasted code
correspond to the rows of data. My reason for changing it was, that if you
have mix numeric and non-numeric cells in the copied data, those will
typically be organized by column. So this way you have better chances of
getting a "pure" vectors (try it to see what I mean).

Do you think it's too confusing this way?


----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2010-03-18 00:46

Message:
Works with OpenOffice 3.2.0 ! Thanks!

Rows are pasted as columns, though. 
Works fine when the toggle option is used.

----------------------------------------------------------------------

Comment By: Thomas Friedrichsmeier (tfry)
Date: 2010-02-11 09:44

Message:
I still think it's a nice idea worth implementing some day, even if you no
longer have a need for it. So I'll re-open to keep it on the list.

----------------------------------------------------------------------

Comment By: Ralf  Tautenhahn (rtautenh)
Date: 2010-02-11 01:19

Message:
new package xlsx http://cran.r-project.org/web/packages/xlsx/index.html
eliminated the need for it


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=459010&aid=2869028&group_id=50231