[Libreoffice-bugs] [Bug 86725] Comments disappearing

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=86725

--- Comment #30 from Dan <dinnyesd at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210502/34c5cf7a/attachment.htm>