Feature or Misfeature?

[Aaron.B]

I have noticed that in Excel 2007 (not sure about earlier versions) if you have a worksheet protected, the SpellChecker becomes disabled. There are pros and cons to this approach. What do you think?

 

[schielrn]

I would think the same would be true for earlier versions and that is the way it should be IMO. Because you could then use spell checker to change anything in the workbook, kind of like a find and replace. Not sure what you mean by Feature or Misfeature, so I haven't voted yet.

If the sheet is protected then you shouldn't be able to modify any cells as set through the protection.

Now one might say if I have some cells unlocked it should then spell check those unlocked cells, but not sure how much coding that would take and how exactly spell check works. But even find and replace doesn't work in protected sheets with some cells unlocked, so I wouldn't want people changing things.

 

[Jon von der Heyden]

Misfeature! If I am developing a model and have protected a sheet then I still expect to be able to do a spell check. Perhaps it should be configured to prompt for password before change (if password protected). Or at least flag spelling errors even if not correcting...

But then I can't say that I ever noticed so it doesn't really bug me

 

[schielrn]

Misfeature! If I am developing a model and have protected a sheet then I still expect to be able to do a spell check. Perhaps it should be configured to prompt for password before change (if password protected). Or at least flag spelling errors even if not correcting...

But then I can't say that I ever noticed so it doesn't really bug me

So are you saying you should be able to use find and replace on a protected sheet as well? You can almost use spell checker in that way?

 

[Domski]

I can see why they wouldn't allow it. A feature to check unlocked cells might be nice but as it's something that has never been an issue for me in the past I can't call is a misfeature.

Dom

 

[Gerald Higgins]

Woh even neeeds spelchekc ???

 

[Sandeep Warrier]

A bit off topic... but based on Gerald's post... some interesting reading...

http://www.mrc-cbu.cam.ac.uk/people/matt.davis/Cmabrigde/
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[Aaron.B]

I am saying that it should obey the lock/unlocked property. A worksheet can be protected and still have unlocked cells. In fact most of my worksheets get released this way to prevent accidental edits.