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(_at_)onebox(_dot_)com <cknell(_at_)onebox(_dot_)com> 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.
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--