It seems that my date formatted style regions stop creating style at 2000 rows.
As long as my spreasheet is 2001 rows or less (I have one header row), my dates
are nicely formatted, but if they go over that, I see the raw number
(32334.344233...). Has anyone else seen this problem? Is this some weird Excel
limitation?

I have attached the xslt stylesheet I use to create the .gmr file. The problem
is in the gmr:StyleRegion element below. If I set the spread between the
startRow and endRow to 2000 or less, those cells get converted to dates,
regardless of where they are in the column. But if I try to make the region any
bigger than 2000 rows, none of the cells in the column show up as dates.

<<qb_XmlToXls.xsl>>

<!-- date columns --> <xsl:for-each select="ColumnName//Label"> <xsl:if test="@dataType = 'date'">

<gmr:StyleRegion startCol="{position()-1}" endCol="{position()-1}" startRow="1"
endRow="2001"> <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="0" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0"
Format="d-mmm-yy"> <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">Helvetica</gmr:Font> <gmr:StyleBorder> <gmr:Top Style="0"/> <gmr:Bottom Style="0"/> <gmr:Left Style="0"/> <gmr:Right Style="0"/> <gmr:Diagonal Style="0"/> <gmr:Rev-Diagonal Style="0"/> </gmr:StyleBorder> </gmr:Style> </gmr:StyleRegion>

</xsl:if> </xsl:for-each>

I can go into more depth but I figure if someone else has run into this, they
should knwo the answer right off.

thx a lot

Matt Savino

Senior Web Developer Quest Diagnostics Inc. 33608 Ortega Hwy - Bldg C San Juan Capistrano, CA 92690 949.728.4832 cel - 310-344-0889 Balboa # - 818-895-6868