search

nfdi4plants / Swate

Excel Add-In for annotation of experimental data and computational workflows.
https://swate-alpha.nfdi4plants.org
MIT License
31 stars 6 forks source link

[Bug]: Cannot open isa.study.xlsx file in Excel (macos and windows) #474

Closed Mestizia closed 1 month ago

Mestizia commented 1 month ago

Contact Details

No response

What happened?

When opening isa.study.xlsx file in Excel after adding a study sheet and populating it with headers (both macos and windows) it prompts an alert message (see screenshots). To open the file, it has to "repair it". If you then save the changes, the sheet will not appear in arcitect any longer. image image

The changes automatically made are the following (macos): image

What did you expect?

No response

Host

ARCitect

Host Details

Excel version 16.78 (macos)

Swate version

Swate Release Version v1.0.0-beta.04

Freymaurer commented 1 month ago

Hello! Could you share an example file with us? I will look into this!

Mestizia commented 1 month ago

Here you go isa.study.xlsx

Freymaurer commented 1 month ago

Ah okay, i see the issue the table from worksheet NewTable0 is removed, after reopening. This makes it not readable for Swate/ARCitect. Sadly this seems to be a deeper nested issue, which might take some time to investigate.

image

Freymaurer commented 1 month ago

Hey again, i tried to investigate this issue but i am unable to reproduce it with the columns you used. I am on windows 11. You said you had the same issues on windows?

Freymaurer commented 1 month ago

Will close for now, feel free to reopen