How to set Column Header Text Color

Posted by: cpn on 9 June 2020, 10:22 pm EST

  • Posted 9 June 2020, 10:22 pm EST

    How do I set the color of the text in the column headers. I'm using the DLL version, and I can select between different appearance styles, and when using SS_APPEARANCESTYLE_ENHANCED I can change the background, but not the foreground text?
    Kindly cpede
  • Replied 10 June 2020, 9:31 pm EST


    Please refer the following documentation link which provides detailed information on setting text colors in column/row headers:

    Additional information on setting forecolor for the sheet:

  • Marked as Answer

    Replied 11 June 2020, 5:19 pm EST

    Hi Pragati, thanks for the quick answer.

    Using the following code

    SSSetShadowColor(m_General->GetSafeHwnd(), SPREAD_COLOR_NONE, RGB(255, 0, 0), SPREAD_COLOR_NONE, SPREAD_COLOR_NONE);

    It seems, that the method SetShadowColor does the trick (maybe not the best name for a method setting the color of the header text).

    Thanks for the help, - I'm still beating my colleagues programming .NET, using your old DLL spread version. :-)

  • Replied 11 June 2020, 6:12 pm EST

    Glad to know that it worked :)
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels