Skip to main content
Inspiring
January 9, 2023
Question

Using Hex colors within CFSpreadSheet

  • January 9, 2023
  • 3 replies
  • 463 views

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 has been closed for replies.

    3 replies

    kglad
    Community Expert
    Community Expert
    January 9, 2023

    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>

    Inspiring
    January 9, 2023

    Can you move it to the oppropiate location.

    Inspiring
    January 17, 2023

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

    Inspiring
    January 9, 2023

    Coldfusion using CFSpreadSheet to format the color of cell

    Peru Bob
    Community Expert
    Community Expert
    January 9, 2023

    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.