Please.

Simple xml with some russian words and xsl

System locale is Russian
Cocoon 2.0.2  JDK 1.3.1_02  Resin 2.0.5  Windows XP Pro

The same xml works fine as HTML and as PDF

With respect,
Sozonnik Andrew.


-----Original Message-----
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 22, 2002 4:31 PM
To: [EMAIL PROTECTED]
Subject: Re: Anyone generated xml from Cocoon?


Rather than "reject"ing the idea of outputting Excel, how about 
providing a sample?  We can't fix it unless we have your samples.  If 
you use the XML serializer on some troublesome data (as opposed to the 
HSSF Serializer) I can check it out without a database.

Check out a new nightly build for new samples showing how to use the 
Serializer with the SQL Transformer and ESQL.  Furthermore, there is a 
patch in bugzilla that enables using localized number formats, it just 
needs to be tested.  (Its difficult testing these things when the 
default locale happens to be your own)

Thanks,

Andy

Sozonnik Andrew wrote:

>I did.
>It force me to add rows and columns numeration in source xml But I had 
>trouble with national characters in Excel, and so reject the idea of 
>using Excel.
>
>With respect,
>Sozonnik Andrew.
>
>
>-----Original Message-----
>From: Sreenivasan N. [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 22, 2002 12:35 PM
>To: [EMAIL PROTECTED]
>Subject: Anyone generated xml from Cocoon?
>
>
>Hi all
>
>Has anyone generated xml using Cocoon to publish the same in pdf and 
>excel format
>
>Regards
>
>vasan.
>
>
>
>
>
>
>
>"Attitudes are much more important than aptitudes."
>"Nothing is impossible for a willing heart"
>
>Sreenivasan N.
>Sony SARD
>Ext 232
>
>Email. [EMAIL PROTECTED]
>Per: [EMAIL PROTECTED]
>
>
>---------------------------------------------------------------------
>Please check that your question has not already been answered in the 
>FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
>
>---------------------------------------------------------------------
>Please check that your question has not already been answered in the 
>FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>




---------------------------------------------------------------------
Please check that your question has not already been answered in the FAQ
before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

<?xml version="1.0" encoding="UTF-8"?>
<data xmlns:xsp="http://apache.org/xsp"; xmlns:xspdoc="http://apache.org/cocoon/XSPDoc/v1"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; xmlns:xsp-request="http://apache.org/xsp/request/2.0"; xmlns:cinclude="http://apache.org/cocoon/include/1.0";>

<paper width="210" height="297">
</paper>

<headers>
	<header colnumber="0">Регион</header>
	<header colnumber="1">Город</header>
	<header colnumber="2">Станция</header>
        <header colnumber="3">(З)Объект</header>
	<header colnumber="4">(З)Частотный план</header>
</headers>

<rowset>

<row attrib="normal" rownumber="0">
<col colnumber="0" rownumber="0">Central office</col>
<col colnumber="1" rownumber="0">Chernigiv</col>
<col colnumber="2" rownumber="0">CHG006</col>
<col colnumber="3" rownumber="0">05/02/2002</col>
<col colnumber="4" rownumber="0">22/02/2002</col> 
</row>

<row attrib="total" rownumber="1">
<col colnumber="0" rownumber="1">Central office</col>
<col colnumber="1" rownumber="1">TOTAL</col>
<col colnumber="2" rownumber="1">1</col>
<col colnumber="3" rownumber="1">1</col>
<col colnumber="4" rownumber="1">1</col> 
</row>

<row attrib="total" rownumber="2">
<col colnumber="0" rownumber="2"></col>
<col colnumber="1" rownumber="2">GRAND TOTAL</col>
<col colnumber="2" rownumber="2">1</col>
<col colnumber="3" rownumber="2">1</col>
<col colnumber="4" rownumber="2">1</col> 
</row>

</rowset>

<rowset_num rows="3" cols="5">
</rowset_num>
</data>
<?xml version="1.0"  encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                              xmlns:gmr="http://www.gnome.org/gnumeric/v7";>

  <xsl:param name="view-source"/>

  <xsl:template match="data">
   <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
     <gmr:Sheets>
         <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false" HideColHeader="false" HideRowHeader="false" DisplayOutlines="true" OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
	         <gmr:Name>Sheet 0</gmr:Name>
        	 <gmr:MaxCol>2</gmr:MaxCol>
	         <gmr:Cols DefaultSizePts="48">
                     <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2" Count="7"/>
                 </gmr:Cols>
     		 <gmr:Rows DefaultSizePts="12.8">
       			<gmr:RowInfo No="0" Unit="12.8" MarginA="0" MarginB="0" Count="9"/>
       			<gmr:RowInfo No="10" Unit="12.8" MarginA="1" MarginB="0" Count="24"/>
     		 </gmr:Rows>

<gmr:Styles>
        <gmr:StyleRegion startCol="0" startRow="0" >
 <xsl:attribute name="endCol">
         <xsl:value-of select="(//rowset_num/@cols)-1"/>
	</xsl:attribute>
	<xsl:attribute name="endRow">
         <xsl:value-of select="(//rowset_num/@rows)-1"/>
	</xsl:attribute> 
          <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Fore="FFFF:0:0" Back="FFFF:0:FFFF" PatternColor="0:FFFF:0" Format="General" >
	

            <gmr:Font Unit="9" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
</gmr:Styles>

 		 <gmr:Cells>
     			<xsl:apply-templates/>
                 </gmr:Cells>
     	</gmr:Sheet>
     </gmr:Sheets>
    </gmr:Workbook>
  </xsl:template>

   
  <xsl:template match="col">
     <gmr:Cell ValueType="60">
      
      <xsl:attribute name="Row">
         <xsl:value-of select="(@rownumber+1)"/>
      </xsl:attribute>

      <xsl:attribute name="Col">
         <xsl:value-of select="@colnumber"/>
      </xsl:attribute>



       <gmr:Content>
	  <xsl:value-of select="."/> 
 </gmr:Content>

     </gmr:Cell>
    
  </xsl:template>


<xsl:template match="header">
     <gmr:Cell ValueType="60">
      
      <xsl:attribute name="Row">
      <xsl:text>0</xsl:text>
      </xsl:attribute>

      <xsl:attribute name="Col">
         <xsl:value-of select="@colnumber"/>
      </xsl:attribute>



       <gmr:Content>
		  <xsl:value-of select="."/> 
	</gmr:Content>

     </gmr:Cell>
    
  </xsl:template>


  </xsl:stylesheet>

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to