Overlapping Borders issue

Overlapping Borders issue

Posted by: seshareddy.kamaganiguntla on 12 July 2021, 9:14 am EST

• 

  seshareddy.kamaganiguntla

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 July 2021, 9:14 am EST - Updated 3 October 2022, 9:44 am EST

  

  Here because of border overlap , i am not getting top border for cells is there any way to resolve this

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 13 July 2021, 9:33 am EST

  Hi,

  Could you explain more about the issue and how exactly you setting the border? Could you please provide a small sample that replicates the issue so that we could investigate it further and assist you accordingly?

  Regards
  
  Avinash

• 

  seshareddy.kamaganiguntla

  • Post Options:
  • Link
    Copy

  Posted 13 July 2021, 11:57 am EST - Updated 3 October 2022, 9:44 am EST

  

  Here i am getting BLUE border as borderLeft for RED Border cell , because of overlapping issue , is there any way to fix this. I am using following type of code

  let cell = sheet.getCell(4,2);
        cell.borderLeft(new GC.Spread.Sheets.LineBorder("Blue", GC.Spread.Sheets.LineStyle.medium));
        cell.borderTop(new GC.Spread.Sheets.LineBorder("Blue", GC.Spread.Sheets.LineStyle.medium));
        cell.borderRight(new GC.Spread.Sheets.LineBorder("Blue", GC.Spread.Sheets.LineStyle.medium));
        cell.borderBottom(new GC.Spread.Sheets.LineBorder("Blue", GC.Spread.Sheets.LineStyle.medium));
        cell = sheet.getCell(4,3);
        cell.borderLeft(new GC.Spread.Sheets.LineBorder("Red", GC.Spread.Sheets.LineStyle.medium));
        cell.borderTop(new GC.Spread.Sheets.LineBorder("Red", GC.Spread.Sheets.LineStyle.medium));
        cell.borderRight(new GC.Spread.Sheets.LineBorder("Red", GC.Spread.Sheets.LineStyle.medium));
        cell.borderBottom(new GC.Spread.Sheets.LineBorder("Red", GC.Spread.Sheets.LineStyle.medium));
  

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2021, 3:51 am EST

  Hi Seshareddy,

  We are sorry but this by design. The spreadJS follows Excel policy for the borders Actually the Right border of cell A is also the left border of Cell B so if you are setting the right border of Cell A then it will replace the left border Cell B and vice versa. We are sorry for the inconvenience.

  Regards
  
  Avinash