[Bug]: Open Document Spreadsheet

RNE365 commented 4 months ago

JASP Version

0.18.3

Commit ID

No response

JASP Module

Unrelated

What analysis are you seeing the problem on?

Opening files

What OS are you seeing the problem on?

Windows 10

Bug Description

I have a very simple Open Document Spreadsheet (.ods) file that I want to analyse. I read in "The Guide For Students" that JASP is able to open this type of file, but when when viewed in JASP the data is not as expected - there are gaps in the rows. Maybe this because the file has two worksheets? I would 2 Proportion Test.ods

Expected Behaviour

I expected JASP to open the .ods file and present me with data correctly presented. I even expected to be able to view data from multiple sheets.

Steps to Reproduce

Open .ods file
Review data to find it's not what expected. Open in Excel to see the difference.

...

Log (if any)

No response

Final Checklist

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

github-actions[bot] commented 4 months ago

@RNE365, thanks for taking the time to create this issue. If possible (and applicable), please upload to the issue website (https://github.com/jasp-stats/jasp-issues/issues/2617) a screenshot showcasing the problem, and/or a compressed (zipped) .jasp file or the data file that causes the issue. If you would prefer not to make your data publicly available, you can send your file(s) directly to us, issues@jasp-stats.org

tomtomme commented 4 months ago

@RNE365 Interesting! I cannot replicate on flatpak / linux:

[ ] What happens if you save the ODS locally instead of on onedrive?
[ ] What happens with CSVs?
[x] Are win10 and excel completely updated?

RNE365 commented 4 months ago

Hello there. Why test on Linux when the issue is on Windows? In answer to your question, everything is up to date. Thanks

Sent from Outlook for iOShttps://aka.ms/o0ukef

From: Thomas Langkamp @.> Sent: Friday, March 1, 2024 7:55:33 PM To: jasp-stats/jasp-issues @.> Cc: Richard Edwards @.>; Mention @.> Subject: Re: [jasp-stats/jasp-issues] [Bug]: Open Document Spreadsheet (Issue #2617)

@RNE365https://github.com/RNE365 Interesting! I cannot replicate on flatpak / linux: image.png (view on web)https://github.com/jasp-stats/jasp-issues/assets/4428185/981c6248-adb9-4b4c-ab46-0264b01d78a0

What happens if you save the ODS locally instead of on onedrive? What happens with CSVs? Are win10 and excel completely updated?

— Reply to this email directly, view it on GitHubhttps://github.com/jasp-stats/jasp-issues/issues/2617#issuecomment-1973823808, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BDDS2KP4ZZFL4MW3NA6SLOLYWDMLLAVCNFSM6AAAAABECADMWGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZTHAZDGOBQHA. You are receiving this because you were mentioned.Message ID: @.***>

tomtomme commented 4 months ago

Others will test on win. I only have linux here. I test on it to narrow down varibles. Now we know it might be win only.

[ ] Did you test without onedrive?
[ ] Did you test CSVs?
[ ] Did you test installing jasp via the ms store, which uses a new installer (msix)?