[Bug]: Changes to the ISA file done outside of Swate are not displayed in Swate

[Hannah-Doerpholz]

Contact Details

No response

What happened?

I tried modifying my ISA assay outside of Swate for convenience. When I add a new row and then try to open my file with either the web version of Swate, or within the ARCitect, the new row does not show up.
I modified my file using LibreOffice Calc and saved it again in xlsx format. This is when this issue occures.

I also tried modifying my file in the web version of Excel. When I upload my file to my account here, then add a new row, download the file again, and replace my old ARC ISA file with the new modified file, the new row can successfully be displayed in Swate (both in the web version and within the ARCitect).

My problem is that I don't want to upload my file to my Microsoft account, modify, download, and replace it every time I want to make some changes. Is there a way to potentially fix this?

What did you expect?

I expected the new row to be displayed.

Host

Applies to All

Host Details

OS: Ubuntu 22.04.4 LTS
Swate (web): v1.0.0-beta.26
Swate (ARCitect): Swate Release Version v1.0.0-beta.26
ARCitect: v0.0.54

Swate version

v1.0.0-beta.26

[Etschbeijer]

Hi @Hannah-Doerpholz,
I have got some questions, I hope that is ok for you.
When you were using the LibreOffice Calc (I do not know that program sry), did you expand the table or just add another row with information?

[Hannah-Doerpholz]

For sure, ask away. LibreOffice Calc is kind of like Excel for modifying tabular files, its just a free program. When I open an ISA file, like my assay file, all columns are automatically displayed, nothing is hidden. I can essentially also just copy one of my "old" rows and add that right below the last row in my table, but it will not show up later in Swate.

[Hannah-Doerpholz]

A colleague showed me what it looks like in Excel where you have this blue/white highlighting of the rows. This does not appear in LibreOffice at all. There is nothing like this blue-surrounded table for me to expand, if that is what you mean.

[Freymaurer]

Hello! I think i know where the issue comes from. But could you please upload a minimal example that is not working in Swate anymore?

I think it is because there are multiple "dialects" of xlsx, all are technically correct but not all programs can read/write them. If you give us the file, i can start working on that dialect to make it work with our library.

[Hannah-Doerpholz]

working_isa.assay.xlsx

broken_isa.assay.xlsx

Sure. This is a mini demo file I created with the web Swate version (working_isa.assay.xlsx). I then added 1 new row with LibreOffice (broken_isa.assay.xlsx). This second row is not displayed.