Changes

Exporting Currency Values to Excel from List Views

282 bytes added, 17:24, 21 June 2013
no edit summary
The list view export now checks if the Number Format in the custom field being referenced is set to Currency, and then will strip the currency formatting out.
This will not work for [[Custom Field Type: Read Only – System Variables|Read Only - System Variable ]] fields.
This will work if the field is a [[Custom Field Type: Store Values – System Variables|Store Value - System Variable ]] with a [[variable ]] such as
<nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Revenue.Grant.Rev-Amount.nodevalue@</nowiki>
(and the [[Number Format|Number formatting ]] is set to "Currency)."<br>
...but not if the currency is defined in the variable, such as
<nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Expenses.Capital.Currency(Ex-Amount.nodevalue)@</nowiki>
 
==See Also==
* [[Exporting List View Results to Microsoft Excel]]
* [[XML]]
* [[Number Format]]
 
[[Category:List Views]]
[[Category:Currency]]
8,849
edits