extra columns when copying tables from Jamovi to Mac Excel

unidonburi · Post by **unidonburi** » Mon Feb 22, 2021 8:00 pm

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,

Post by **jonathon** » Wed Feb 24, 2021 9:03 am

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 (136.52 KiB) Viewed 960 times

cheers

jamovi