Ask Your Question

how can i add a drop down calendar in calc? [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-05 19:49:05.994073

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )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 +0200 )edit

Thank you m.a.riosv!! Works beautifully

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

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-06-03 12:31:54 +0200 )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 +0200 )edit

Question Tools

1 follower


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

Seen: 4,055 times

Last updated: Jun 01 '17