[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:
Post a Comment