nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

pasting bug?

Maureen

I am having a very difficult time lately copying and pasting from excel (Excel for Macintosh version 16.12) to JMP (13.2.0).

A column of numbers (not dates or text) will want to paste as characters. When I accept that and then go into Standardize attributes and recode I can always find one single value that has gibberish characters added to the number.

This can even happen if I take a numerical column of data, paste it into Excel and immediately back into JMP - junk characters are added that are invisible in Excel (Excel treats the data as numbers).

Anyone know of a fix for this?

Accepted answers

All comments

gzmorgan0

I don't have a MAC so here are 3 suggestions:

Format the numeric columns as Numeric
Use the Excel Clean function =Numbervalue(Clean(A1)) that removes unprintable characters.
Use Open > Excel Wizard. A column with unprintable characters in Excel (line feedd and tables and leading and trailing spaces) did not paste correctly into JMP. However, when I opened that same file using the Excel Wizard all the junk was removed.

Neither method is easy if you have numerous columns. But I'd suggest you copy and paste into a new sheet.

Then use the JMP Excel Wizard and only select that sheet. In JMP 13, I have seen that the Excel wizard has some problems with columns with formulas, so make sure the columns have values. [JMP 14 does not have this issue].

Good Luck!

Jeff_Perkinson

Without seeing the original Excel file this will likely be difficult to diagnose. If you can't post a sanitized version here, contact Tech Support and send them the file. They can probably explain what's happening and give strategies (perhaps like @gzmorgan0's above) that will help.

Maureen

It's always different files. A clarification from my first post is that I can take a column of numbers from JMP, paste them into Excel and then immediately paste them back into JMP and have it happen.

It usually happens in the last column of data copied over.

Here is a screenshot of one from today.

Screen Shot 2018-08-15 at 10.03.21 AM.png

Jeff_Perkinson

That is odd. I've tried to replicate the problem here but haven't been able to. I do notice that I have Excel 16.16. Is it possible for you to make sure you've got the latest release of Excel?

gzmorgan0

This is a sidebar to your issue. Might I ask what you are trying to do?

Were you copying from JMP to Excel then back again, only to create a good test case, or was this what you were doing when you found the problem?

The reason I am asking is because I have seen newer JMP users do this to use Excel's filters and/or stacking and/or formulas. I do not wish to offend, I am just asking.

If your task is to just copy from Excel to JMP, please ignore my question.