RE: PrintInformation
- From: "Yan, Charlene" <Charlene Yan thomsonlearning com>
- To: <gnome-list gnome org>
- Cc: <gnumeric-list gnome org>
- Subject: RE: PrintInformation
- Date: Thu, 19 Jun 2003 17:22:40 -0400
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 &[PAGE]" Right=""/>
<gmr:Footer Left="" Middle="Page &[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]
