Protecting / Locking Excel Cells from Edit via Aspose.Cells for SSRS Reporting Services

Aspose.Cells Product Family
1

hi

i would like to know how to lock or protect my excel file coming out of SSRS. so users can see it, but not edit it.

thanks

2

Hi,

Please reference attached file to modify Encryption parameter at Aspose.Cells.ReportingServices.xml file.

3

hi

i dont want to encrypt every report that i run.

i want to protect certain reports, so the contents could not be changed.

4

Hi ,

Please try following Encryption Configuration.


<Encryption value=“on”>



<Password value=“12345”/>

<EncryptionType value=“Microsoft Strong Cryptographic Provider”/>

< KeyLength value=“128”/>






<Password value=“123456”/>

<EncryptionType value=" XOR “/>

<KeyLength value=“128”/>




……




<Password value=“123456”/>

<EncryptionType value=” XOR "/>

<KeyLength value=“128”/>







5

again

i am NOT trying to encrypt, i am trying to LOCK/protect certain reports

thanks

6

Hi,

We have added a new feature for excel report file protect function.

Please download the latest version: Aspose.Cells for Reporting Services v1.7.0.34 (SSRS 2008 R2)

Update the Aspose.Cells.ReportingServices.dll file which is at following folder:

${ SSRS 2008 R2 installation folder}\Reporting Services\ReportServer\bin.

Check Aspose.Cells.ReportingServices.dll version .

Add new configuration information for protect function at Aspose.Cells.ReportingServices.xml.

=======================================================================

























=========================================================================

Please reference the attached file (Aspose.Cells.ReportingServices.xml).

7

Is there a SQL Server 2008 version of the latest or

v1.7.0.34 for

Aspose.Cells.ReportingServices.dll?

8

Hi,

The latest version of Aspose.Cells for ReportingServices is v1.7.0.36.

I have provided links to in this post: 315373, for your help I am posting them again.

Please download one of the following depending on your SQL Server Version.

For SSRS 2008 or 2008 R2
Aspose.Cells for Reporting Services v1.7.0.36 (SSRS 2008)
Aspose.Cells for Reporting Services v1.7.0.36 (SSRS 2008 R2)

MSI Installer
Aspose.Cells for Reporting Services v1.7.0.36 (MSI)

9

hi

thank you. we want to control which part of the file, which cells, can be protected, not just the entire file

c


<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–>

Ok, I tested the locking of cells. It works. Is there a way we could control which cells are locked and which cells are not locked? They want comments column to be editable and the rest of the report locked. Also, could we export the worksheet as protected? Meaning users would not be able to modify the locked cells. Until the worksheet is protected, users are allowed to modify the locked cells. We need both features.


10
Hi,

Please provide the demo file for Excel. Tell us your control area. Currently, we only support Excel protect & locking functionality for the whole workbook or worksheet. When protecting worksheet in Excel, Excel only supports some portion of cells can be modified. So, if you realize to protect certain cells, you must have to manually set report item protected in the Aspose.Cells.ReportingServices.xml file.

Do you think that can meet your needs?

If yes, we will develop it soon.

Thank you.
11

can someone contact me? it is not clear what you mean

12

Hi,

Please follow up this post and let us know your requirements.