Problem with working with a protected sheet.

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Setup sheet for update or insert
2.Setup formulas in certain columns.
3.Protect/lock a worksheet with certain columns unlocked.

What is the expected output? 
I want to be able to setup a sheet with all the formulas and vlookups setup. 
And only leave certain columns unlocked for users to copy/paste data into the 
worksheet.

What do you see instead?
When I tried to use insert or update I get a "Oops, Could not find an acitve 
Worksheet" message.

What version of the product are you using?
sforce_connector_ee_1603
On what operating system?
Windows XP
With what Salesforce.com edition?
Enterprise

Please provide any additional information below.

Original issue reported on code.google.com by charlie...@gmail.com on 4 Mar 2012 at 4:07

[GoogleCodeExporter]

looks like the active sheet cannot be returned when cells are protected, either 
the sheet must be un protected or the connector cannot work.

Original comment by vneh...@gmail.com on 30 Jan 2013 at 12:25

• Changed state: Done