How can I add a timer to LibreOffice Calc which displays in minutes and seconds? Ideally it would have a start and stop button(s). It would count upwards from 00:00.
Thanks, this looks promising but I got this error message :
A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.stopWatch.onButtonStartRelease?language=Basic&location=document.
Message: The following Basic script could not be found:
library: ‘Standard’
module: ‘stopWatch’
method: ‘onButtonStartRelease’
location: ‘document’
I’m not proficient with Calc, and I don’t know much about scripts and macros. Does the error message mean that parts of the script weren’t embedded in the example file but should have been? Or does it mean I have to add the stopWatch module to my setup? Or something else?
[EDIT to explain how dumb I am]
I hadn’t noticed that the document that opened wasn’t in edit mode, then it too me a while to work out that I should switch off form controls. Then I got this error message :
“com.sun.star.uno.RuntimeException”
The error was mine. I had uploaded a bad version. Since I noticed the error soon and changed the upload, I thought nobody might yet have downloaded. Download anew, and things should work as expected.
This is one of the cases where the user routines cannot easily be moved to the local ‘Standard’ library. The reason is that the routines need to co-operate in a way specific to the use case.
Thanks, It’s working now, and it is exactly what I wanted. I will now need to customise this so that the output cell fits into my desired layout, but I should be able to figure that out myself (crosses fingers).
I’m very grateful.