Friday, February 15, 2013

Create your own calendar in LibreOffice 4

[Previously, there was an video with the captions below. It appeared to have infringed copyright on YouTube. Therefore, the video was deleted by the author of the video.]

Captions:

0:00:00.490,0:00:04.430
>> LibreOffice How-To:
Create your own calendar in LibreOffice 4

0:00:05.490,0:00:08.430
>> File -> New -> Spreadsheet



0:00:08.490,0:00:17.430
>> Type 2/3/2013 in A1
Type 2/4/2013 in B1

0:00:17.490,0:00:26.430
>> Select A1 and B1
Drag the handle to the right up to G1

0:00:27.490,0:00:33.430
>> Select A2 -> Type = -> Select A1
-> Type +7 -> Enter

0:00:33.490,0:00:39.430
>> Select B2 -> Type = -> Select B1
-> Type +7 -> Enter

0:00:39.490,0:00:45.430
>> Select C2 -> Type = -> Select C1
-> Type +7 -> Enter

0:00:45.490,0:00:49.430
>> Select A2, B2 and C2
-> Drag the handle to the right up to G2


0:00:49.490,0:00:55.430
>> Drag the handle downwards

0:00:55.490,0:00:59.430
>> Select columns A to G
Format -> Cells... -> Category -> Date

0:00:59.490,0:01:04.430
>> Format -> Cells... -> Category -> Date
-> Format code -> D -> OK

0:01:04.490,0:01:09.430
>> -> Format code -> D -> OK
Select columns A to G

0:01:09.490,0:01:11.430
>> Select columns A to G
Drag the boundary to resize the columns

0:01:11.490,0:01:14.430
>> Drag the boundary to resize the columns
Drag again to resize them

0:01:14.490,0:01:18.430
>> Select row 1 -> Right-click it
-> Insert Rows


0:01:18.490,0:01:21.430
>> Go to another spreadsheet,
select the days of the week -> Copy

0:01:21.490,0:01:25.430
>> Go back and select A1
-> Paste Drop-Down Arrow -> Unformatted text

0:01:25.490,0:01:29.430
>> Select H2 -> Type = -> Select G2
-> Enter -> Select H2

0:01:29.490,0:01:34.430
>> -> Enter -> Select H2
Format -> Cells... -> Category -> Date

0:01:34.490,0:01:39.430
>> Format -> Cells... -> Category -> Date
Format code -> MMM -> OK


0:01:39.490,0:01:45.430
>> Drag the handle downwards
Drag again

0:01:45.490,0:01:48.430
>> Drag the boundary to resize column H

No comments:

RSS