[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Re: [xsl] Pagebreaks in Excel-HTML transformer
Subject: Re: [xsl] Pagebreaks in Excel-HTML transformer From: Oleg Konovalov <olegkon@xxxxxxxxx> Date: Mon, 6 Feb 2006 15:00:18 -0500 |
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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Pagebreaks in Excel-HTML , cknell | Thread | Re: [xsl] Pagebreaks in Excel-HTML , Jon Gorman |
RE: RE: [xsl] Parse through a table, Dariusz Borowski | Date | [xsl] Re: Abstracting XSLT to gener, Johnathon Wright |
Month |