Stats

  • Replies 8
  • Subscribers 160
  • Views 16839
  • Members are here 0
More Content

How do I change a cells background color without using a style

iCraig

I'd like to set the background color of a cell based on a pass/fail criteria. I don't really want to create a style for all the various combination, especially since axlSpreadsheetSetStyleParent() doesn't work.


Thanks,

Craig

  • eDave

    red = axlSpreadsheetGetRGBColorString(255 0 0)

    axlSpreadsheetSetStyleProp("Fill" "Color" red)

    axlSpreadsheetSetStyleProp("Fill" "Pattern" "Solid")

  • iCraig

    That works for a style. I'd like to modify the cell without having to create another style. Right now I have a dozen styles just to do different borders. Now if I want to have 4 colors to those dozen styles I end up with 48 styles. It's getting out of control.


    Thanks,

    Craig

  • DHung

    Hi eDave,

    Sorry for I posted this topic but my issue nearly this.

    I'm newer person. Can you detail  me how to set background for every cell in excel, example: blue for cell(1,1) yellow for cell(1,2) ?
    My code only set 1 color for every cell in my export excel file.

    Thank you very much.

    Hung

  • eDave

    You must get a new cell each time to do this. Look at the fgrid.il example code in share\pcb\examples\skill\form\grid.

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.