RE: display more than thousands rows in Excel

["Monica Li" <lim odshp com>]

I found the reason why it only take less a thousand rows. Because
<xsl:number level="any" from="content"
count="CLMNUMBER"/> return a four digits number with a comma inside, as
'1,000'. Excel doesn't take the comma inside the row number. It works great
after I get rid of the comma.

Just let you know in case someone needs this info.

Monica

-----Original Message-----
From: gnumeric-list-admin gnome org
[mailto:gnumeric-list-admin gnome org]On Behalf Of Monica Li
Sent: Tuesday, May 27, 2003 11:20 AM
To: gnumeric-list gnome org
Subject: display more than thousands rows in Excel


Hi all,

Is anyone knows why nothing displayed in Excel if there are a few hundreds
or thousands rows data. I have a xsp file which gets data from database, and
two different style sheets. one of the style sheet is xls style sheet which
displays data in Excel. If there are only about 20 rows, maybe a little more
rows, it works fine. But not hundreds or thousands rows. Anyone knows why?

The following are part of the stylesheet.

Thanks.
Monica



<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>9</gmr:MaxCol>
                 <gmr:Cols DefaultSizePts="78">
                     <gmr:ColInfo No="0" Unit="78" MarginA="2" MarginB="2"/>
                 </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="2000"/>
                 </gmr:Rows>
                 <gmr:Cells>
                        <xsl:apply-templates/>
                 </gmr:Cells>
        </gmr:Sheet>
     </gmr:Sheets>
    </gmr:Workbook>
  </xsl:template>

   <xsl:template match="CLMNUMBER">
     <gmr:Cell Col="0" ValueType="60">
      <xsl:variable name="rownumber"><xsl:number level="any" from="content"
count="CLMNUMBER"/></xsl:variable>
      <xsl:attribute name="Row">
         <xsl:value-of select="$rownumber"/>
      </xsl:attribute>
      <gmr:Content>
                <xsl:apply-templates/>
        </gmr:Content>
     </gmr:Cell>
  </xsl:template>

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list