latest release: 2022-11-05 22:47:58
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.
Please note: In version 1.00 all event data must be imported as pure text. Dates must be represented as text. Please use the Paste Special Import Dialog and uncheck Detect Special Numbers to make certain data are purely text and not formatted data objects. (Thanks Arlyn N for noting this). In version 2.00 dates should be represented as dates.
Release: Version 2.0 – Converted to use Named Expressions and a single macro User Defined Function
Operating Systems: Linux, Windows, macOS
This version repairs problems formatting days with multiple events. It also solves the insanity of the previous function sizes. However, it is slower and does require macro permission because of a single User Defined Function (which can easily be checked as benign).
Release: Version 1.0 –
Operating Systems: Linux
Developed and tested using LibreOffice Calc 220.127.116.11 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.