Subject: Re: Re: [xsl] Pagebreaks in Excel-HTML transformer From: Oleg Konovalov <olegkon@xxxxxxxxx> Date: Tue, 7 Feb 2006 12:11:17 -0500 |
>> That is very strange, why would you and me get different results ? >That's hard to say. Are you using Excel 2000 or another release? Everybody used to use Excel 2000 (and that's the one in transformer name space), but recently majority of the users moved to WinXP and Office 2003, so I use Excel 2003. Do you think that is a reason we get different results ? But as you said, if you open output of the transformation in IE, you get many (17) blank pages and then all the rest without any pagebreaks. In Cocoon I must put an HTMLserializer after the transformer (with or without mime type), it throws away page-break-after's in either case (I will ask why in Cocoon group - unfortunately people there are very much non-responsive!) > What browser will be able to interpret <x:ExcelWorksheet>? In other words, if you put > <x:ExcelWorksheet> into your HTML, what do you expect a browser to do with it? It > isn't a tag in the HTML world. Both that XML X part (from my previous posting) and template "page-break" are in Excel-HTML transformer (different sections of it). I am not sure how it all works together. Is there way to modify that XML part to put each HTML table (separated by <page-break>) into separate Excel worksheet ? > How about this, could you produce HTML for the browser, and insert a link pointing to a >normal, binary Excel file for your users to download? This would sidestep all the >strangeness you are dealing with. That would probably break all Cocoon rules. As of now, user sees a page with one Product and can click a button "All-Excel" (or "All-Word"). When he clicks on "All-Excel", it starts all that Cocoon pipeline and produces output in Excel form in IE window (I guess, uses Excel plug-in in IE6). Many other pages in my project follow the same methodology, would be difficult from user interface perspective to introduce something new. (and disabling Excel on that page can backfire with my manager ;-( ) Please help. Thank you, Oleg. On 2/6/06, cknell@xxxxxxxxxx <cknell@xxxxxxxxxx> wrote: > > That is very strange, why would you and me get different results ? > That's hard to say. Are you using Excel 2000 or another release? > > > And why would HTMLSerializer with mime type Excel strip out > > page-break-after tags? > That's an issue with the HTMLSerializer, which, I presume, is a part of Cocoon. If my > presumtion is correct, then you'll need to post the question on the Cocoon mailing > list. > > > 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> > What browser will be able to interpret <x:ExcelWorksheet>? In other words, if you put > <x:ExcelWorksheet> into your HTML, what do you expect a browser to do with it? It > isn't a tag in the HTML world. > > How about this, could you produce HTML for the browser, and insert a link pointing to a normal, binary Excel file for your users to download? This would sidestep all the strangeness you are dealing with. > > -- > Charles Knell > cknell@xxxxxxxxxx - email
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: Re: [xsl] Pagebreaks in Excel-H, cknell | Thread | Re: Re: [xsl] Pagebreaks in Excel-H, Jon Gorman |
RE: Re: [xsl] Collation for dotted , cknell | Date | Re: Re: [xsl] Pagebreaks in Excel-H, Jon Gorman |
Month |