If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can we lock the excel cells (columns) in the report output

Started by ssikji, 06 Sep 2015 12:29:07 PM

Previous topic - Next topic

ssikji

Hi,
Can we lock the excel cells (columns) in the report output
Here is the example
A              B             C      D
---------------------------------------------
100            105        =A1-B1          =C1/A1
400            450        =A2-B2            =C2/A2
                             =A3-B3            =C3/A3
Requirement is user will insert the values in the B columns once the report is generated to excel and delivered to them, so that in the 'C' & 'D' column they can see the values.

Note: Columns 'A', 'C' & 'D' should be locked so they should not edit the values of 'A' column and edit the formula in 'C' & 'D'