Extending or modifying the SharePoint Datasheet view

Question

Hi,

Has anyone discovered a way to extend or modify the functionality of the SharePoint Datasheet view (the view used when you edit a list in Datasheet mode, the one that looks like a basic Excel worksheet)?

I need to do several things to it, if possible, but I have yet to find a decent non-hackish way to change any functionality in it.

EDIT: An example of what I wish to do is to enable cascading filtering on lookup fields - so a choice in one field limits the available choices in another. There is a method to do this in the standard view form, but the datasheet view is completely seperate.

Regards

Moo

Answer 1

I don't think you can modify it in any non-hackish way, but you can create a new datasheet view from scratch. You do this by creating a new ActiveX control, and exposing it as a COM object, and modifying the web.config file to make reference to the new ActiveX control.

There's an example here: Creating a custom datasheet control.