Re: Re: [xsl] Pagebreaks in Excel-HTML transformer

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