topic Re: ODS Excel - Can cell gradient fills be specified? in ODS and Base Reporting

ODS Excel - Can cell gradient fills be specified?

RichardAD — Wed, 18 Sep 2024 16:54:25 GMT

In Excel you can format a cell's fill effect to be a gradient. Can ODS EXCEL create the same?

Re: ODS Excel - Can cell gradient fills be specified?

Cynthia_sas — Wed, 18 Sep 2024 18:18:28 GMT

Hi:

My guess is that it would depend on what procedure you were using to create your output within the ODS EXCEL statements. For example, you can use gradient fills in SG procedure graphics so my guess is that you could send that SG procedure output to ODS EXCEL and that would work. However, I am having a hard time understanding how you would use a gradient fill in tabular output, such as with PROC REPORT, TABULATE or PRINT.

Do you have any concrete example of how your gradient fill looks in the Excel worksheet after you apply the gradient?

Cynthia

Re: ODS Excel - Can cell gradient fills be specified?

RichardAD — Wed, 18 Sep 2024 18:45:18 GMT

I am creating total counts from different combinations of item counts. An item can be in 1 or 2 different total sums, so I am trying to show which totals they contribute to via a color-coding scheme.

In this simple sample I am trying to use header colors to show how the Count_a,b,c,d,e components are used to compose the totals Count_X,Y,Z.

Re: ODS Excel - Can cell gradient fills be specified?

Cynthia_sas — Fri, 20 Sep 2024 19:58:31 GMT

HI:
Well, that is not what I thought you were doing with gradients. I find that extremely hard to read, especially with the colors in G and H blurring together. However, I think this is a question you'd need to ask of Tech Support. The only way I know to "touch" the Excel cells with things like Excel-specific number formats is with the TAGATTR style override. However, I don't understand how Excel defines the gradient for the cell or whether it would be possible in a TAGATTR.
Cynthia