Ask Your Question
0

How to add min:sec timer to spreadsheet? [SOLVED]

asked 2019-08-01 17:18:42 +0100

loggerjack gravatar image

updated 2019-08-02 02:52:10 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-01 17:48:30 +0100

Lupp gravatar image

updated 2019-08-01 17:53:26 +0100

You will need user code.
Check this attached example to see if it is useful for you.

edit flag offensive delete link more

Comments

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"

loggerjack gravatar imageloggerjack ( 2019-08-01 17:58:45 +0100 )edit

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.

Lupp gravatar imageLupp ( 2019-08-01 18:02:09 +0100 )edit

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.

Lupp gravatar imageLupp ( 2019-08-01 18:08:07 +0100 )edit

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.

loggerjack gravatar imageloggerjack ( 2019-08-01 18:32:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-01 17:18:42 +0100

Seen: 58 times

Last updated: Aug 02