Parsing NumberFormat values in XMLSS (Excel Spreadsheets)
Posted: Mon Jun 12, 2006 9:08 am
Does someone have experience with XML Spreadsheets (XMLSS) from Microsoft (Excel)?
http://msdn.microsoft.com/library/defau ... _xmlss.asp
I need a function, which converts my numbers to the right format depending on the value in <ss:NumberFormat> (in the Style-tag). Unfortunately the documentation doesn't really help, especially when I have such values:
<NumberFormat ss:Format="_-* #,##0.00\ "€"_-;\-* #,##0.00\ "€"_-;_-* "-"??\ "€"_-;_-@_-"/>
Can someone help me?
http://msdn.microsoft.com/library/defau ... _xmlss.asp
I need a function, which converts my numbers to the right format depending on the value in <ss:NumberFormat> (in the Style-tag). Unfortunately the documentation doesn't really help, especially when I have such values:
<NumberFormat ss:Format="_-* #,##0.00\ "€"_-;\-* #,##0.00\ "€"_-;_-* "-"??\ "€"_-;_-@_-"/>
Can someone help me?