Add borderline

Add borderline

Posted by: patrik on 24 August 2020, 8:34 am EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 August 2020, 8:34 am EST

    Dim b As New FarPoint.Win.LineBorder(Color.Black, 1)
              Dim cr As New FarPoint.Win.Spread.Model.CellRange(1, 1, 5, .ColumnCount - 1)
              .SetOutlineBorder(cr, b)
  

  This code add borderline around of a cellrange.
  
  The problem is that it remove the old borderline around the cell.

  Is there a way to only add borderline and keep the old around the cell?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 25 August 2020, 2:05 am EST - Updated 30 September 2022, 1:28 pm EST

  Hi,

  That is correct behavior as the Border object assigned to the cell gets changed when you add a second border.
  
  I have attached an application with a solution to workaround it, please check.

  Regards,
  
  
  
  Spread_WinVB.zip

• 

  patrik

  • Post Options:
  • Link
    Copy

  Posted 26 August 2020, 12:48 am EST

  Thanks.