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/
