topic Re: List of Available TAGATTR? in ODS and Base Reporting

List of Available TAGATTR?

JeffMeyers — Mon, 21 Aug 2023 18:13:33 GMT

Hello,

I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option? I've searched a lot but haven't found anything.

Re: List of Available TAGATTR?

ballardw — Mon, 21 Aug 2023 18:37:29 GMT

@JeffMeyers wrote:

Hello,

I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option? I've searched a lot but haven't found anything.

Probably because TAGATTR stuff passes instructions to the receiving program to use that program's options. So you have to know the receiving program options and the syntax involved.

So you would be looking at EXCEL documentation. I think if you search this forum for TAGATTR you will examples where people place formulae into cells as well as the relatively minor numeric formatting choices that are common.

Re: List of Available TAGATTR?

PaigeMiller — Mon, 21 Aug 2023 19:03:44 GMT

You can follow these instructions to see what TAGATTR= options are available for ODS TAGSETS EXCELXP, most of the option (maybe even all of the options) will also be available for ODS EXCEL

Re: List of Available TAGATTR?

JeffMeyers — Tue, 22 Aug 2023 05:31:26 GMT

This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are.

Re: List of Available TAGATTR?

PaigeMiller — Tue, 22 Aug 2023 10:45:30 GMT

@JeffMeyers wrote:
This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are.

Better you should have mentioned what you really want in your first question. In any event, I do not know the answer.