How Do I Create a Calendar in OpenOffice?

Like its cousin Microsoft Excel, the Calc spreadsheet program included in the Apache OpenOffice 4.1.1 software suite can be used to create a printable calendar. The trick lies in resizing columns and rows to make the most out of the available space and then formatting cells to create a coherent design.

...
One month of the finished calendar.
credit: Image courtesy of the Apache Software Foundation.

Step

Hold down the "Shift" key and then click cell G1 to select the first seven cells in the first row and then enable the "Merge Cells" check box to merge them into a single one.

...
Merging the first seven cells in the spreadsheet.
credit: Image courtesy of the Apache Software Foundation.
...
Changing the formatting of the cell.
credit: Image courtesy of the Apache Software Foundation.

Step

Click the "+" icon by the "Number Format" header to unfold that section of the menu, if it's not already visible, and then click the "ABC" button to set the cell's formatting to plain text.

...
Filling in the month, year and days of the week.
credit: Image courtesy of the Apache Software Foundation.

Step

Type the name of the month in the cell -- if you like, you can also add the year. Decide whether you want the week to start with Sunday or Monday. Type that day of the week into cell A2, followed by the rest of the days, in order, in cells B2 to G2.

...
Filling in the numbers for all days of the month.
credit: Image courtesy of the Apache Software Foundation.

Step

Find out what day the first day of the month falls on and type the number "1" in the corresponding cell in the third row. For example, January 1, 2015 is a Thursday, so you would type "1" in cell D3. Continue entering numbers into cells, moving to a new row when you reach the end of a week, until you've completed the whole month. If you like, add numbers to represent the end of the previous month and the beginning of the following month to complete the first and last week.

...
The OpenOffice Calc interface, with the Page Preview button highlighted.
credit: Image courtesy of the Apache Software Foundation.

Step

Click the "Page Preview" button to enter page preview mode. If you want your calendar print in landscape mode, click the "Format Page" button, select the "Paper" tab, select the "Landscape" radio button and click "OK." Click the "Page Preview" button again to return to normal mode. Entering and exiting page preview mode displays slightly thicker lines on the spreadsheet at the points where one page will end and the next will begin if you print out the calendar. If the vertical page break appears immediately after the last column of your calendar, skip the next step.

...
Setting the width of the calendar columns.
credit: Image courtesy of the Apache Software Foundation.

Step

Click "Format," hover over "Column" and select "Width." Make a note of the value that appears in the "Width" field and click "OK." Count the number of columns before the vertical page break, multiply that number by the value you found in the previous step and then divide the result by seven.

Step

For example, if the value in the "Width" field were 2.27 and your spreadsheet had 11 columns before the vertical page break, your calculation would be:

Step

(2.27 * 11) / 7 = 3.56

Step

Select the first seven columns of your spreadsheet, click "Format," hover over "Column" and select "Width" again. Enter your final result in the "Width" field and then click "OK." This sets all seven columns of your calendar to the same width without making them either too wide or too narrow -- unfortunately, OpenOffice Calc has no way of doing this automatically, so you have to do the calculations manually.

...
Adjusting the height of the first two rows.
credit: Image courtesy of the Apache Software Foundation.

Step

Adjust the first two rows of your calendar to the desired height. Do this either by simply dragging the row divider or, if you'd rather be precise, by selecting the rows, clicking "Format," hovering over "Row," selecting "Height," entering a value and clicking "OK."

...
Adjusting the height of the remaining rows.
credit: Image courtesy of the Apache Software Foundation.

Step

Select the remaining rows of your calendar. Count the number of rows before the horizontal page break and subtract two from that number. Click "Format," hover over "Column" and select "Height." Multiply the value in the "Height" field by your result and then divide it by the number of rows you selected.

Step

For example, if the height value is 0.45, your result is 32 and you have selected 5 rows, your calculation will be:

Step

(0.45 * 32) / 5 = 2.88

Step

Enter the resulting value in the "Height" field and click "OK." This ensures the rows of your calendar that represent the weeks are of a consistent height and take up the remaining space on the page.

...
The finished calendar, with the formatting tools in the right-hand pane highlighted.
credit: Image courtesy of the Apache Software Foundation.

Step

Adjust the formatting for each of the cells using the various settings in the right-hand pane to get the desired look for your calendar. Once you're done, repeat the process to create the remaining months.