A calendar, that gives you an overview about half a year, is sometimes very handy. But you’ll need a new one every year. So - why bother buying one every year when you can create one on your own? That’s what I thought a couple of year back and created OOoCalendar - a simple calendar generator based on OpenOffice/LibreOffice.

This spreadsheet application creates a new spreadsheet, fills in the days of the year including well known (German) public holidays. You can then either print it directly or create e.g. a PDF. It even supports defining additional public holidays or e.g. birthdays that will be pre-entered in the calendar.


The calendar application is available in one spreadsheet file. Download it here:

In case you just want the calendar, I prepared one for 2016:

Certificates / Signatures

As this spreadsheet uses macros, you’ll need to accept my signature and trust me, so that libreoffice will execute the calendar application. I’ve signed both the document and the macros with two self-signed certificates.

The SHA1/SHA256 sums of these are:

  • First Certificate: Expires on 2018-02-10

    6B:A8:D6:5B:61:5C:89:E1:82:1F:55:31:E6:83:70:F1:E9:69:7A:FA (sha1)

    5F:8F:58:24:4B:AC:86:1B:DF:2D:82:C8:32:C5:A7:2E:A9:92:C4:65:10:89:05:CA:B7:A0:9B:DD:3F:E1:47:BF (sha256)

  • Second Certificate: Expires on 2025-09-30:

    35:07:51:99:F1:08:CB:28:84:0C:8E:D7:FC:4E:E6:CF:BC:A1:53:81 (sha1)

    7B:62:6C:B1:6F:18:80:63:9E:A1:70:99:EC:F0:B4:C8:A3:5B:4D:D5:33:D1:05:5B:12:C1:D3:48:87:26:53:FD (sha256)

Unfortunately LibreOffice displays only the SHA1 sum, so you’ll need to compare that.

More information