Failure to convert variable to continuous: values contain text[Bug]:

[cudzz]

JASP Version

0.18.3

Commit ID

No response

JASP Module

Unrelated

What analysis are you seeing the problem on?

Before-- Just opening data

What OS are you seeing the problem on?

macOS Intel

Bug Description

have data that I uploaded to JASP before (with fewer subjects) where the program automatically interpreted the variables I needed to be continuous as such. Now after cleaning up my fresh subset of data from new subjects in excel and exporting it as a cvs file, the variables will not change. They also won't change manually when I try to and the following message pops up: "failure to convert variable to continuous: values contain text".

I have also checked my data multiple times and don't have text in the columns that I want to change.

Expected Behaviour

It should look like this:

It's showing up like this: and I cannot change it.

Steps to Reproduce

No idea.

Log (if any)

For JASP-Table 1.csv.zip

CVS file used is linked.

Final Checklist

• I have included a screenshot showcasing the issue, if possible.
• I have included a JASP file (zipped) or data file that causes the crash/bug, if applicable.
• I have accurately described the bug, and steps to reproduce it.

[shun2wang]

Yes exactly, if I look into the csv file it seems has about 100 empty rows at bottom, if I remove them then worked. in .csv we can see something like:

"
","
","
","
","
","
","
","
","
","
","
","
","

@boutinb it's really tricky, I remember we discussed we may find a way to trim empty rows,for now, we can at least detect active rows (black row numbers). We can work backwards from the last active row to determine whether it is a empty row, and then select the longest column as whole active rows number. For example:

JASP row No.	col1	col2	col3	col4
1	a	21	w	q
2	a	32	q
3		32	a
4			x
5

so we should trim row 5. blank rows at the top has little impact because it is easy for users to spot it and decide whether to remove it?Or only for this issue, we can consider how to skip empy values when convert the variable?

[cudzz]

Oh thank you. I got rid of the 11 rows and it worked! Somewhere along the procedure i must have copied too much over.

[tomtomme]

Confirmed for flatpak. Will close the duplicate #2623