Date Picker Calendar

Set a date in selected cell/cells.Places a calendar push button in the selected cell and puts the date in the cell to the left or right of the push button.

★ ★ ★ ☆ ☆
Business Calc Spreadsheets
Download latest

latest release: 2024-03-21 10:48:10

Description

There are 3 tool buttons:

- Date: the date from the calendar will be inserted in the selected cell / cells.

- Date <-Button: a calendar button is created in the selected cell, the date is inserted in the cell to the left of the button.

- Button-> Date: a calendar button is created in the selected cell, the date is inserted in the cell to the right of the button.

 

There is a 'Calendar Help' menu item in the Help menu of LibreOffice.

Release List

Release Description Compatibility Operating Systems License Release notes   2.60 Date Picker Calendar 4.0 Windows

Version 2.60:
- Change and save settings of the calendar.
- Frame around date in calendar when mouse hovers over them.
- Remove all date buttons at once (created since version 2.60).
- Make a choice via menu Tools - Add-Ons.

Version 2.50:
- Labels on the date buttons were changed.
- If the cell already contains a date, the date picker will open with the existing date,
otherwise with the current date (only for cells associated with date buttons and
one or more selected cells in a continuous range).
- It is possible to change the year by 1 or 10 years forward or backwards.
  The year can also be entered.
- The months can also be selected from a list.
- It is no longer possible to place multiple buttons on 1 cell.

Download 2.41 First release as a extension Windows

Other Extensions

Date Picker Calendar

Set a date in selected cell/cells.Places a calendar push button in the selected cell and puts the date in the cell to the left or right of the push button.

04-2024

2565

★ ★ ★ ☆ ☆

ISO date header footer

Set the date in ISO 8601 format in the header and/or footer of a Calc document.

04-2024

155

★ ★ ★ ★ ★

Feedback

★ ★ ★ ☆ ☆

Post your review

You cannot post reviews until you have logged in. Login.

Reviews

  • Jirka Bolech 21.09.2023, 20:26 (vor 7 Monate)

    ★ ☆ ☆ ☆ ☆

    In my humble opinion, unless such an extension generates a true date format (Unix time value) as opposed to a text string, it is useless…

  • Marco Walser 02.11.2022, 11:43 (vor 18 Monate)

    ★ ★ ★ ★ ☆

    Great extension.
    But how can I delete single date buttons?

  • Timothy Tan 08.09.2022, 05:13 (vor 20 Monate)

    ☆ ☆ ☆ ☆ ☆

    We love your extension! May I know what license this is published under?

  • Jeremy Keller 12.08.2021, 12:17 (vor 3 Jahre)

    ★ ★ ★ ★ ★

    Any chance you can add a time picker to this? Another button at the bottom which inserts today's date & time would be spectacular!

  • Vladyslav Orlov 02.06.2021, 19:17 (vor 3 Jahre)

    ★ ★ ★ ★ ☆

    Good idea, solid implementation. Just a few notes. Perhaps, the labels on the buttons should be improved - for example :::> and <::: so that it is clear which side of the button the date will be inserted from (with a large number of buttons on the sheet, it is difficult to navigate). Entering the date "from today" should be started if the target cell does not yet contain the date - if the date already exists, then the picker is used to edit it, and not to enter the date from the very beginning. You should simplify the choice of the year and month (perhaps using drop-down lists or auxiliary forms) - if you need to enter the date of birth of a person who was born in the last century, you have to click on the arrow many times to get to the desired year. Before inserting a button into a cell, it makes sense to check if it is already there - erroneous repeated clicks of a button on a panel can create many buttons in the cell.

    • Geert Geerits 04.06.2021, 20:24 (vor 3 Jahre)

      Hi, thanks for your comments. I'll see what I can do, but it'll take some time.

RSS feed for reviews on this page | RSS feed for all reviews