Bug 161142 - DATA LOSS!!! Libreoffice calc comments vanished
Summary: DATA LOSS!!! Libreoffice calc comments vanished
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-16 23:35 UTC by ralf.fehlau
Modified: 2024-05-17 17:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description ralf.fehlau 2024-05-16 23:35:14 UTC
Description:
As the title says, the comments in arbitrary cells of a calc document have vanished!

I have a document with serious data which I use dayly. Today I have seen, that random data dissapeared.

Steps to Reproduce:
no hint why this happened.

Actual Results:
comments randomly vanished

Expected Results:
NO DATA LOSS , of course!


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 Stéphane Guillou (stragu) 2024-05-17 03:55:57 UTC
Sorry that happened to you.

I understand it wasn't all the comments in all the sheets?
Note that there is a command to remove all comments: Sheet > Cell Comments > Delete all comments. That action does not currently ask to confirm, please see bug 160219.

Unfortunately, without more precise steps to reproduce the issue (format used, commands used), and possibly a sample document attached here, we won't be able to investigate.

Furthermore, version 6.4 is not maintained anymore, so please update to a currently maintained version, preferably 24.2.
Please let us know if you still experience the issue, and if that's the case, provide more details.

Thank you!
Comment 2 ralf.fehlau 2024-05-17 12:34:31 UTC
I cannot provide a document, because it contains private data.

This libreoffice version runs on ubuntu 20.04 LTS. :-(

I found a backup copy from january which contains the comments of the recent years. Nevertheless there is plenty of work to recover the data for this year. I guess several weeks of work.

The cells, who loose the comments are random, full last column is lost, and several rows are complete / partially lost, whithout any rule. I'm a c/c++/java developer ... and I will not imagine, what happend to my data.
Comment 3 m_a_riosv 2024-05-17 17:13:35 UTC
What file format do you use to save?