Posted by: stephane.chabeau on 16 December 2020, 8:27 pm EST

  • Posted 16 December 2020, 8:27 pm EST


    Is there a way to put a double border around an area of ​​cells ?
    If we do:
    Dim CR As New Model.CellRange (1, 2, 8, 5)
    Dim DL As New DoubleLineBorder (Color.Red)

    MySp.activesheet.SetOutlineBorder(CR, DL)

    it does not work (it is a single line that appears)

    i have Spread for Windows 7.35 (in VB)

    Thank you

  • Marked as Answer

    Replied 17 December 2020, 11:04 pm EST

    Hello Stephane,

    Since, Spread.NET v7 is very old version, it's support is no more provided. Therefore, we will be answering your concern according to Spread.NET v14.
    To show complex border, you should use ComplexBorder with ComplexBorderSide of type DoubleLine while setting the outline border. Please refer to the sample attached.

    Alternatively, you can also use any of the following way depending on your requirement:
    FpSpread1.ActiveSheet.Columns(0).Border = New FarPoint.Win.DoubleLineBorder(Color.Red)
    Single cell/cell-range :
    Dim doubleLine As DoubleLineBorder = New DoubleLineBorder(Color.Red)
    FpSpread1.Sheets(0).Cells(10, 10).Border = doubleLine
    FpSpread1.Sheets(0).Cells(1, 2, 8, 5).Border = doubleLine
  • Replied 19 December 2020, 12:38 am EST

    Everything works well

    thank you so much

Need extra support?

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

Learn More

Forum Channels