Is there a way to change the CultureInfo (currency format specifically) for a specific column on a row by row basis. That is row 1 shows EUR in the amount column whereas row 2 shows YEN and row 3 shows USD for the same column?
Hi,
Yes, this is possible. What you need to do is use an Editor. You create the editor and assign the Format and FormatInfo you want, then assign that editor to the grid cell.
The grid column setting will override the editor setting, though, so you must make sure that you do not set the Format or FormatInfo on the column.
I have an attached a sample project here which demonstrates this technique. My sample is only setting the format and not the FormatProvider, but you get the idea. :)
Thanks Mike, this solution is working properly.
Hello,
Please let us know if you require further assistance with your question.