[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Pagebreaks in Excel-HTML transformer

Subject: Re: Pagebreaks in Excel-HTML transformer
From: Oleg Konovalov <olegkon@xxxxxxxxx>
Date: Mon, 6 Feb 2006 15:00:18 -0500
x pagebreaks
Charles,

>I was able to open the file normally with Excel 2000.
>All the pages broke where you would expect them to break.
That is very strange, why would you and me get different results ?
And why would HTMLSerializer with mime type Excel strip out
page-break-after tags?

As I mentioned, another option would be to put every table into it's own
Excel
worksheet. I guess, that is to transform <page-break> tag into
<x:ExcelWorksheet>
Could you please advise me how to do it.
Here is an existing part of Excel-HTML transformer (you probably still
have the full file)

                             <xml>
				 <x:ExcelWorkbook>
					<x:ExcelWorksheets>
					 <x:ExcelWorksheet>
						<x:Name> discussionsheet</x:Name>
						<x:WorksheetOptions>
						 <x:Print>
							<x:ValidPrinterInfo/>
							<x:Scale>80</x:Scale>
							<x:HorizontalResolution>600</x:HorizontalResolution>
							<x:VerticalResolution>600</x:VerticalResolution>
						 </x:Print>
						 <x:PageBreakZoom>20</x:PageBreakZoom><!-- was 60 -->
						 <x:Selected/>
						 <x:DoNotDisplayGridlines/>
						 <x:Panes>
							<x:Pane>
							 <x:Number>3</x:Number>
							 <x:ActiveRow>1</x:ActiveRow>
							</x:Pane>
						 </x:Panes>
						 <x:ProtectContents>False</x:ProtectContents>
						 <x:ProtectObjects>False</x:ProtectObjects>
						 <x:ProtectScenarios>False</x:ProtectScenarios>
						</x:WorksheetOptions>
						<x:PageBreaks>
						 <x:RowBreaks>
							 <xsl:for-each select="/document/helper-info/row-breaks/row">
								<x:RowBreak>
									<x:Row><xsl:value-of select="."/></x:Row>
								</x:RowBreak>
							</xsl:for-each>
						 </x:RowBreaks>
						</x:PageBreaks>
					 </x:ExcelWorksheet>
					</x:ExcelWorksheets>
					<x:WindowHeight>12270</x:WindowHeight>
					<x:WindowWidth>19755</x:WindowWidth>
					<x:WindowTopX>210</x:WindowTopX>
					<x:WindowTopY>90</x:WindowTopY>
					<x:ProtectStructure>False</x:ProtectStructure>
					<x:ProtectWindows>False</x:ProtectWindows>
				 </x:ExcelWorkbook>
				</xml>

Thank you in advance,
Oleg.

On 2/3/06, cknell@xxxxxxxxxx <cknell@xxxxxxxxxx> wrote:
> > If I run it through XMLSpy2006, I do get page-break-after properly
inserted,
> > but I couldn't open it normally with either Excel (was all screwed up)
> > or IE6 (looks like 1 long page, if I do Print Preview, it creates 10 blank
pages
> > and then puts all without any page breaks).
> >
> > In order to open it in IE with Excel plug-in,
> > we put the HTML Serializer with the mime type "application/ms-excel"
> >
> > I just checked, that serializer removes all "page-break-after"
> > and inserts "page-break-before" where it pleases (e.g. incorrectly)
> > What should I do ?
>
> I was able to open the file normally with Excel 2000. All the pages broke
where you would expect them to break.
>
> I observed the same blank pages problem with Netscape Mozilla, Firefox, and
IE.
>
> At this point your problem is no longer with XSLT, but instead with how the
browsers or the HTML serializer handle your HTML.
>
> I don't claim any special knowledge in these areas and you have moved beyond
XSL matters. You will have to take up these issues with other mailing lists or
paid support organizations. If you learn why the paging works the way it does
and how the HTML should be formed, we can help you with the XSLT. Until we
know what output you want, there's not much more we can offer.

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.