When I insert a TEMPORARY column into a spreadsheet, say column Q, libreoffice automatically inserts a comment that says, “Unknown Author - date and time - column Q inserted.” When I add the data to the cell ’ say, 235’ in the inserted column, libreoffice inserts a comment that says, "Unknown Author - date and time - cell Q25 changed from empty to ‘235.’ When I am finished with the calculation checks, and I remove column Q, libreoffice inserts a comment that says, "Unknown Author - date and time - column Q-Q deleted. How can I remove these superfluous and unwanted comments from the final copy? Clear Contents with only the Comments Box checked doesn’t work. HELP!
Sounds like “track changes”.
https://help.libreoffice.org/latest/en-ZA/text/shared/01/02230000.html
I have not used the feature in Calc, but usually you have to “accept” all changes.
.
To auto-detect this you need to use an edition of LibreOffice with clairvoyance. Currently a rare feature.