Cell protection using ExcelXP tagset

[EyalGonen]

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

[Cynthia_sas]

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

[Peter_C]

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]