Ask Your Question

[Feature request] Ability to make cells in Calc clickable.

asked 2017-08-13 23:32:04 +0200

MuldoonsGhost gravatar image

updated 2017-08-13 23:33:15 +0200

I want to be able to click and say yes / no to make decisions. There is a check box feature but it is very buggy and not stable. I often find boxes missing or moved. When that happens I have to investigate the properties and see which cells that are linked to to replace it into the correct position. They are not easy to size and if I want to do a lot of them I can't just drag and copy as I can with a cell, I have to do them one at a time. It is not intuitive and it's slow.

It would be so much easier if an actual cell could be deemed clickable and it could change colour or have an image as a tick, cross or whatever.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-08-14 00:35:53 +0200

Lupp gravatar image

-1- Feature requests are to file as "enhancement" to
-2- I personally cannot see much use in the clickeria.
-3- If you click on a cell, the sheet event 'Selection changed' is generated. You can assign a "macro" to intercept the event and to do whatever you want.

This attached demo demonstrates the mentioned way using the code below.

Sub Test(pEvent)
If NOT pEvent.SupportsService("") Then Exit Sub
If  pEvent.CellStyle = "csGoDefaultWhenClicked" Then 
    pEvent.CellStyle = "Default"
End If
End Sub
edit flag offensive delete link more

answered 2017-08-14 10:03:52 +0200

JohnSUN gravatar image

Perhaps you will be satisfied with the solutions given in the answers to this question. I mean files SumByMarked.ods (from answer) or SumByMarkedWithoutMacro.ods (from comments)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-13 23:32:04 +0200

Seen: 73 times

Last updated: Aug 14 '17