cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel McOrmond <dmcorm...@gmail.com>
Subject Re: hssfserializer gnumeric print information, zoom issue
Date Mon, 13 Jun 2005 18:38:05 GMT
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 <athakker@datamanagement.com> 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 &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
Mime
View raw message