Does anyone know how to create an EXL2K file that is Protected and or has columns hiden?This message has been edited. Last edited by: Kerry,
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
February 28, 2013, 05:18 PM
Prarie
You would have to upgrade.
Starting in WebFOCUS 7.6, a New Feature is availabe to lock an EXCEL spreadsheet at run time from within a WebFOCUS procedure. The new settings are part of the StyleSheet portion of a procedure: TYPE=REPORT, PROTECTED={ON|OFF}, [LOCKED={ON|OFF}],$
PROTECTED=ON . Required to lock a spreadsheet. . If the LOCKED=OFF attribute is omitted, the entire spreadsheet is locked.
PROTECTED=OFF . Spreadsheet is not locked. Default behavior.
LOCKED=ON . Locks the entire spreadsheet with PROTECTED=ON
LOCKED=OFF . Unlocks the spreadsheet as a whole, but enables you to lock or unlock specific cells or groups of cells.
TYPE=type,[COLUMN=columnspec],LOCKED={ON|OFF},$
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
March 04, 2013, 10:01 AM
RSquared
It just so happens that we are in the process of upgrading to 7.6.11. I will be trying this code on the new version, thanks ever so much.
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
March 04, 2013, 02:46 PM
Prarie
That's great...your world is going to be much better!