Bug 61483

Summary: The hide comments are disappeared after the worksheet copy
Product: LibreOffice Reporter: mwu
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: mwu
Priority: medium    
Version: 4.0.0.3 release   
Hardware: x86 (IA32)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: a file for hide comment disappearance test

Description mwu 2013-02-26 06:15:32 UTC
Created attachment 75551 [details]
a file for hide comment disappearance test

When we do a sheet copy in a spreadsheet file, the hide comments in the original sheet will get disappeared after the file save and reopen the file. Take the attached file for an example :

1. open the attached file.
2. copy the sheet "hide" to a new sheet.
3. save the file and close it.
4. reopen the file.
5. the hide comments of the new sheet exist just the same as the sheet "hide_orig", but the hide comments in the sheet "hide" are disappeared.

Please help to check what the problem is and fix it. Thank you.
Comment 1 Yifan Jiang 2013-02-26 09:03:06 UTC
I can confirm the problem. Thanks for the nice catch!
Comment 2 mwu 2013-02-27 07:58:02 UTC
One more thing to supplement: If the content of the cell with a comment is numeric, then the comment will not disappear. Thank you.
Comment 3 mwu 2013-08-06 03:03:07 UTC
The bug is not fixed in Libreoffice 4.1.0.4 still. Thanks
Comment 4 mwu 2013-08-06 03:53:35 UTC
Very sorry that I have made some mistakes in 4.1.0.4 for test and the bug is not in 4.1.0.4. Sorry for the harassment.
Comment 5 retired 2013-11-19 23:26:14 UTC
Thanks for updating this bug report. Since we don’t have any commit fixing this issue, the correct state for this bug is WORKSFORME.
Comment 6 mwu 2014-02-07 07:54:18 UTC
The bug is fixed in Libreoffice 4.2.0.4. Thanks and regards.