DoubleLineBorder

DoubleLineBorder

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

• 

  stephane.chabeau

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 December 2020, 8:27 pm EST

  Hi

  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

  Stephane

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 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.
  
  SpreadDoubleBorder.zip

  Alternatively, you can also use any of the following way depending on your requirement:
  
  Column:

  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

• 

  stephane.chabeau

  • Post Options:
  • Link
    Copy

  Posted 19 December 2020, 12:38 am EST

  Everything works well

  thank you so much

  Stephane