Date Picker Calendar

Tags: Business Calc Spreadsheets

Rating:

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.

Calendar LO v5

Description

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.

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

Changes since version 2.41
- Labels on the date buttons were changed to <::: and :::>.
- 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.

Release List

Release: 2.50

Compatibility:
Operating Systems: Windows
License:

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.

06-2021

Feedback

Post your review

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

Reviews

  • Vladyslav Orlov Jun 2, 2021, 7:17 PM (12 days ago)

    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 Jun 4, 2021, 8:24 PM (10 days ago)

      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