https://bugs.documentfoundation.org/show_bug.cgi?id=86725
--- Comment #30 from Dan <dinny...@gmail.com> ---
Ok, I have a minimal example to reproduce the bug:
1.) create a new spreadsheet
2.) select a cell A1, and enter the number 42 in it.
3.) add a comment to the cell: "The answer to everything". (keep the comment
hidden, the bug only seem to happen with hidden comments)
4.) save the document in .fods format
5.) reload the document with File > Reload,
6.) verify that the comment is still there!
7.) create another sheet, select a cell, and enter the formula: =$Sheet1.A1*12
8.) save the document
9.) reload the document with File > Reload
10.) verify that the comment is still there!
11.) update the cell with the referencing formula on Sheet2 and change the
formula to =$Sheet1.A1*13
12.) save the document
13.) reload the document with File > Reload
14.) verify that the comment is fucking gone on Sheet1!!!
The key thing seems to be that once a relationship is established between two
sheets, and then it is updated (by adding more references, or changing some of
the formulas), then the comments get removed from the referenced sheet.
--
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
