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! 

Coordinator
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.

M.

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:

http://handsontable.com/demo/conditional.html

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

Cheers,
Matthew