draw row backcolor to yellow while row mod 5 = 0

Posted by: fleming7612 on 8 September 2017, 1:10 pm EST

  • Posted 8 September 2017, 1:10 pm EST

    I got EvenRowBackColor and OddRowBackColor property in the custom skin popup dialog. 


    How can I draw a row backcolor every 5 rows? not like using EvenRowBackColor and OddRowBackColor .(every 2 rows)


    Thanks

  • Replied 8 September 2017, 1:10 pm EST

    There is not a way to do this in the skin.  You would have to set your skin up without alternating row colors and set the color of the rows individually after applying the skin.
  • Replied 8 September 2017, 1:10 pm EST

    Any samples?


    Our company bought your product recently, but we can't do it well and quickly.


    Any good sample or document would be useful for us.


    Thank you.

  • Replied 8 September 2017, 1:10 pm EST

    Hello,


    AlternatingRows class is not necessarily every other row. Here is code to set up an Alternating RowStyle of Yellow BackColor every 5 rows.

     
        FpSpread1.Sheets(0).AlternatingRows.Count = 5
    FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.White
    FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.White
    FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.White
    FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.White
    FpSpread1.Sheets(0).AlternatingRows(4).BackColor = Color.Yellow
     
Need extra support?

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

Learn More

Forum Channels