Description: 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
Juan, please give us more detail steps what did you do. Like: 1. Open calc 2. Create a comment in A1 cell 3. Save file as ODS and close it 4. Reopen the file => comment disappeared
Is like you indicate: 1. Open with calc a file create in an old version (7.0.4.2) 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
No repro from scratch in Version: 7.2.0.0.alpha0+ (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
This is the file where disapperar comments en some cells: https://drive.google.com/file/d/1ukEYv6orQQcawPBC_uwJCW8IVyjm_DIl/view?usp=sharing 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: https://drive.google.com/file/d/1cIeqA0GGGn2eZQA_4NIy6pROPFaR2xpq/view?usp=sharing https://drive.google.com/file/d/11bxJ4tnviCM9BTnuDJCRbBEt2ZT89NNt/view?usp=sharing https://drive.google.com/file/d/12Ozv4X4MTlo0IZaCl_ijvtnzqCs9fO88/view?usp=sharing
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.
Yeah I know. My neuron is up to that!
[Automated Action] NeedInfo-To-Unconfirmed
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Created attachment 173354 [details] Sample ODS from comment 4 Let's attach the sample from comment 4 here, to preserve it for the future.
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: 7.1.5.2 (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
Created attachment 176945 [details] File showing all comments present
Created attachment 176946 [details] Save file after control copy/paste with missing comments
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.
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.
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
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 MassPing-UntouchedBug
Pasting shapes changes the cell address of comments and all objects anchored at a cell. This has started with commit 545737df40880875304bffc3f49800d1d2e99723 Author: Kohei Yoshida <kohei.yoshida@gmail.com> Date: Fri Jan 25 12:57:14 2013 -0500 ScDrawLayer::SetCellAnchoredFromPosition(...) ScViewFunc::PasteDraw(...) Line 246