I have implemented a data view web part with SharePoint Designer on a site with Locale Finnish/Swedish. The data view aggregates data from several lists within the site. My first problem was that numbers with commas wasn't displayed in my data sheet. I found
a workaround where I added the following lines to the XSLT:
<xsl:decimal-format decimal-separator="," grouping-separator="." name="lcid1060" />
<xsl:value-of select="format-number(translate(@MyColumn,',','.'), '#,0','lcid1060')"/>
By doing this I can get the values formatted as numbers with commas as separator.
My problem is however that the sort function in the data sheet view web part sorts the column as text. So my question is how to get the data view to sort the column as a number instead of text?
View Complete Post