Ask Your Question

how can i add a drop down calendar in calc?

asked 2017-06-01 22:48:34 +0100

chuggins2050 gravatar image

making a spreadsheet with dates down one side. The dates I'm inputting are always changing. It's a huge drain on my time to input the correct date every time I change the spreadsheet. Is there a way that I can have a drop down calendar so I can select the date?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-01 23:55:08 +0100

m.a.riosv gravatar image

There is an extension for that

edit flag offensive delete link more


I have just installed this extension and wonder if there is a way to format the date to suit my locale in Australia. All the other dates in my spreadsheets are dd/mm/yyyy and it is confusing for users to suddenly be confronted with an ISO format.

Nookawarra gravatar imageNookawarra ( 2017-06-02 09:26:06 +0100 )edit

The option for set up the format is on Menu/Tools/Options/LibreOffice Calc/Calendar.

m.a.riosv gravatar imagem.a.riosv ( 2017-06-03 03:22:18 +0100 )edit

Thank you m.a.riosv!! Works beautifully

Nookawarra gravatar imageNookawarra ( 2017-06-03 11:49:27 +0100 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-06-03 12:31:54 +0100 )edit

I don't suppose this extension would be friendly to those co-workers who'd be opening this spreadsheet in Excel, would it? Maybe if I save as .xls or similar?

Dave S gravatar imageDave S ( 2018-10-03 21:20:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-01 22:48:34 +0100

Seen: 1,924 times

Last updated: Jun 01 '17