https://bugs.documentfoundation.org/show_bug.cgi?id=119190
Bug ID: 119190
Summary: Protecting sheets removes the all cell comments in
LibreOffice Calc if the file format had been given as
'xlsx'
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: efkan_tu...@yahoo.com
Description:
Current;
LibreOffice versions: 5.1, 6.0.5.2
OS: Elementary OS 0.4.1 x64 (a derivation of Ubuntu 16.04.2)
Kernel: 4.4.0-131-generic
File saving format: *.xlsx
When I protect a sheet, the all comments I wrote on cells will be removed.
The steps to reproduce the bug:
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.
Steps to Reproduce:
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
9. see that there is no any comment on any cell
Actual Results:
The all written comments have gone.
Expected Results:
The comments can be seen when mouse pointer over the cells.
On the other hand, the cells that have comments are specified by a tiny red
square at the top-left of the cells.
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
