topic Re: ODS Excel spanning headers with thicker borders in ODS and Base Reporting

ODS Excel spanning headers with thicker borders

amiller9702 — Tue, 03 Jan 2017 18:48:05 GMT

Hello!

I am pretty new to ODS and have never posted to a board here so I apologize in advance.

I have created some spanning columns in my proc report and I want those spanned headers to have a thicker boarder. I tried using style (header) but I can't seem to just modify the spanned headers borders. Is there a way to just change the spanned header borders?

Thank you for your help in advance!

Angie

Re: ODS Excel spanning headers with thicker borders

AhmedAl_Attar — Tue, 03 Jan 2017 21:56:03 GMT

I have not worked extensivally with ODS Excel, but check out this paper https://support.sas.com/resources/papers/proceedings11/246-2011.pdf, It could have examples that might of use to you, or at least guides you in the right direction.

Hope this helps,

Ahmed

Re: ODS Excel spanning headers with thicker borders

Cynthia_sas — Wed, 04 Jan 2017 03:03:41 GMT

And this is a good paper, too: http://support.sas.com/resources/papers/proceedings10/133-2010.pdf

However, Excel is notoriously "picky" about border lines, so if you really, really, really need to alter the border lines, you might need to learn how to use style templates to impact the border lines.

cynthia

Re: ODS Excel spanning headers with thicker borders

amiller9702 — Wed, 04 Jan 2017 14:35:16 GMT

Thank you so much! I will take a look here and see waht I can do.

Re: ODS Excel spanning headers with thicker borders

amiller9702 — Wed, 04 Jan 2017 14:36:38 GMT

Ahh okay! That is good to know! I will look into style templates.

Thank you so much!!