Ask Your Question
0

how can i add a drop down calendar in calc?

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

1 Answer

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

There is an extension for that https://extensions.libreoffice.org/ex...

edit flag offensive delete link more

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 2,041 times

Last updated: Jun 01 '17