[Solved] Spreadsheet question

Discuss the spreadsheet application

[Solved] Spreadsheet question

Postby dennispfaff » Sun Oct 22, 2017 10:18 pm

I created a document on the Spreadsheet. Is there any way to hide the "sheet 1" at the top, and "page 1" at the bottom of the document?
Last edited by Hagar Delest on Sun Nov 12, 2017 12:31 am, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1.1
Windows 7
dennispfaff
 
Posts: 7
Joined: Sun Oct 22, 2017 6:48 pm

Re: Spreadsheet question

Postby RusselB » Sun Oct 22, 2017 10:28 pm

I'm going to guess that you are referring to that information in regards to a printout, as I don't recall seeing it anywhere else.
If so
1) Go to File -> Page Preview (or the Page Preview icon on the Standard Toolbar)
2) On the Preview window, click Format Page
3) Select the Header tab, and uncheck Header On (for the sheet 1)
4) Repeat step 3, but for the Footer tab (for the page 1)
NB: If you want a header and/or footer, but not the defaults, then you can change what is displayed and where (left/centre/right) on the same appropriate tabs, but you'll need to leave the Header On and/or Footer On checkboxes marked
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4117
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Spreadsheet question

Postby dennispfaff » Sun Oct 22, 2017 10:32 pm

Thanks for that info!
Dennis
OpenOffice 4.1.1
Windows 7
dennispfaff
 
Posts: 7
Joined: Sun Oct 22, 2017 6:48 pm

Re: Spreadsheet question

Postby dennispfaff » Mon Oct 23, 2017 5:06 am

It worked perfectly, thanks again.
OpenOffice 4.1.1
Windows 7
dennispfaff
 
Posts: 7
Joined: Sun Oct 22, 2017 6:48 pm

Re: Spreadsheet question

Postby Zizi64 » Mon Oct 23, 2017 8:35 am

1) Go to File -> Page Preview (or the Page Preview icon on the Standard Toolbar)
2) On the Preview window, click Format Page
3) Select the Header tab, and uncheck Header On (for the sheet 1)
4) Repeat step 3, but for the Footer tab (for the page 1)
NB: If you want a header and/or footer, but not the defaults, then you can change what is displayed and where (left/centre/right) on the same appropriate tabs, but you'll need to leave the Header On and/or Footer On checkboxes marked


If you did it, that means: You have edited the Default Page Style (or the actually applied one).

You can create and apply different Page Styles for each of the Sheets if you need it. You can vari the orientation of the sheets (Portrait/Landscape), the Header/Footer content, etc...) in one Calc DOCUMENT...

The "Styles" is the most valuable feature of the Apache OpenOffice and the LibreOffice . Use them.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6006
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Spreadsheet question

Postby dennispfaff » Tue Oct 24, 2017 6:04 pm

I tried to paste a document to "sheet 2" to tweak my original, but it did not have the same margins as the original, and apparently it will not allow me to make changes to sheet 2?
Is there a way to delete sheet 2 completely, and on another spreadsheet document I can't find out how to delete it completely?
Dennis
OpenOffice 4.1.1
Windows 7
dennispfaff
 
Posts: 7
Joined: Sun Oct 22, 2017 6:48 pm

Re: Spreadsheet question

Postby Zizi64 » Tue Oct 24, 2017 6:31 pm

To delete all of the contents:
Ctrl-A - DEL

To delete the sheet:
Right click on the TAB of the sheet - Delete sheet (from the floating menu)


As I wrote: You can set different margins to the Sheets, when you apply different Page Styles to the sheets.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6006
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Spreadsheet question

Postby dennispfaff » Tue Oct 24, 2017 6:43 pm

Thanks again. I have much to learn.
Dennis
OpenOffice 4.1.1
Windows 7
dennispfaff
 
Posts: 7
Joined: Sun Oct 22, 2017 6:48 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot], robleyd and 24 guests