In fact, whereas some Writer documents can easily make good use of a dozen different page styles, the average Calc spreadsheet can usually get along with modifications to the existing Default and Report styles. Nor does the tab need the Linked with field, because Calc page styles are not hierarchical. Calc applies page styles to each print job in its entirety, so the Next Style field on the Organizer tab is grayed out. These limitations make Calc pages difficult to work with, especially if you approach them with Writer pages in mind.Īs in Writer, the Style and Formatting floating window opens in Calc when you press the F11 key, or select Format > Styles and Formatting, then right-click on an existing style to modify it or create a new one.Īlways remember, though, that Cal page styles are more limited than Writers'. Even then, some of the formatting is only visible as far as the last cell with content.
You have to open File > Page Preview before you can see any of it. If you do want a spreadsheet to fit on a certain page size, you have to careful control the column width and row height, with only File > Page Preview and your grasp of basic arithmetic to guide you.īecause of this situation, an applied Calc page style, unlike a page style in Writer, is not visible on the screen. Nine times out of ten, the attempt would be pointless, since most spreadsheets are never printed. You can set the page size in the style, and what you see on the screen corresponds to the setting, a few editing aids accepted.īy contrast, although you can set the page size for printing, like most spreadsheets, Calc makes no attempt to display the page style on the screen. In Writer, a page style has a direct relation to the dimensions of the physical page.
Think about the differences between the two applications,and the reason is obvious. Nor are they nearly as easy to setup and use. Yet the truth is, page styles offer fewer advantages in Calc than in Writer. Calc page styles have many of the same options as they do in Writer, and, on some tabs for style settings, you might almost believe you were in Writer. If you use page styles in Writer, seeing them in Calc can be deceptive. In Part II, I'll continue by explaining the other tools available for printing in Calc. In this entry, I'll explain how Calc page styles can help with printing spreadsheets. However, offers more help than most spreadsheets with printing, starting with the introduction of page styles. For this reason, printing them can be challenging even to experienced users.
0 kommentar(er)
