[Bug]: Open Document Spreadsheet

[RNE365]

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

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

...

Log (if any)

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.

[github-actions]

@RNE365, thanks for taking the time to create this issue. If possible (and applicable), please upload to the issue website (#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, [email protected]

[tomtomme]

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

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

[RNE365]

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 iOS<https://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) @RNE365<https://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 GitHub<#2617 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BDDS2KP4ZZFL4MW3NA6SLOLYWDMLLAVCNFSM6AAAAABECADMWGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZTHAZDGOBQHA>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[tomtomme]

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)?

[shun2wang]

Yes, confirmed that can be reproduced.

[RensDofferhoff]

Very interesting that this doesnt happen on linux. Its a standard format so you wouldn't assume line ending differences to matter

[RensDofferhoff]

Also occurs on Mac

[RensDofferhoff]

Saving this file once with libreoffice fixes the issues.
So with what software was this ods file created?

[shun2wang]

@RensDofferhoff change the .ods as .zip and we will find some meta info in the files😉 like document version and generator.

[RensDofferhoff]

ooh great tip! excel 2016

[tomtomme]

So this is a "wont fix" probably since ODS support in Excel 2016 was fairly buggy? I know from my own experience.

And msiX installed jasp has the same problem?

[RensDofferhoff]

I will do some more tests

[tomtomme]

Office 2016 is still supported....
"Mainstream support ended on October 13, 2020, and extended support for most editions of Office 2016 will end on October 14, 2025, the same day as Win10"

[tomtomme]

Still reproducible with 0.19.2 beta, file should show no missings after import, see:
2.Proportion.Test.jasp.zip

[tomtomme]

@RensDofferhoff
I guess it is not a priority to fix ODS-file-import for office 2016 files until october, when its support ends? Then we should honestly speaking close this one as a wont-fix.