Aspose.Cells.ReportingServices.dll

modric14 · July 8, 2011, 5:05am

hi we are interested to purchase Aspose.Cells.ReportingServices.dll but would like to try whether the protect worksheet is working first. Can we try Aspose.Cells for Reporting Services v1.7.0.34 (SSRS 2008)

shakeel.faiz · July 8, 2011, 8:42am

Hi,

Thanks for your question and interest in Aspose.Cells.ReportingServices.

You can definitely download and use fully functional Evaluation version of Aspose.Cells.ReportingServices. The only limitation of Evaluation version is it injects an extra Evaluation Worksheet.

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)

Regarding Encryption:

Please reference the linked file to modify Encryption parameter at Aspose.Cells.ReportingServices.xml file: Encryption.docx

Encryption Configuration:

Please try following Encryption Configuration.

If you have any other question, please feel free to post here. We will help you asap.

modric14 · July 8, 2011, 11:50pm

Hi,

What is the difference between protect and encryption? I cannot get both to work on v1.7.0.36.

I suppose the xml config file should be in the same folder as the dll in the Bin folder?

Btw, is there an option to change sheetname in excel export? Thanks.

modric14 · July 9, 2011, 12:12am

also, our requirement is the user can open the excel as read-only but require a password to modify… can this be archieved?

shakeel.faiz · July 10, 2011, 8:38pm

Hi,

The latest version ( V1.7.0.36) supports Encryption and Protect & Lock functions .

Please install the latest version and modify Aspose.Cells for Reporting Services configuration information for protect function at Aspose.Cells.ReportingServices.xml.

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

<ProtectWorkSheet value=“ON”>

<Password value=“12345”/>

<ProtectType value=“ALL”/>

<ProtectWorkbook value=“ON”>

<Password value=“123456”/>

<ProtectType value=“ALL”/>

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

modric14 · July 10, 2011, 9:11pm

Hi, i have installed V1.7.0.36 using msi installer.

I think Aspose.Cells.ReportingServices.xml is not created by default so i copy from your sample, rename the report name and place the config file in the same folder as the DLL.

However, when i export the report into XLS- Excel workbook via Aspose Cells, the workbook is not protected. Do you know if i am missing any steps?

shakeel.faiz · July 10, 2011, 9:36pm

Hi,

The Aspose.Cells.ReportingServices.xml file is auto installed.

Its location is in the following folder : ${Aspose.Cells for Reporting Services installation folder}.

modric14 · July 10, 2011, 10:47pm

Hi, Thanks I am getting there, except a small issue.. In Excel , there are 2 types of encrytions.

1. Password to open

2. Password to modify

The Encryption xml config you posted does 1. Password to open. Our requirement is the 2. Password to modify - users able to read the file but need a password to modify.

Is it possible to config 2. Password to modify?

shakeel.faiz · July 11, 2011, 9:52am

Hi,

Thanks for your illustration.

We are looking into your issue. We will help you asap. Thanks for your patience.

jennisonllc · July 11, 2011, 12:55pm

hi
how can we protected PART of the file, only certain cells

shakeel.faiz · July 11, 2011, 9:33pm

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

We have looked into your issue and found, it is actually a New Feature.

We have logged your issue as CELSSREP-29068. Once, it is implemented, we will update you asap.

jennisonllc · July 12, 2011, 3:49pm

thanks
also, what are the valid ProtectTypes here

c

<ProtectWorkbook value=“ON”>

<Password value=“123456”/>

<ProtectType value=“ALL”/>

amjad.sahi · July 12, 2011, 11:17pm

Hi,

We have added new feature for password to modify it.

Please try the fixed attached version (V1.7.0.37) for SSRS 2008.

Please refer to the following steps.

1. Modify Aspose.Cells.ReportingServices.xml file.

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

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

2. Copy the Aspose.Cells.ReportingServices.dll file into the following folder : ${MS SQL Server 2008 for Reporting Services installation folder}\Reporting Services\ReportServer\bin.

For how can we protect a PART of the file, only certain cells issue:

Now, we only support Excel protection & locking functinality for the whole workbook or worksheet.

When protecting worksheet in Excel, Excel only supports certain cells can be modified.

So if we realize to protect certain cells, you manually must set report item is protected at the Aspose.Cells.ReportingServices.xml file.

Do you think that can meet your needs?

If yes, we will develop it.

Please provide your demo file for us. We will refer it for developing the feature.

For Protection Types issue:

We support the following types:

All
Windows
Structure

jennisonllc · July 13, 2011, 1:36pm

hi

thank you for the reply, but i honeslty dont understand what the paragraphs means. did you incorporate this feature?

basically, 1) protect the entire workbook with a password, without the password its readonly, and 2) allow some columns to be editable?

amjad.sahi · July 13, 2011, 2:14pm

Hi,

We noted down your 2 requirements and we will get back to you soon.

Thank you.

shakeel.faiz · July 14, 2011, 12:03am

Hi,

There are two kinds of protecting excel file in excel .

1. Encryption: Require a password to open or modify this workbook.

2. Protection:

a. Protect Worksheet: Control what types of changes people can make to the current worksheet.

b. Protect Workbook: Prevent unwanted changes to the structure of the workbook. Such as adding worksheet.

There are encryption and protection configure information in the Aspose.Cells.ReportingServices.xml file.

For two note:

1. You may set the “IsWriteProtected” parameter of encryption configuration information to realize note 1.

2. Currently, we do not support note 2.

a. Please give us detail description of your requirement.

b. Such as, did editable columns associate with report item?

c. Does it meet your requirement that points editable column through modifying configuration information?

jennisonllc · July 18, 2011, 4:01pm

mshakeel.faiz:

Hi,

There are two kinds of protecting excel file in excel .

1. Encryption: Require a password to open or modify this workbook.

2. Protection:

a. Protect Worksheet: Control what types of changes people can make to the current worksheet.

b. Protect Workbook: Prevent unwanted changes to the structure of the workbook. Such as adding worksheet.

There are encryption and protection configure information in the Aspose.Cells.ReportingServices.xml file.

For two note:

1. You may set the “IsWriteProtected” parameter of encryption configuration information to realize note 1.

2. Currently, we do not support note 2.

a. Please give us detail description of your requirement.

b. Such as, did editable columns associate with report item?

c. Does it meet your requirement that points editable column through modifying configuration information?

hi thanks for the reply

a) i would like the entire workbook to be viewable, but locked. it should only be editable with a password. i would then like a certain column to be editable, at all times.

b) i am not sure what you mean. the editable items WOULD be associates with colulmns, in my example

c) sure

thanks

c

shakeel.faiz · July 19, 2011, 2:54am

Hi,

Thanks for your input and using Aspose.Cells for Reporting Services

We have looked into your requirements. We need to implement them.

We have logged your requirements in our database. Once there is some update for you, we will share it with you asap.

shakeel.faiz · July 20, 2011, 1:51am

Hi,

We have added function for Protect Worksheet.

Please try the fixed version for SSRS2008.

Please reference follow operators.

1. Modify configuration information for protect function at Aspose.Cells.ReportingServices.xml.

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

<ProtectWorkSheet value=“On”>

<Report name=“YourReportName” >

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

2. Update Aspose.Cells.ReportingServices.dll file.

a. Copy the Aspose.Cells.ReportingServices.dll file into the following folder : ${MS SQL Server 2008 for Reporting Services installation folder}\Reporting Services\ReportServer\bin.

b. Check version.

jennisonllc · July 20, 2011, 8:47am

hi

please provide an SSRS2008 R2 VERSION

thanks

c