Hi Asim, You might find more assistance on the Apache POI users list[1].
HTH, -Daniel [1] http://jakarta.apache.org/site/mail2.html#POI On 6/13/05, Asim Thakker <[EMAIL PROTECTED]> wrote: > > > > 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 &[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
