How do I add a Calendar Picker in Calc?

[GregoryOpera]

Pretty straight-forward - how do I add a pop-up calendar-picker in LibreOffice Calc?

I want users to click on a blank cell, causing a calendar to pop-up; users would then select a date/month/year with their mouse, which in turn cause the pop-up calendar to close and then date to be automatically entered into the previously-empty cell.

[mariosv]

There is an extension for it:

http://extensions.libreoffice.org/extension-center/calendar-for-calc

edited 20150902

Perhaps something like in this links could help to run the extension without call it with the keyboard:

Libreoffice Calc run macro with HYPERLINK

Event driven macro triggered "on cell change" WITHOUT a listener

I want to make an event driven macro triggered “on cell change” WITHOUT a listener. I know is possible to assign a macro to a sheet specific event via: sheet tab ->left click->sheet events (mine is in spanish so text might be different) So I guess I can wrap the whole macro in an IF checking if the modified cell is the one I want to monitor (e.g. “A:1”). Is there a variable I can use as an argument to check which cell is the one that has been modified???

[Aigars]

The extention requires Ctrl+Shift+F2 or Tools/Addons/Calendar to open. I’m looking for something like the author described. A calendar pop-up that is opened when cell is selected and closes when the date is entered (or closed manually).