If you create a detailed Template where you want to put background colors or images into specific cells, you would use Cell Styles instead. You can apply either a color as a background, or an image, and again this applies to the sheet as a whole, and you may never need to use it. This is where you would set borders for the sheet as a whole, not for individual cells. Most of the time the things I print from Calc require this orientation, so it makes sense to specify it in the Default. But I will make a change from Portrait to Landscape for my orientation. And I don’t see the need to mess around with the margins here. If you were creating a Template for something wide and wanted to use wider paper, such as what we call Legal size (8.5″ x 14″), you could specify a paper tray that always has that size of paper, but this is a default. But if you installed LibreOffice in a country that uses sensible measurments you probably don’t need to change anything.įor a Default Template there is not a lot on this tab that merits a change. To do this, go to Tools–>Options–>LibreOffice Calc–>General and make the change. If you want to change that to millimeters, there is a setting in LibreOffice to make this change, but it makes the change for Calc in general, not just for this Template. Note that this still will leave your measurements in inches. Just click the drop-down button and change “Letter” to A4. Note that I can change it here in this style, however, if I wanted to use A4. It picks this up from my computer that I am located in the U.S. it specifies Letter size paper with the dimensions 8.5″ x 11″. This gives you printer settings, basically. But note that we can create a new style, assign it to the blank sheet, and since this is the Default Template every new spreadsheet we create from this Template will use that new Style. Linking styles is something fairly advanced so I don’t recommend it to someone still learning about Styles. If those are things you really need to do, you should create new style based on this, give it whatever name you like, and make your links there. This is a built-in style and so you cannot rename it or link it to another style. There is not anything you can do on this tab. Let’s look at each of the tabs and make some settings. LibreOffice is a unified suite, so things should be much the same no matter which module you are in. This looks a bit like the ones we used in Writer, and that should not be a surprise. This opens the Properties window for the Default Page Style: Now that I am in my Default Template, I right-click on the Default Page Style, and select “Modify”. Any changes I make and save will show up in every spreadsheet I open form now on as long as I don’t specifically choose some other Template. I check the Title Bar at the very top, and it reads “KOB Default.ots”, so I know I am now in my Default Template. So now I open the Template Manager, go to the My Templates folder, select the KOB Default Template, and then click the Edit button on top. I created my own Default Template last time, which I named KOB Default. I plan to modify my Default Page Style, but I know (from the last tutorial) that if I don’t first open my Default Template I won’t be saving any of my work. And finally, you can start from scratch by right-clicking anywhere inside the Styles and Formatting window and selecting “New”. To do that, you select the Page Style you want to use as your starting point, then go the New Style from Selection button, which is the second from the right. Alternatively, you can create a new style based on the existing style, give it a new name, and add to your Page Styles collection. If you do that, you will change that style. You can edit either of them by right-clicking on it and selecting “Modify”. You will probably see two Page Styles already there in the out-of-the-box configuration, Default and Report. It is the second one from the left, the first one being the Cell Styles button. With your Styles and Formatting window open and anchored to the side of your page, just go to the Page Styles button and click on it. One single sheet may take many physical pages to print, but it is all one sheet and it is all governed by a single Page Style. And don’t be confused by the difference between a sheet in the file and a page when printed. In any given Template you can have different sheets with different Page Styles if you wish, but for any given sheet you can only have one Page Style. Page Styles in LibreOffice Calc set the properties for entire sheets of your workbook file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |