topic Re: Cell protection using ExcelXP tagset in ODS and Base Reporting

Cell protection using ExcelXP tagset

EyalGonen — Wed, 30 Jun 2010 17:50:04 GMT

Hello everyone,

Does anyone know if it is possible to protect certain columns/cells when using the ExcelXP tagset?

For example, I am proc printing SASHELP.CLASS and would like to protect the NAME column from changes.

Thanks,
Eyal

Re: Cell protection using ExcelXP tagset

Cynthia_sas — Wed, 30 Jun 2010 18:22:30 GMT

Hi:
I believe that TAGSETS.EXCELXP gives you ways to hide or freeze particular columns, but does not provide a method for protecting columns. I think this is because the method of protecting columns happens from an Excel drop down box that may not have an XML or Spreadsheet Markup Language tag that is "not" produce-able by TAGSETS.EXCELXP.

You may want to check with Tech Support whether this might be possible at all with other tagsets, such as TAGSETS.TABLEEDITOR or not.

cynthia

Re: Cell protection using ExcelXP tagset

Peter_C — Tue, 06 Jul 2010 12:59:03 GMT

if it's not there yet, I think it might be introduced to the tagset "real soon now" 😉
See the developers paper "Paper 031-2010 ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute with the ExcelXP Tagset" at
http://support.sas.com/resources/papers/proceedings10/031-2010.pdf"

many of the snippets of generated XML show [/pre]