Bug 380589

Summary:	IMPLEMENTED IN SVN: paste data into script editor
Product:	[Applications] rkward	Reporter:	RKWard Team <rkward-devel>
Component:	general	Assignee:	RKWard Team <rkward-devel>
Status:	RESOLVED FIXED
Severity:	wishlist
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	unspecified
OS:	All
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description RKWard Team 2009-09-28 16:12:05 UTC

-- Originally posted by (AT sourceforge.net): rtautenh --

-- This ticket was imported from http://sourceforge.net/p/rkward/feature-requests/55 on 2017-05-31 14:48:56 +0100 --
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.-- Labels: General --

Comment 1 RKWard Team 2010-02-10 23:19:40 UTC

-- Originally posted by (AT sourceforge.net): rtautenh --
new package xlsx http://cran.r-project.org/web/packages/xlsx/index.html eliminated the need for it

Comment 2 RKWard Team 2010-02-10 23:19:40 UTC

-- Originally posted by (AT sourceforge.net): rtautenh --
- **status**: open --> closed

Comment 3 Thomas Friedrichsmeier 2010-02-11 07:44:42 UTC

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 4 Thomas Friedrichsmeier 2010-02-11 07:44:42 UTC

- **summary**: Copy and paste data from Excel/OOcalc into R editor --> Copy and paste data from spreadsheet into R editor
- **status**: closed --> open

Comment 5 RKWard Team 2010-03-17 22:46:35 UTC

-- Originally posted by (AT sourceforge.net): nobody --
Works with OpenOffice 3.2.0 \! Thanks\!

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

Comment 6 Thomas Friedrichsmeier 2010-03-18 07:31:01 UTC

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 7 Thomas Friedrichsmeier 2010-03-18 07:31:03 UTC

- **assigned_to**: nobody --> tfry
- **summary**: Copy and paste data from spreadsheet into R editor --> IMPLEMENTED IN SVN: paste data into script editor

Comment 8 Thomas Friedrichsmeier 2010-04-30 13:28:23 UTC

Thanks for your suggestion. This feature was released in RKWard 0.5.3, today. Closing.

Comment 9 Thomas Friedrichsmeier 2010-04-30 13:28:24 UTC

- **status**: open --> closed