RE: PrintInformation

From: "Yan, Charlene" <Charlene Yan thomsonlearning com>
To: <gnome-list gnome org>
Cc: <gnumeric-list gnome org>
Subject: RE: PrintInformation
Date: Thu Jun 19 17:23:07 2003
> 	All,
> 
> 	I'm trying to set the header, footer and print-orientation information.  Somehow, the result Excel spreadsheet does not take any of these.  Does anyone has this experience?  Here is my stylesheet:
> 
> 	<?xml version="1.0"?>
> 
> 	<!-- CVS $Id: page2xls.xsl,v 1.2 2003/05/07 04:57:13 vgritsenko Exp $ -->
> 
> 	<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> 	                              xmlns:sql="http://apache.org/cocoon/SQL/2.0";
> 	                             xmlns:gmr="http://www.gnome.org/gnumeric/v7"; >
> 
> 	  <xsl:param name="view-source"/>
> 
> 	  <xsl:template match="solution">
> 	   <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
> 	     <gmr:Attributes>
> 	    <gmr:Attribute>
> 	      <gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
> 	      <gmr:type>4</gmr:type>
> 	      <gmr:value>TRUE</gmr:value>
> 	    </gmr:Attribute>
> 	    <gmr:Attribute>
> 	      <gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
> 	      <gmr:type>4</gmr:type>
> 	      <gmr:value>TRUE</gmr:value>
> 	    </gmr:Attribute>
> 	    <gmr:Attribute>
> 	      <gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
> 	      <gmr:type>4</gmr:type>
> 	      <gmr:value>TRUE</gmr:value>
> 	    </gmr:Attribute>
> 	  </gmr:Attributes>
> 	  
> 	  <gmr:Summary>
> 	    <gmr:Item>
> 	      <gmr:name>application</gmr:name>
> 	      <gmr:val-string>gnumeric</gmr:val-string>
> 	    </gmr:Item>
> 	    <gmr:Item>
> 	      <gmr:name>author</gmr:name>
> 	      <gmr:val-string>David Gilbert</gmr:val-string>
> 	    </gmr:Item>
> 	  </gmr:Summary>
> 	  
> 	  <gmr:SheetNameIndex>
> 	    <gmr:SheetName>Sheet1</gmr:SheetName>
> 	  </gmr:SheetNameIndex>
> 	  
> 	  <gmr:Names/>
> 	  
> 	  <gmr:Geometry Width="734" Height="422"/>
> 	    <gmr:Sheets>
> 	      <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
> 	HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
> 	OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
> 	        <gmr:Name><xsl:value-of select="name"/></gmr:Name>
> 	        <gmr:MaxCol>-1</gmr:MaxCol>
> 	        <gmr:MaxRow>-1</gmr:MaxRow>
> 	        <gmr:Zoom>1.000000</gmr:Zoom>
> 	        <gmr:Names/>
> 	        <gmr:PrintInformation>
> 	          <gmr:Margins>
> 	            <gmr:top Points="28.3" PrefUnit="cm"/>
> 	            <gmr:bottom Points="28.3" PrefUnit="cm"/>
> 	            <gmr:left Points="0" PrefUnit="cm"/>
> 	            <gmr:right Points="0" PrefUnit="cm"/>
> 	            <gmr:header Points="0" PrefUnit="cm"/>
> 	            <gmr:footer Points="0" PrefUnit="cm"/>
> 	          </gmr:Margins>
> 	          <gmr:vcenter value="0"/>
> 	          <gmr:hcenter value="0"/>
> 	          <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>r_then_d</gmr:order>
> 	          <gmr:orientation>landscape</gmr:orientation>
> 	          <gmr:Header Left="" Middle="Page &amp;[PAGE]"  Right=""/>
> 	          <gmr:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
> 	          <gmr:paper>A4</gmr:paper>
> 	        </gmr:PrintInformation>    
> 	      <gmr:Styles>   
> 	        
> 	        <gmr:StyleRegion startRow="19" endRow="19" startCol="0" endCol="0">
> 	          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
> 	                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
> 	            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
> 	            <gmr:StyleBorder>
> 	              <gmr:Top Style="0"/>
> 	              <gmr:Bottom Style="1"/>
> 	              <gmr:Left Style="0"/>
> 	              <gmr:Right Style="0"/>> 
> 	              <gmr:Diagonal Style="0"/>
> 	              <gmr:Rev-Diagonal Style="0"/>
> 	            </gmr:StyleBorder>
> 	          </gmr:Style>
> 	        </gmr:StyleRegion>
> 	        
> 	            
> 	      </gmr:Styles>
> 	      <gmr:Cols>
> 	        <gmr:ColInfo No="0" Unit="52"/>
> 	        <gmr:ColInfo No="1" Unit="42"/>
> 	        <gmr:ColInfo No="2" Unit="45" Count="2"/>
> 	        <gmr:ColInfo No="4" Unit="42"/>
> 	        <gmr:ColInfo No="5" Unit="37"/>
> 	        <gmr:ColInfo No="6" Unit="52"/>
> 	        <gmr:ColInfo No="7" Unit="37"/>
> 	        <gmr:ColInfo No="8" Unit="41"/>
> 	        <gmr:ColInfo No="9" Unit="59"/>
> 	        <gmr:ColInfo No="10" Unit="42"/>
> 	        <gmr:ColInfo No="11" Unit="45"/>
> 	        <gmr:ColInfo No="12" Unit="27"/>
> 	        <gmr:ColInfo No="13" Unit="42"/>
> 	        <gmr:ColInfo No="14" Unit="36"/>
> 	        <gmr:ColInfo No="15" Unit="24"/>
> 	        <gmr:ColInfo No="16" Unit="35"/>
> 	        <gmr:ColInfo No="17" Unit="25"/>
> 	      </gmr:Cols>
> 	      <gmr:Rows>
> 	        <gmr:RowInfo No="0" Unit="13.5"/>
> 	        <gmr:RowInfo No="1" Unit="13.5"/>
> 	        <gmr:RowInfo No="2" Unit="13.5"/>
> 	        <gmr:RowInfo No="3" Unit="13.5"/>
> 	        <gmr:RowInfo No="4" Unit="13.5"/>
> 	        <gmr:RowInfo No="5" Unit="13.5"/>
> 	        <gmr:RowInfo No="6" Unit="13.5"/>
> 	        <gmr:RowInfo No="7" Unit="13.5"/>
> 	      </gmr:Rows>
> 	      <gmr:Cells>      
> 	      <gmr:Cell Col="6l="14" Row="26" ValueType="60">
> 	      Locat
> 	     </gmr:Cell>
> 	     <gmr:Cell Col="15" Row="26" ValueType="60">
> 	      ion
> 	     </gmr:Cell>
> 	     <gmr:Cell Col="16" Row="26" ValueType="60">
> 	      Price
> 	     </gmr:Cell>   
> 	     <gmr:Cell Col="3"  Row="31" ValueType="60">
> 	      <xsl:attribute name="Row">
> 	         <xsl:value-of select="32 + count(//buProdId)"/>
> 	      </xsl:attribute>     
> 	       IF XTREME INSTALLATION IS REQUIRED, CHECK THE REQUIRED, SHADED, FORMAT BOX ABOVE
> 	     </gmr:Cell>
> 	     <gmr:Cell Col="0"  Row="31" ValueType="60">
> 	      <xsl:attribute name="Row">
> 	         <xsl:value-of select="28 + count(//buProdId)"/>
> 	      </xsl:attribute>     
> 	       Comments
> 	     </gmr:Cell>
> 	     
> 	     
> 	     	  <xsl:apply-templates/>
> 	      </gmr:Cells>      
> 	      </gmr:Sheet>
> 	     </gmr:Sheets>
> 	    </gmr:Workbook>
> 	  </xsl:template>
> 
> 	  <xsl:template match="content">
> 	      
> 	      <xsl:apply-templates/>
> 	  </xsl:template>
> 
> 	  <xsl:template match="tlnCustomer">
> 	     <gmr:Cell Col="1" Row="6" ValueType="60">
> 	      <xsl:value-of select="name"/>
> 	     </gmr:Cell>  
> 	     <xsl:if test="buAccountId!=''">
> 	      <gmr:Cell Col="1" Row="7" ValueType="60">
> 	        <xsl:value-of select="buAccountId"/>
> 	      </gmr:Cell>
> 	     </xsl:if> 
> 	     <xsl:apply-templates/>
> 	  </xsl:template>
> 	  
> 	  <xsl:template match="tlnCustContacts">
> 	       
> 	     <xsl:apply-templates/>
> 	  </xsl:template>
> 
> 	  <xsl:template match="custContact">
> 	       
> 	     <xsl:if test="contactTypeId='CLO'">
> 	      <xsl:if test="officePhone!=''">
> 	      <gmr:Cell Col="1" Row="15" ValueType="60">
> 	        <xsl:value-of select="officePhone"/>
> 	      </gmr:Cell>
> 	      </xsl:if>
> 	      <xsl:if test="fax!=''">
> 	      <gmr:Cell Col="1" Row="16" ValueType="60">
> 	        <xsl:value-of select="fax"/>
> 	      </gmr:Cell>
> 	      </xsl:if>
> 	      <xsl:if test="email!=''">
> 	      <gmr:Cell Col="1" Row="17" ValueType="60">
> 	        <xsl:value-of select="email"/>
> 	      </gmr:Cell>
> 	      </xsl:if>
> 	     </xsl:if> 
> 
> 	  </xsl:template>
> 
> 	  <xsl:template match="buProdId">          
> 	     <gmr:Cell Col="0"  Row="27" ValueType="60">
> 	      <xsl:variable name="rownumber"><xsl:number level="any" count="//buProdId"/></xsl:variable>
> 	      <xsl:attribute name="Row">
> 	         <xsl:value-of select="26 + $rownumber"/>
> 	      </xsl:attribute>> 
> 	       1
> 	     </gmr:Cell>
> 	     <gmr:Cell Col="1late>
> 	  
> 
> 	</xsl:stylesheet>
[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]