Bug 156336 - Can't remove Calc comment authorship metadata
Summary: Can't remove Calc comment authorship metadata
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Balázs Varga (allotropia)
URL:
Whiteboard: target:24.2.0
Keywords:
Depends on:
Blocks: Calc-Comments Privacy
  Show dependency treegraph
 
Reported: 2023-07-17 16:09 UTC by Gabor Kelemen (allotropia)
Modified: 2023-10-19 13:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc master to show the issue (11.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-07-17 16:09 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-07-17 16:09:43 UTC
Created attachment 188414 [details]
Example file from Calc master to show the issue

This is followup to bug 73537

Now in Calc the meta data related to who made a certain comment is displayed when the mouse hovers over the comment indicator in the cell.
It is not possible to edit/remove this sort of data.

1. In Calc, go to Insert - Comment and add a new comment to any cell
2. Hover over the comment indicator in the top right of the cell: it shows your name (as set in Options - User Data) and the date of when the comment was added.
3. Go to Options - Security, press Options button
4. In the Security Options and Warnings dialog check the Remove personal information on saving box.
5. Save the file and reload it. Attachment is an example of the result of this process.

-> Hover over the comment indicator in the top right of the cell: it still shows your name (as set in Options - User Data) and the date of when the comment was added.

I'd expect that after the Remove personal information on saving box is checked, all such information is removed (or reset to Unknown Author and 1970-01-01 at the very least) upon saving, whether I just added it or it was there before opening the file.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fcbae818b793a9ee97a1b5ddc53902be7a2376f5
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2023-08-02 20:55:58 UTC
Reproduced with:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 47ca3f1f762352b488d58b3bf23d5776576f1cca
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Writer does replace commenters' names with "Author1", "Author2", etc. when using that option and saving.
Comment 2 Commit Notification 2023-10-19 12:16:44 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/87e1a77a9aadb883386816dc4ebc3dad64c81892

tdf#156336 - sc ods: fix can't remove Calc comment metadata

It will be available in 24.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.