Free Support Forum - aspose.com

Excel Cell Protection on SSRS Rendering Extension

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

Hi,

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

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

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.

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>



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

Thanks,

That's exactly what I wanted !

Jean-Pierre Riehl

http://blog.djeepy1.net