Im having a problem summing 2 large numbers in xslt..
Here is a snippet..

<Cell ss:StyleID="s27"><Data ss:Type="String">Grand Total</Data></Cell>
<Cell ss:Index="7" ss:StyleID="s33"><Data ss:Type="Number"><xsl:value-of select="sum(/*/MorningStarFundReport/CUSIP_Market_Value)"/></Data></Cell>
<Cell ss:StyleID="s35" ss:Formula="=SUBTOTAL(9,R[-3]C:R[-2]C)"></Cell>

This works great when the values are
999999.9999 or lower, but any number higher than that does not work.
I am exporting this to an Excel spreadsheet..
Please note that the SUBTOTAL function works just fine

Ive tried to change formatting for the cell, I have also tried to assign the sum to a varibale & work with it..to no avail

Any help out there?

Thanks

Consider to post minimal but complete samples of an input document, a stylesheet, the output you want, the one you get, together with information about the XSLT processor used.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog

As Martin says, we need more information.

Also: never say in a posting that something "doesn't work" without saying how it fails.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

we need more information

Thanks, sorry I didnt include more info..However I did find a workaround