How do I add a drop down calendar to cells in Librecalc 7.4? I want to pick a date from the dropdown calendar to have inputted into the cell

[wmdejaegher]

How do I add a drop down calendar to cells in Librecalc 7.4? I want to pick a date from the dropdown calendar to have inputted into the cell.

[sokol92]

You can try calCalc.

[erAck]

Add dropdown calendar

Menu/View/Toolbars/Form controls Click the last icon on the right ‘More controls’ Select ‘Date field’ Draw it. Right-click on it. General tab. Go down and change ‘Dropdown’ to yes. On the ‘Form’ toolbar next to the arrow disable ‘Design mode’ to use the control. Edited 20170302 [image description]

[mariosv]

But if I’m not wrong, date form control doesn’t allow linking the value with a cell.

[erAck]

Odd omission… However, this might help, but I didn’t try:

Insert a date from date field into a cell

Hi This is possible by macro as explained in this wiki page. It is in French, but it includes a sample spreadsheet that you might inspire you. [EDIT] Steps: Create the macro (copied from the wiki) Specify the target cell in the Data Fieldof the Control’s Data tab Select the macro by clicking the […] button of Text modified the Events tab: [screenshot] Regards