EXCEL files (*.xlsm, *xlsx) are not updated after editing, and the local version is corrupted

[repovi4]

Nextcloud Hub 8 (29.0.6) on trueNAS
I don’t see any point in pulling php and nginx versions out of the container, but if it’s important, please specify))

An EXCEL file containing formulas is not synchronized after local editing.For clarity of the problem, I attach screenshots.
If you open this file from a local disk, edit and save it, then drag it to the NC folder - everything works fine.
The problem has been observed since the very beginning of use, from about April 2024.

Steps to reproduce the error:

1. Create a file with formulas in the * format.xlsx or *.xlsm
2. We transfer the NC storage in any way.
3. Find the file in Windows Explorer
4. Run in EXCEL
5. We make arbitrary edits.
6. Save and close.
7. We open it again.

Спойлер

st.1

st.2

st.3

st.4

st.5

st.6

[tflidd]

And you don’t have this with other files, e.g. text files?

What looks a bit strange, you have the changing date being 16:31, then when you do the changes, you have a temporary file, and then in st 4, the date is 16:37, and the to be synced symbol is shown. Then in st. 5 the date is back to 16:31? And also the file size from 30990 kB is restored.

Did the Nextcloud client do that? Can you check this behavior on a local drive that is not synced?

[repovi4]

Yes, Nextcloud does not sync the file. When I need to work with it, I save it to the desktop (without syncing), edit, save, and then move it to the NC folder. If I copy it, everything works fine. The problem is only when editing.
I disabled office applications - XLSM still crashes.

Other files - TXT, DOC and others work fine.

Here I posted samples of files that break.
https://drive.google.com/drive/folders/1YoPOEUWbnp4FTOnz9UUsylXs9F04zf7t?usp=sharing

[tflidd]

Yes, perhaps someone with Excel can test this.

Other idea, can you pause syncing of the client, do the changes via Excel, save the file and close Excel and then resume the syncing. Purpose is to see whether the file change is not recognized properly and not synced, or the saving process from copying the file over is troubling the sync client. In theory, the sync client does not care about the file format.

[repovi4]

I can’t anymore, today I updated all applications to version 3.14.1. And it works much better!

1. Open the file, make changes, click “save” and wait for some time (subjectively - 10-20 seconds). Close. Everything updated correctly.
2. Open the file, make changes, close. Save when prompted. The file does not sync.

I presented both options in the video.

Screen-video

[tflidd]

Ok, like this I have no idea. Do you see differences in the log file of
the client?
https://docs.nextcloud.com/desktop/3.14/troubleshooting.html#log-files

It looks like the timing plays a role. Not sure if Excel does somethings
differently that is not captured by the Nextcloud client. If someone
with Excel can confirm, it will be better before creating a bug report.

[repovi4]

made a Debug Archive, from it a selection of all lines with a mention of the test file. I don’t know how useful it will be to post a file with 850 lines in 5 minutes of working with a test file.
At the same time, if we turn off support for virtual files, everything works fine, although not very fast.