Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openoffice.apache.org
Received-SPF: pass (athena.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
Message-ID: <536974BA.4020404@sbcglobal.net>
Date: Tue, 06 May 2014 16:48:10 -0700
From: Girvin Herr <girvin.herr@sbcglobal.net>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:17.0) Gecko/20131204 Thunderbird/17.0.11
MIME-Version: 1.0
To: users@openoffice.apache.org
Subject: Re: selecting more sheets to print on MS Office spreadsheet
References: 
 <87mwewcr81.fsf@abbey.i-did-not-set--mail-host-address--so-tickle-me>
In-Reply-To: 
 <87mwewcr81.fsf@abbey.i-did-not-set--mail-host-address--so-tickle-me>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Carson,
Have you checked Print Ranges?
Select the sheet that is not printing and then Format -> Print Ranges -> 
Edit
Make sure Print Range is set to "Entire Sheet" for each of your sheets.  
If it is set to "None" then change it to "Entire Sheet". "None" will 
skip printing that sheet.
I am not sure why this does not default to "Entire Sheet" for all 
sheets, but sometimes it doesn't.
HTH.
Girvin Herr


On 05/05/2014 06:03 AM, Carson Chittom wrote:
> I'm using Apache OpenOffice 4.0.1 (on Slackware, if it matters).
>
> I have a Microsoft Office spreadsheet (xlsx) with multiple sheets that
> I'm trying to print.  However, when I look under "Page Break Preview",
> only the first sheet has "Page 1," "Page 2," etc.  And in fact, when I
> hit print, only the first sheet prints, despite "All Sheets" being
> selected.
>
> I looked in the bundled help but didn't see anything in particular
> addressing this.
>
> Can somebody point me in the right direction to get all sheets to print?
>
>
> -------------------------------------------
> List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>


-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org