cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Asim Thakker" <athak...@datamanagement.com>
Subject hssfserializer gnumeric print information, zoom issue
Date Mon, 13 Jun 2005 17:58:30 GMT
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