Aspose cells using ProtectedRange to allow domain users/groups edit permissions

In excel you can click the "Allow Users to Edit Ranges" and create a range and assign a range password. In addition, you can set permissions for that range for either domain users and or domain groups to edit the range with or without a password.

In Aspose cells there is a ProtectedRange object which allows you to assign a passsword to a cellarea but I dont see how you can apply permissions to allow a domain user or group the ability to edit the range with or without a password.

Hi,


Thanks for considering Aspose.Cells.

I have logged a ticket with an id: CELLSNET-41052 for it first. Our concerned developer will investigate and check the feasibility of the feature (i.e…, Set Permissions i.e…, who may edit the range with a password for Allow Users to Edit the Ranges feature that is already provided by Aspose.Cells for .NET product) if we can support it or not. We will analyze it soon, once we have any update on it, we will let you know here.

Thank you.
WilliamW:

In excel you can click the "Allow Users to Edit Ranges" and create a range and assign a range password. In addition, you can set permissions for that range for either domain users and or domain groups to edit the range with or without a password.

In Aspose cells there is a ProtectedRange object which allows you to assign a passsword to a cellarea but I dont see how you can apply permissions to allow a domain user or group the ability to edit the range with or without a password.

Hi,

Thanks for using Aspose.Cells for .NET.

Please use worksheet.AllowEditRanges for your needs.

Let us know if you still face any issue.


I have followed your suggestion but still end up with a ProtectRange object and I stated in my first post how do you assigndomain users and domain groups to this rnage as you can in Excel.

WilliamW:

I have followed your suggestion but still end up with a ProtectRange object and I stated in my first post how do you assigndomain users and domain groups to this rnage as you can in Excel.

Hi,

Thanks for your input.

We have added your comments in our database against the issue id: CELLSNET-41052

We will look into your issue and give you advice asap.

Hi,

We have closely looked into your request. Now we know what’s your need.

We can only provide a temporary solution (Adding ProtectedRange.SecurityDescriptor to get and set securityDescriptor) because we are not very clear the structure of this feature.

The structure of the ProtectedRange.SecurityDescriptor is :

“O:WDG:WDD:(A/D;; CC;;;SID)*”
“O:WDG:WDD “: unknown
"A/D”: Allow or Deny
"CC”: unknown
SID: User or group sid.

There are two ways to get SID:
a) by tool PsGetSid : http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx
b) by codes : http://www.codeproject.com/Articles/3688/How-to-get-user-SID-using-DirectoryServices-classe

For example:

We added permissions for two users, one is denied, another is allowed. The codes is following :

ProtectedRange.SecurityDescriptor="O:WDG:WDD:(D;;CC;;;S-1-5-21-2854911246-2539335229-2923752399-1000)(A;;CC;;;S-1-5-21-2854911246-2539335229-2923752399-1013)"

Please let us know whether it fits your needs.

For the short term I think it may fit our needs.

Hi,


Thanks for the confirmation.

We will go for it. Once it is supported, we will let you know here.

Thank you.

Hi,

Thanks for using Aspose.Cells.

We have added new property ProtectedRange.SecurityDescriptor for your needs.

Please download and try this fix: Aspose.Cells for .NET v7.3.1.5 and let us know your feedback.

Thanks will advise when we test the functionality

Hi,

You are welcome.

Please feel free to post on our forums to let us know your findings or if you face any other issue relating to Aspose.Cells.

We will be glad to assist you further.

The issues you have found earlier (filed as CELLSNET-41052) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.