I have an ultrawingrid with multiple data records and each record has a currency amount column. The currency of each record may be different and I want to format the amount with the appropriate currency symbol based on the value of a currency indicator column (which also appears as a another column in the grid). Is there anyway to do this on a row-by-row basis using conditional formatting.For instance:

CAD      $ 10,000.00
GBP      £ 10,000.00
EUR      € 10,000.00

For reasons too long to explain,

- this cannot be done at the data query level since the value of the data column needs to remain as a numeric/currency value and not a formatted string

- we've attempted to "intercept" the binding process and format the "text/display" value of each row/cell as required and leave the value as is; in short, in a grid with 10,000 records, this type of processing  was taking 15-20 seconds to process which was unacceptablebeing returned