How to copy error message or find it in some log file

Error messages in Calc (and probably also in Writer etc.?) only let me click OK. I cannot copy the text of the error.
Is there some way to get to the content of such error messages? Either by finding it in a log file, or by changing a setting to make the window let me copy it’s content?
(I’m on Ubuntu 20.04 with LO v. 6.4.7.2)

You may find this helpful: Ubuntu Forum LO Log Location