[Guys - not sure if I'm off-topic here? Should I be discussing Cocoon
HSSFSerializer on this list?]
Asim,
I haven't done much with the actual POI API so can't tell you how to
make this exact change.
If you're lucky it might be simple. You might just have to change the
EPZoom class so that it makes the right POI call when it sees a gmr:Zoom
element.
To add a new element type (gmr:Scale), you'll have to create a new class
org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPS
cale
You'll have to add a line to
org.apache.cocoon.components.elementprocessor.impl.poi.hssf.HSSFElementP
rocessorFactory
which references your new class.
Looking at the code in these classes/packages would be the best starting
point.
Thanks
Iain
-----Original Message-----
From: Asim Thakker [mailto:[EMAIL PROTECTED]
Sent: 14 June 2005 15:18
To: 'POI Users List'
Subject: RE: hssfserializer gnumeric print information, zoom issue
Iain,
Thank you for your help. I am new to this community and would like to
plunge into the development side too.
Since you have done modifications yourself, How difficult do you think
it would be for me to modify the source for making zoom work with the
hssfSerializer? Any good starting point?
Thanks.
Asim Thakker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 4:26 AM
To: [email protected]
Subject: RE: hssfserializer gnumeric print information, zoom issue
Asim
Haven't used these tags myself, but I've used and modified the
HSSFSerializer quite a bit.
Zoom is implemented but unused, comment 'This element is not used in
HSSFSerializer 1.0'.
http://www.docjar.com/docs/api/org/apache/cocoon/components/elementproce
ssor/impl/poi/hssf/elements/EPZoom.html
Scale isn't implemented at all.
This is with cocoon 2.1.6.
-----Original Message-----
From: Asim Thakker [mailto:[EMAIL PROTECTED]
Sent: 13 June 2005 21:46
To: [email protected]
Subject: hssfserializer gnumeric print information, zoom issue
Importance: High
Hey,
I am using cocoon 2.1 to get an xml file, transform it using xslt (using
the recommended gnumeric format) and then serialize the output with
HSSFSerializer (One provided with cocoon 2.1). Everything works well,
data is shown on the excel sheet but there is problem using some of the
gnumeric tags such as <gmr:Zoom>0.6</gmr:Zoom>, <gmr:Scale
type="percentage" percentage="36"/>. These tags seem to have no effect
on the excel sheet generated and returned to the browser (I.E 6.0)
To verify this, after the excel file is displayed in the browser (I.E
6.0), I click page setup and then the page tab to see if the "Adjust to:
36 % normal size" is in effect. But it just keeps the default "Adjust
to: 100 % normal size"
Has anybody faced these kinds of problems or know if HSSFSerialzer that
cocoon uses, does implement these gnumeric values?
--sample block (from the xsl file) included below--
<gmr:Sheet HideGrid="true">
.
<gmr:Zoom>0.6</gmr:Zoom>
<gmr:PrintInformation>
<gmr:Margins>
<gmr:top Points="0.3" PrefUnit="in"/>
<gmr:bottom Points="0.0" PrefUnit="in"/>
<gmr:left Points="0" PrefUnit="Pt"/>
<gmr:right Points="0" PrefUnit="Pt"/>
<gmr:header Points="0.000000" PrefUnit="Pt"/>
<gmr:footer Points="0.000000" PrefUnit="Pt"/>
</gmr:Margins>
<gmr:Scale type="percentage" percentage="36"/>
<gmr:vcenter value="1"/>
<gmr:hcenter value="1"/>
<gmr:grid value="0"/>
<gmr:even_if_only_styles value="0"/>
<gmr:monochrome value="0"/>
<gmr:draft value="0"/>
<gmr:titles value="0"/>
<gmr:repeat_top value=""/>
<gmr:repeat_left value=""/>
<gmr:order>d_then_r</gmr:order>
<gmr:orientation>landscape</gmr:orientation>
<gmr:Header Left="" Middle="Matrix" Right=""/>
<gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/>
<gmr:paper>Legal</gmr:paper>
</gmr:PrintInformation>
.
</gmr:Sheet>
All of the above values and changes to it have an effect EXCEPT for
<gmr:Zoom>0.6</gmr:Zoom> and <gmr:Scale type="percentage"
percentage="36"/>
In fact even attribute HideGrid="true" in sheet object doesn't have an
effect.
Thank you for your time. Any reply or even references will be greatly
appreciated.
Asim Thakker
------------------------------------------------------------------------
For more information about Barclays Capital, please
visit our web site at http://www.barcap.com.
Internet communications are not secure and therefore the Barclays
Group does not accept legal responsibility for the contents of this
message. Although the Barclays Group operates anti-virus programmes,
it does not accept responsibility for any damage whatsoever that is
caused by viruses being passed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of the
Barclays Group. Replies to this email may be monitored by the Barclays
Group for operational or business reasons.
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
.
