Steps to reproduce problem: 1. Put any 3 different numbers or other values in 3 adjacent cells. 2. Add a comment comment to one of the cells. 3. Copy the cell with the comment. 4. Select the other two cells. 5. Select Paste Special from the menu or context menu, uncheck everything except Comments and click OK. Results: The comments are pasted to the other 2 cells, but the contents of the other two cells are cleared. Expected results: The comments should be pasted to the other 2 cells, but the contents of the other two cells should remain unchanged.
I can get the expected results if I check comments and select the operation Add, but if the cells contained formulas, that would not get the desired result.
Seems to work as designed: https://help.libreoffice.org/Common/Paste_Special#When_in_Calc:_Operations The comment is pasted to the other 2 cells, and the content of the other two cells remain unchanged with the operation Add (both when the result cell contains formula or not).
Hi, the comment is part of the cell content, so it works as expected and you even have a message indicating that the content of the target cells will be overwritten. From what I understand, you would like to be able to past the comment only without the cell content. Could you open an enhancement describing the comportment that you would like to see? Thanks! I'm closing this one - Sophie
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.