hssfserializer gnumeric print information, zoom issue

[Asim Thakker]

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. 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)   That is 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 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 &amp;[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