|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/28/2011 11:03:36 AM
Posts: 1,
Visits: 22
|
|
| I am trying to paste a variable into an E-DataAid file. Therefore I added a variable in my E-DataAid file and than I have to copy information from Excel into the cells of the new variablecolumn. I managed to do this several times, but for a reason that seems random to me, sometimes it is impossible. E-prime than gives the following message: "This information cannot be pasted into the selected range because there are unhidden cells in the range that point to the same data. Cannot change data more than once in the same paste operation. If you are certain that you want to paste this information into this column, first collapse the spreadsheet at the experiment level for this column, then retry the paste operation." I don't know how to collapse the spreadsheet at the experiment level for this column. Can anyone help me with this issue? I would be very happy this problem can be solved.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/17/2011 6:23:29 AM
Posts: 1,
Visits: 9
|
|
I finally banged my head off this enough to get somewhere. When you add a variable, it asks you what level. This is unexplained, but matters. The default is session - if you accept that, you'll find that if you change the first value, then all the entries for that variable for that session change. Thus, if you change a subject number, it knows to change every line for that subject. That, presumably, is what the message about cells pointing to the same data means, there is only one entry for many cells. For me, it worked to add the variable at the sub trial level. Even then, I got some lines of it greyed out, something to do with the block structure of the experiment. The solution is to filter the file to hide the levels that are greyed out. Cut and paste from excel then works. In general, I suspect you should look at the properties for the file as a whole, and see what level number the variable you want to match is at. So for me, I wanted to add a new label for each response, and response is at log level 4, which is the sub trial level (apparently!). So I created my new variable at sub trial level, then filtered the file to hide those blocks where this response was not made.
Hope this helps.
|
|
|
|
