Add borderline

Add borderline

Posted by: patrik on 23 August 2020, 11:34 pm EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 August 2020, 11:34 pm 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 24 August 2020, 5:05 pm EST - Updated 30 September 2022, 4:28 am 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 25 August 2020, 3:48 pm EST

  Thanks.