Skip to content

[Bug]: .xlsx Excel import error: Unable to open file because: Could not select active worksheet, error code: -28 #3126

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
1 of 3 tasks
michelefiorentin opened this issue Jan 13, 2025 · 2 comments
Assignees
Labels
Bug: Medium Bugs that don't influence the basic function of the app, but it's better to fix them at some point. Component: Import/Export

Comments

@michelefiorentin
Copy link

JASP Version

0.19.3

Commit ID

No response

JASP Module

Unrelated, Acceptance Sampling

What analysis are you seeing the problem on?

importing file

What OS are you seeing the problem on?

Windows 11

Bug Description

Importing xlsx give error Unable to open file because: Could not select active worksheet, error code: -28 , converting same file to xls 93 (old excel format) it works

Expected Behaviour

open file

Steps to Reproduce

  1. open->computer ->downloads

...
VIDAS-2025 General UX Experience Questionaire(1-3).xlsx

Log (if any)

Unable to open file because: Could not select active worksheet, error code: -28

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
Copy link
Member

@michelefiorentin
thx for the report. I can confirm this on 0.19.3 flatpak. Possibly related to the pivot-filter function activated in that file?

@tomtomme tomtomme added Bug: Medium Bugs that don't influence the basic function of the app, but it's better to fix them at some point. Component: Import/Export and removed OS: Windows 11 Bug Module: jaspAcceptanceSampling labels Jan 13, 2025
@tomtomme
Copy link
Member

@michelefiorentin
I just tested my assumption. Removing the filter from row 1 of the xlsx file makes it importable to jasp. We also have another report with the same issue, see:
#3129

Thus I am closing this one as duplicate. Lets discuss over there.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug: Medium Bugs that don't influence the basic function of the app, but it's better to fix them at some point. Component: Import/Export
Projects
None yet
Development

No branches or pull requests

5 participants