Skip to main content
Inspiring
Jan 9, 2023 3:04 PM UTC
Question

Using Hex colors within CFSpreadSheet

I'd like to be able to use a hex value for color like: <cfset SpreadsheetFormatCell(xl,{color="#FE0000",fgcolor="#Clr#"},#xl.rowcount#,1)> or <cfset SpreadsheetFormatCell(xl,{color="#355f91",fgcolor="#Clr#"},#xl.rowcount#,1)> 

Currently you can only use this list of predefined colors:

Colors="black,brown,olive_green,dark_green,dark_teal,dark_blue,indigo,grey_80_percent,orange,
dark_yellow,green,teal,blue,blue_grey,grey_50_percent,red,light_orange,lime,sea_green,aqua,light_blue,
violet,grey_40_percent,pink,gold,yellow,bright_green,turquoise,dark_red,sky_blue,plum,grey_25_percent,
rose,light_yellow,light_green,light_turquoise,light_turquoise,pale_blue,lavender,white,cornflower_blue,
lemon_chiffon,maroon,orchid,coral,royal_blue,light_cornflower_blue"

    This topic is closed to new replies. Start a new post to keep the conversation going.

    5 replies

    kglad
    Community Expert
    Community Expert
    Jan 9, 2023 3:10 PM UTC

    in the future, to find the best place to post your message, use the list here, https://community.adobe.com/

     

    p.s. i don't think the adobe website, and forums in particular, are easy to navigate, so don't spend a lot of time searching that forum list. do your best and we'll move the post if it helps you get responses.

     

    <moved from using the community>

    Translate
    Inspiring
    Jan 9, 2023 10:35 PM UTC

    Can you move it to the oppropiate location.

    Translate
    Inspiring
    Jan 17, 2023 3:19 PM UTC

    Opened a ticket on the other site.  Have not gotten any reply.

    Translate
    Inspiring
    Jan 9, 2023 3:09 PM UTC

    Coldfusion using CFSpreadSheet to format the color of cell

    Translate
    Peru Bob
    Community Expert
    Community Expert
    Jan 9, 2023 3:06 PM UTC

    This is the Using the Community forum (which is the forum for issues using the forums).
    Please tell us what Adobe application you are using so that this can be moved to the proper forum for help.

    Translate