Bug 140866 - Cell comments disappear when form control copied on the sheet (steps: comment 10)
Summary: Cell comments disappear when form control copied on the sheet (steps: commen...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium major
Assignee: Not Assigned
Keywords: dataLoss
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
Reported: 2021-03-07 21:35 UTC by Juan Aspeitiagoitia
Modified: 2024-01-26 03:14 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Sample ODS from comment 4 (2.29 MB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-05 01:05 UTC, Aron Budea
File showing all comments present (11.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-12-15 11:39 UTC, PaulSh
Save file after control copy/paste with missing comments (12.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-12-15 11:40 UTC, PaulSh

Note You need to log in before you can comment on or make changes to this bug.
Description Juan Aspeitiagoitia 2021-03-07 21:35:27 UTC
When opening a file, comments entered in some cells have disappeared (even a file saved with the previous version and that had all the comments entered when opening it, these comments are not there)

Actual Results:

I do not understand

Expected Results:

I do not understand

Reproducible: Sometimes

User Profile Reset: No

Additional Info:

I do not understand
Comment 1 Roman Kuznetsov 2021-03-08 19:28:43 UTC
Juan, please give us more detail steps what did you do. 


1. Open calc
2. Create a comment in A1 cell
3. Save file as ODS and close it
4. Reopen the file => comment disappeared
Comment 2 Juan Aspeitiagoitia 2021-03-08 20:45:25 UTC
Is like you indicate:

1. Open with calc a file create in an old version ( that have comments in some cells
2. Do some changes and ad new comments
3. Save file as ODS and close it
4. Reopen the file => some comment disappeared
Comment 3 Roman Kuznetsov 2021-03-08 21:41:27 UTC
No repro from scratch in

Version: (x64) / LibreOffice Community
Build ID: 72841008bf422dfd8553240b3a78f0474d03523c
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

if you have the file created in previous LO version, then please attach it here
Comment 4 Juan Aspeitiagoitia 2021-03-09 08:35:00 UTC
This is the file where disapperar comments en some cells:


and three images in which you can see the cells with comments and most of them disappear when opening the file with version 7.1.1:



Comment 5 himajin100000 2021-03-10 04:56:05 UTC
not reproducible.
As you can see, there is a small red square(comment indicator) in the cell, and when you hover over the small red square, you can see the comment content.
Comment 6 Juan Aspeitiagoitia 2021-03-10 07:53:07 UTC
Yeah I know. My neuron is up to that!
Comment 7 QA Administrators 2021-03-11 04:50:12 UTC Comment hidden (obsolete)
Comment 8 Xisco Faulí 2021-03-18 17:37:09 UTC Comment hidden (obsolete)
Comment 9 Aron Budea 2021-07-05 01:05:38 UTC
Created attachment 173354 [details]
Sample ODS from comment 4

Let's attach the sample from comment 4 here, to preserve it for the future.
Comment 10 PaulSh 2021-12-15 11:38:02 UTC
After literally YEARS of trying on and off to get a repro on this issue, I finally have one. OK, I guess I can't guarantee that my method of making comments disappear is the same as the OP's, but at least it's 100% reproducible.

1) Create an empty spreadsheet and add a comment to cell A1
2) Copy this cell through O1 so now there are 15 comments visible (I don't think the exact number is significant, it's just that I see columns A through O when I create a new sheet)
3) Copy the top row through row 40 so now there are 600 comments visible (again I don't think the exact number is significant, but doing this makes it very easy to see if a comment has gone missing)
4) In design mode, create a form control on the sheet in the uncommented region - I've tested with a button and a label
5) Save and close
6) Open the sheet - it should look fine
7) In design mode, select the control, copy it (ctrl+c), select a cell somewhere else in the uncommented region and paste (ctrl+v)
8) Save and close
9) Open the sheet - some comments will be missing!

One other thing to note is that even when comments have gone missing from the saved file, in the open sheet itself the comments are still present in both the sheet annotations object AND the individual cell annotation fields.

I will attach copies of the test sheet before and after the control was copied and pasted. Just for the sake of it, here's my Calc info, but really the issue has been there for a long, long time:

Version: (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL
Comment 11 PaulSh 2021-12-15 11:39:28 UTC
Created attachment 176945 [details]
File showing all comments present
Comment 12 PaulSh 2021-12-15 11:40:04 UTC
Created attachment 176946 [details]
Save file after control copy/paste with missing comments
Comment 13 PaulSh 2022-01-09 14:24:37 UTC
After some more testing, it seems that my above methodology can also trash the comments if a drawing object (e.g. a text box) is copy/pasted.
Comment 14 Timur 2022-01-17 13:53:13 UTC
Reproduced in LO 4.3 and 7.4+ with (great) steps from comment 10. 
Comments disappear randomly. Further saving deletes more comments. 
With 4.2 it was worse, all text and comments would disappear.
Comment 15 Juan Aspeitiagoitia 2022-01-17 16:53:14 UTC
perdón por no poder aportar al respecto del bug que reporté.. pero os consigo medio entender y seguir vuestras averiguaciones gracias al traductor de Google
Comment 16 QA Administrators 2024-01-26 03:14:25 UTC
Dear Juan Aspeitiagoitia,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team