Home > Open Office > OpenOffice.org Calc - Worksheet Orientation

OpenOffice.org Calc - Worksheet Orientation


It seems that the whole presentation work has been done automatically! :-) You only have to click on the format's name tabs to select what you prefer! Selected sheets - Only the selected sheets will be printed. The first tab has a few pages of sales data; the second sheet, with different and less data, is more of a summary set of data. Now make another style, the same way. check over here

Now I know. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Browse other questions tagged printing spreadsheet libreoffice-calc openoffice-calc landscape or ask your own question. Pages - Enter the pages to be printed. https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Printing/How_do_I_get_Sheet1_to_print_as_portrait_and_Sheet2_to_print_as_landscape%3F

Open Office Spreadsheet Fit To Page

up vote 1 down vote favorite I have document with two sheets sheet1 and sheet2 and i want set orientation of sheet1 to portrait and orientation of sheet2 to landscape. Join our site today to ask your question. The next page break appears automatically when the text flows to the next page, which is sometimes called a "soft page break". Click the Paragraph Styles icon.

The current page style is listed in the Status Bar at the lower window border. On the Organizer tab page, type a name for the page style in the Name box, for example "My Landscape". You'll find many friends here. Openoffice Calc Set Print Area Am I missing something simple and ovious or what?

If a print range is defined, the printing area will show up with a white background with a blue outline at the page boundary. In the Breaks area, activate Enable and With Page Style. Step 1: Create page styles Choose Format > Styles and Formatting. https://wiki.openoffice.org/wiki/Documentation/FAQ/Writer/FormattingPagesAndDocuments/How_do_I_change_the_page_layout_from_Portrait_to_Landscape_for_an_entire_document%3F Sometimes the answer is in plain sight.

Keep up the good work! :) Posted by: LentoMan | November 25, 2008 at 02:24 AM Thank you very much! Open Office Landscape One Page Only Thanks again PhiilFred PhillyFred, Aug 3, 2009 #3 edhicks Joined: Jun 30, 2008 Messages: 248 PhillFred Glad it worked. Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Click on the tab for the first sheet, and in the Styles and Formatting window, double-click the page style you want to apply.

Open Office Spreadsheet Landscape

By pressing Ctrl while clicking a sheet name you can change this selection. see this A visual of the table alignment settings will show in the small graphic on the same page as these parameters. Open Office Spreadsheet Fit To Page Click here to join today! Openoffice Print Landscape It was suggested to me to download OpenOffice.org - Have always been a huge fan of Excel and dove right into Calc.

more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science http://gamesversion.com/open-office/openoffice-3-4-is-now-out.php Loading... Now you have defined a proper page style with the name "My Landscape". Select the sheet that should have landscape orientation, and double-click on the new page style entry in the "Styles and Formatting" window to apply it to the current sheet. Openoffice Calc Print Landscape

Contents 1 Previewing the print area 2 Formatting the page 3 Adjusting the page breaks 4 Setting the area to be printed 5 Adjusting the printout to fit onto one a Right-click the name of the paragraph style you want to modify and choose Modify. You will see the Print dialog. this content Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the

Post again when next question arises edhicks, Aug 3, 2009 #4 This thread has been Locked and is not open to further replies. Openoffice Page Size But....what if you've got content in a couple different sheets of your spreadsheet, or more. Here's the layout for one of the pages in sheet1.

SharePoint online extranet Quantum Based AI getting around Isaac Asimov's "Three Laws of Robotics" Did Buzz Aldrin take communion of bread and wine on his first landing on the moon?

It's just below the AutoFormat icon. The “First Page” style is an example. In the Page Style window, give the new page style a descriptive name, such as Landscape Page Click on the Page tab and change the Orientation to Landscape Click OK to Open Office Calc Select Format - Print Ranges - Add from the main menu Repeat the above steps for each sheet of the file to be printed.

To apply the new style, double-click the "My Landscape" page style in the Styles and Formatting window. Advertisement Recent Posts Windows restarts after... Let's say that the data in the first sheet is pretty wide so you'd like a landscape layout, and the data in the second sheet is narrow and a different type have a peek at these guys Click the Page tab.

Step 2: Apply a different page style to each sheet This is pretty simple. Then, give it a name for the new style in the Organizer tab and click on OK to have the new style displayed in the Stylist window. Privacy policy About Apache OpenOffice Wiki Disclaimers User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives Skip to content Advanced search Board index Change font size FAQ Click OK.

Set attributes. (Here's how you'd change content in the header.) Click OK. A gray 'Page N', where 'N' is the page sequence number for the sheet, will appear in the middle of the print area. The lower and upper borders of the page style range are defined by "page breaks with style". If you are unsure about the page style concept, please read the section at the end of this page.

Use thereof is explained in our trademark policy unless otherwise noted. How do I print my spreadsheets? All rights reserved. The displayed page should now exhibit the new page style.

PhillyFred, Aug 3, 2009 #1 edhicks Joined: Jun 30, 2008 Messages: 248 Phillyfred Welcome!!! Efficient counting mathematica's equivalent of python list functionnality Why is a biography of a comedian titled "Man on the Moon"? For your question, try this Open Calc Under File select page preview On the preview select format page choose landscape or portrait as desired. Click OK.

It's self-explanatory, except for the section, Scale, which is a bit obscure: 'Reduce/enlarge printout' allows you to decrease or increase the size of the print image of your sheet 'Fit printout How to do this in OpenOffice.org Calc?