Protecting sheets removes the all cell comments - LibreOffice Calc - file format xlsx

asked 2018-08-09 14:42:44 +0200

efkan gravatar image

updated 2018-08-09 16:45:48 +0200

My, LibreOffice versions: 5.1, OS: Elementary OS 0.4.1 x64 (a derivation of Ubuntu 16.04.2) Kernel: 4.4.0-131-generic

When I protect a sheet, the all comments I wrote on cells will be removed.

The steps to re-experience the issue: 1. open a blank sheet 2. right clik on any cell and select the command of "insert comment" 3. write down some text 4. right clik on the current sheet name from the bottom of the sheet 5. select the command of "protect sheet" 6. press on "OK" button on the dialog window (so, give a blank password) 7. save the current file with "*.xlsx" (MS Excel 2007-2019) file extension and close Calc application 8. re-open the file

Now it can be seen that there is no any comment on any cell, unfortunately..

Edit: Mike Kaganski has pointed out to file format. My file extension was xlsx. I'hve corrected the steps above.

edit retag flag offensive close merge delete


Works fine here with Version: (x64) Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 12; OS: Windows 10.0; UI render: GL; Locale: ru-RU (ru_RU); Calc: CL

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-09 15:00:29 +0200 )edit

I remove the current LibreOffice and downloaded v6.1.0.3 and tested again. The issue continueing on Elementary OS. I tried on 2 different computer with different versions but unfortunately..

efkan gravatar imageefkan ( 2018-08-09 16:01:28 +0200 )edit

Maybe the short "save the current file" hides a secret, like "save to format FOO"?

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-09 16:37:50 +0200 )edit

Yes! I have completely forgotten that my file extension is "xlsx". I have to edit the question...

efkan gravatar imageefkan ( 2018-08-09 16:40:55 +0200 )edit

Yes - this way I reproduce; please file a bug report.

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-09 16:48:16 +0200 )edit
efkan gravatar imageefkan ( 2018-08-10 07:37:54 +0200 )edit