[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Pagebreaks in Excel-HTML transformer
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.
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|