I am using the Essential Studio v3.2.1.0 Grid in unbound mode. As I load data into the grid I am setting cell specific formatting and Type requirements as follows:
Dim CellInfo As GridStyleInfo = Me.gridData.Item(RowIndex, ColIndex)
CellInfo.Format = "#0.00%"
CellInfo.CellValueType = GetType(Single)
CellInfo.CellValue = .181
The grid properly displays "18.10%", the CellValue is .181, and CellValueType is Single.
When the user edits the value and changes it to for example "18.40%" I receive the following exception:
A first chance exception of type ''System.Exception'' occurred in system.dll
Additional information: 18.4% is not a valid value for Single.
If I do not set the CellValueType property to Single the user can successfully edit the cell, but the CellValueType changes from Single to String and the CellValue is the string "18.40%" not .184. Tracing the events I was able to determine this Type conversion occurs between the CurrentCellChanged event (the underlying Type was still Single during this event) and the CurrentCellEditingComplete (the underlying Type is a String during this event). The Type conversion to a String causes problems when I save data back to my objects and/or the database.
The requirement is to display "18.4%" but store and persist to the database .184.
Thank you for any suggestions.
Ron Pisarz, Jr.
