[Bug]: Issue with opening data filter applied in .xlsx files

[taylorbrown108]

JASP Version

0.19.3

Commit ID

No response

JASP Module

Other

What analysis are you seeing the problem on?

No response

What OS are you seeing the problem on?

Windows 11

Bug Description

I am unable to open some files on my jasp. When I do it gives me this error code -27 and states its unable to open due to an unexpected error while loading excel file.

Expected Behaviour

The file should open no problem. Before I downloaded the latest update of Jasp I had previously opened this file with no issues.

Steps to Reproduce

unknown

Log (if any)

cf_gss_data_2018.xlsx

More Debug Information

No response

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.

[tomtomme]

@taylorbrown108
thx for the report.
I can confirm the error.
However, when I remove the filter from the first row of the data, the file opens fine. This seems to be a limitation of the excel import module capabilites we implemented.

[boutinb]

Hi @taylorbrown108 : I'm not sure what is happening, but if I load this file in JASP.0.19.2, it does not work either (before 0.19.2, we did not support Excel format). If I save this file as .xls, then it works.

[boutinb]

It works also if I save it as ods or csv format.

[taylorbrown108]

Okay thank you, do you know I can save it as a csv? This is my first time using the software I’m not to familiar with how to work it. Sent from my iPhoneOn Jan 15, 2025, at 3:17 AM, bruno boutin ***@***.***> wrote: It works also if I save it as ods or csv format. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[shun2wang]

Yes, there is indeed a problem and we hope to fix it in the next release.