Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
140
How do I convert to currency, rates, and count values on different rows?
posted

The datagrid appears to handle type/value display and editing very well when because it meets the contract of a database table.  But I have a requirement to display the data in rows instead of columns.

Example:

 

Jan 2008 Apr 2008 Jul 2008 Oct 2008 Total
Offering Rate 4.35% 4.45% 4.36% 4.78% N/A
Loan Amount $423,426.09 $401,426.09 $523,426.09 $476,426.09 $1,723,426.09
Number of Loans 426 1,426 529 3,232 6,345

 Editing is by cell, some rows or cell may be readonly. 

We also need to support multi cell copy paste of values.

What is the best way to do this?