1. I have a foreign key reference (similar to the ForeignKeyReference example) where the displayed column is a name while the key column is a number. If I paste something to the displayed name column I get a format error. It seems that the pasted value go directly to the numeric key column instead of using the lookup mechanism. The behaviour of the control is fine when I type in the name instead of pasting. A similar behaviour is seen in the ForeingKeyReference example. In that case the pasted value is lost, but there is no error message. Is there a simple way to make pasting to foreign key columns work?
2. When I double click a foreign key column, the value changes. I think this is a bit confusising and can easily make the user change the value by accident, e.g. when trying to select. Is there a simple way to disable this behaviour?
ADAdministrator Syncfusion Team April 22, 2005 07:52 AM
1)I see this behavior and will forwarded it to the grid architect to see if this is something we can address in a future release.
If you want to handle it now, one can subscribe to the this.gridGroupingControl1.TableModel.PasteCellText event. In the handler, check the string value in e.Text and convert it to a string holding the proper key.
2) Try handling the this.gridGroupingControl1.TableModel.QueryCellModel event. There you can set a property to avoid this behavior.
ADAdministrator Syncfusion Team April 24, 2005 04:10 AM
1) For now I simply decided to prevent paste to foreign key cells. Since I typically sort on these cells, a proper handeling of paste would also need to adress the sorting issue I have mentioned in a previous post.
2) Works perfectly, Thanks.