Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Using Hex colors within CFSpreadSheet

Explorer ,
Jan 09, 2023 Jan 09, 2023

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"

140
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources