[Discuss] Spread Sheet printing question

[Jerry Feldman]

Thanks Bill,
To suppress the sheet# and page#, js to turn header/footer off.
And the instructions below work on LibreOffice (and probably on Excell too).


On 06/04/2013 10:01 AM, Bill Horne wrote:
> On 6/4/2013 9:40 AM, Jerry Feldman wrote:
>> I have been using spreadsheets since I bought my first copy of 
>> VisiCalc from Dan Bricklin at the New England Appletree meeting in 1978.
>> I have a spreadsheet (Libre Office Calc) that takes up 2 pages. The 
>> main question is how do I get Calc to print the column headings on 
>> each page.
>>
>> The other 2 minor questions are how can I suppress the Sheet number 
>> that appears on the top of the page as well as the page number.
>>
>> When I print, I select the data I want to print, and print selection.
>>
>
> Assuming it's the same as Open Office, here's a snippet from the help 
> file:
>
> If you have a sheet that is so large that it will be printed multiple 
> pages, you can set up rows or columns to repeat on each printed page.
>
> As an example, If you want to print the top two rows of the sheet as 
> well as the first column (A)on all pages, do the following:
>
> 1.
>
>    Choose *Format - Print Ranges - Edit*. The *Edit Print Ranges*
>    dialog appears.
>
> 2.
>
>    Click the icon at the far right of the *Rows to repeat* area.
>
>    The dialog shrinks so that you can see more of the sheet.
>
> 3.
>
>    Select the first two rows and, for this example, click cell A1 and
>    drag to A2.
>
>    In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows
>    to repeat.
>
> 4.
>
>    Click the icon at the far right of the *Rows to repeat* area. The
>    dialog is restored again.
>
> 5.
>
>    If you also want column A as a column to repeat, click the icon at
>    the far right of the *Columns to repeat* area.
>
> 6.
>
>    Click column A (not in the column header).
>
> 7.
>
>    Click the icon again at the far right of the *Columns to repeat* area.
>
>
> For the "Sheet number", choose Format-Page-Header, and click the 
> "Edit" box.
>
> HTH.
>
> Bill, who amazed the forman at Bowdoin Toll by putting printer 
> formatting codes into Visicalc cells
>


-- 
Jerry Feldman <gaf at blu.org>
Boston Linux and Unix
PGP key id:3BC1EB90
PGP Key fingerprint: 49E2 C52A FC5A A31F 8D66  C0AF 7CEA 30FC 3BC1 EB90