Bug 71478

Summary: The hide comments are disappeared after the worksheet copy operation
Product: LibreOffice Reporter: mwu
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED QA Contact:
Severity: major    
Priority: highest CC: barta, gautier.sophie, jbfaure, mwu
Version: 4.1.3.2 release   
Hardware: x86 (IA32)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Bug Depends on:    
Bug Blocks: 60270    
Attachments: a file for hide comments disappearance test

Description mwu 2013-11-11 09:58:36 UTC
Created attachment 89005 [details]
a file for hide comments disappearance test

I have reported this issue with the Bug ID 61483. Because this issue is not appeared sometimes, I change the status as fixed. However, due to the tests for a period of time, I have confirmed this issue is not fixed completely. Hence, I reopen a new bug ID. Please help to check this issue and give some suggestions to get rid of it if available. Below are the steps :

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.

Thank you and regards.
Comment 1 sophie 2013-11-12 15:48:47 UTC
Confirmed with Version: 4.1.3.2
Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a
The comments mark are still there at the top right of the cells. Trying to display one of them (right click > display comment) display it in fact on the copied sheet. 
Set to New - Sophie
Comment 2 mwu 2014-02-20 01:55:45 UTC
This bug is fixed in the release 4.2.0.4. Thank you and regards.
Comment 3 mwu 2014-02-20 01:58:25 UTC
Because there is another hidden comments issue as reported in Bug 75236. Please be careful to use the 4.2.0.4 release. Thank you and regards.
Comment 4 Loge 2014-02-24 16:44:39 UTC
still NOT solved: right TODAY i got the same issue on a spreadsheet which i entried my monthly expenses in: ALL the comments have disappeared. 
i had used this file yesterday or two days ago (and comments were still there), today i opened it to entry a new value, and closed it again. this afternoon i opened it once more to further entry some datas, and i noticed that comments are not there anymore. 

the same thing happened to me about two years ago, when i passed from windows to ubuntu and therefore i decided to convert several spreadsheets from excel to libreoffice calc. 

version: 4.2.0.4
Build ID: 420m0(Build:4)
O.S.: Ubuntu 12.04 kernel 3.13

thanks for your (eventual) help. 

Andy.
Comment 5 sophie 2014-02-24 17:56:02 UTC
Please do not change the version, we must keep the first version where we found it. 
I tested with version 4.1.5.3 under Debian and I still can reproduce the bug. 
Left reopened and add it to MAB because of data loss. Sophie
Comment 6 Jean-Baptiste Faure 2014-02-24 19:42:29 UTC
(In reply to comment #4)
> still NOT solved: right TODAY i got the same issue on a spreadsheet which i
> entried my monthly expenses in: ALL the comments have disappeared. 

I think that what you describe does not fit exactly the bug description (you do not copy a sheet). That fits better the description of the bug 74325 which is fixed in version 4.2.1.
You should try this version.

Best regards. JBF
Comment 7 tommy27 2014-05-10 06:30:55 UTC
let's close again this issue since the bug in the original description has been fixed (see comment 2) and problem in comment 4 was a different problem which has been fixed as well.

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.