Return-Path: 
 <cocoon-users-return-47737-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 66153 invoked by uid 500); 13 Mar 2003 12:49:31 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 66140 invoked from network); 13 Mar 2003 12:49:31 -0000
Received: from unknown (HELO ns.mobicomk.donpac.ru) (217.106.95.130)
  by daedalus.apache.org with SMTP; 13 Mar 2003 12:49:31 -0000
Received: from support.lan.mobicomk.ru ([10.10.5.100])
	by ns.mobicomk.donpac.ru (8.11.6/8.11.6) with SMTP id h2DCnEv12740
	for <cocoon-users@xml.apache.org>; Thu, 13 Mar 2003 15:49:14 +0300
Date: Thu, 13 Mar 2003 15:59:28 +0300
From: Yury Mikhienko <yuryx@mobicomk.donpac.ru>
To: cocoon-users@xml.apache.org
Subject: support non-english characters in HSSFSerializer
Message-Id: <20030313155928.20b3c949.yuryx@mobicomk.donpac.ru>
Organization: Mobicom-Kavkaz
X-Mailer: Sylpheed version 0.8.8 (GTK+ 1.2.10; i586-alt-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: 8bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi all!

I am using cocoon v.2.0.4 and trying to create an ms-exel document using non-english characters but HSSFSerializer 
does not work properly (as in cocoon v2.0.2). In created document I get the corrupted symbols instead of russian text :((

in sitemap I set the following:

    <map:serializers default="html">
     <map:serializer name="xls" src="org.apache.cocoon.serialization.HSSFSerializer" mime-type="application/vnd.ms-excel">
       <encoding>UTF-8</encoding>
     </map:serializer>
    </map:serializers>

if I set the encoding to KOI8-R, I get some problems.

my page2xls.xsl:

<?xml version="1.0" encoding="KOI8-R"?>

<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="page">
   <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><xsl:value-of select="title"/></gmr:Name>
                 <gmr:MaxCol>2</gmr:MaxCol>
                 <gmr:Cols DefaultSizePts="100">
                     <gmr:ColInfo No="0" Unit="100" 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:Cells>
                        <xsl:apply-templates select="content"/>
                 </gmr:Cells>
        </gmr:Sheet>
     </gmr:Sheets>
    </gmr:Workbook>
  </xsl:template>

  <xsl:template match="content">
     <gmr:Cell Col="0" ValueType="60" Row="0">
       <gmr:Content>
                <xsl:text>����</xsl:text>
        </gmr:Content>
     </gmr:Cell>
  </xsl:template>
</xsl:stylesheet>

Where I'm wrong? Can anyone help me?
Thanks for advice.

-- 
 
Best regards,
Yury Mikhienko.
IT engineer, ZAO "Mobicom-Kavkaz"

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org