Hello,
This has just happened to me. First, I noticed that there where two versions of the comment I was editing pointing to the same cell. I copied the content of the cell and closed calc, when I opened again all of the comments where gone.
This has happend to me several times, and I have always been able to restore a previous version.
I am completely sure that I have not selected anything like “delete all comments”… Some of them have survived. I opened the file some months ago with onlyoffice, and the comments were somehow unformatted, all line feeds lost. That was not much of an issue… Since june I have deleted and recreated some comments (one per week). Now, only the new comments have dissapeared. The unformatted ones are still there.
Version 25.2.6.2 (X86_64) / Libreoffice Community
Running on Arch linux, last system upgrade october 25.
As @redart said, this seems to be a very resilient bug. I don’t know how to proceed from here, and if I can provide any additional information in order to chase it.
Update - I have opened it again and I have found that the “bad version” of the comment (one of the two I mentioned in the first paragraph) is still there, with two arrows pointing nowhere. It should be attached to the selected cell.