Perpetual Calendar with Event List

Tags: Calc Spreadsheets

An automated ODF (OTS) spreadsheet offering considerable flexibility in generating monthly and yearly Gregorian calendars with the option to have events automatically be entered on their date of occurrence.

Screenshot from 2020 06 02 16 03 48

Description

This Perpetual Calendar template is an automated ODF (OTS) spreadsheet that offers the user:

  • nuanced style control for appearance,
  • variability of first-day-of-week,
  • variability of starting and ending months,
  • monthly calendars,
  • landscape yearly calendars, 
  • portrait yearly calendars.

The project also allows the user to insert, copy to, or create a sheet of events that will then automatically populate any of the calendar forms. Event dates and event details are selected from their source sheet by column number, giving the user a wide range of possibilities for importing or creating date/event tables.

 

Finally, the project also demonstrates the use of long-form cell formula entries, presents an alternative to messy sheet-scoped named ranges, and highlights the abilities of the TextJoin function.

 

Thanks!

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • Version 1.0 5.2 Linux GPL

    Developed and tested using LibreOffice Calc 6.4.3.2 on Linux Mint 19.3. Requires LO 5.2 at minimum for TextJoin function. May work with MS Excel versions with TextJoin (365 or 2019) if saved to xlsx format, but would require touch-up of styles since Excel does not understand style inheritance.

    Download

All Extensions by the same maintainer

Perpetual Calendar with Event List

An automated ODF (OTS) spreadsheet offering considerable flexibility in generating monthly and yearly Gregorian calendars with the option to have events automatically be entered on their date of occurrence.

07-2020

Feedback

☆ ☆ ☆ ☆ ☆

Post your review

Reviews

No one has commented on this page yet.

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