Excel Cell Protection on SSRS Rendering Extension

Aspose.Cells Product Family
1

Hi,

Does Aspose.Cells for Reporting Services support cell-protection when rendering in Excel ?

What I want is to set a custom property in a Textbox for rendering extension indicating that cell will be protected or not.

Thanks

Jean-Pierre RIEHL

2
Hi,

Please check the thread for your reference:
https://forum.aspose.com/t/126757

3
Hi,
There isn't any answer, just someone telling it's work but did not give the solution.
The only sample on the thread is about Sheet protection, not cell protection
Thanks for answer.
Jean-Pierre
4

Hi,

I have forwarded your question to development team. However, I guess, you will have to wait till Monday because our developers are on holidays and get back next week.

5

Hi,

Please try setting protect worksheet parameters in Aspose.Cells.ReportingServicse.xml file.

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

<ProtectWorkSheet value=“ON”>

<Report name="YourReportName" >

<Password value="123456"/>

<ProtectType value="ALL"/>

<AllowEditRanges>

<Ranges SheetIndex="1" Name="AllowEditRange1" StartRow="0" StartColumn="0" EndRow="0" EndColumn="0" />

<Ranges SheetIndex="1" Name="AllowEditRange2" StartRow="1" StartColumn="1" EndRow="2" EndColumn="2" />

</AllowEditRanges>

</Report>

</ProtectWorkSheet>



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

6

Thanks,

That's exactly what I wanted !

Jean-Pierre Riehl

http://blog.djeepy1.net