Page 1 of 1

extra columns when copying tables from Jamovi to Mac Excel

Posted: Mon Feb 22, 2021 8:00 pm
by unidonburi
Hello,

Whenever I copy/paste a table from Jamovi (every version up to current 1.6.16) in my MS-Excel for Mac (currently ver. 16.45), there are always extra empty columns inserted. This happens only to the data cells, and not the header cells.
The result is that the headers don't line up with the data, and I have to delete the extra, empty cells. For large matrices, this takes some time.

Is this only me, or other Mac users as well?
Best wishes,

Re: extra columns when copying tables from Jamovi to Mac Exc

Posted: Wed Feb 24, 2021 9:03 am
by jonathon
there are extra cells to ensure the any sort of superscript (i.e. asterisks, or other symbols) don't push the numbers out of alignment. but the headers should still line up, if that's an issue, i'm afraid it's a bug in excel. we set column spans appropriately.

it does work with the online version of excel (on a mac).
Screen Shot 2021-02-24 at 19.57.49.png
Screen Shot 2021-02-24 at 19.57.49.png (136.52 KiB) Viewed 1652 times
cheers