This project has moved and is read-only. For the latest updates, please go here.

SPAutocomplete in Datasheet view

Dec 7, 2012 at 4:37 PM

So, I'm pretty much brand new to the SharePoint world. I've implemented and tested the SPAutocomplete feature, which should be a huge asset for our use, however I was just informed that the employees will only use datasheet view, not standard (company is totally excel driven).

I noticed the autocomplete does not translate to datasheet view. Is there a step I'm missing, or is this not possible?

Marc - if you're reading, your blog has been a HUGE help to me with getting started, so thanks! 

Dec 7, 2012 at 4:41 PM

Glad to be of help!

Nope, all bets are off on the Datasheet view. It's an ActiveX control, and pretty much impenetrable.


Dec 7, 2012 at 7:04 PM

Like Marc said, Datasheet view is not friendly for front-end code, however, you may be able to repro most of the functionality with something like this:

Maybe that'll allow your users to have "Excel" and you'll still be able to control the I/O.