Outer Borders for XlSio

As far as I can tell, you can only set styles and borders that will apply to individual cells and not outer borders for ranges of cells.  So if I want to create


Example of a border style: 

Style bordered = workbook.styles.add('bordered');

bordered.borders.all.lineStyle = LineStyle.thin;

sheet.getRangeByName('A1:H10').cellStyle = bordered;


This gives every individual cell a thin border around it, as desired.


However, if I want to display a LineStyle.thick around just the outer borders of this box (A10:C10) with the inner cells having the thin border, I need to create 5-9 total styles? (depending on other requirements).  Or is there a better way to define cell specific border styles and then Range outer border styles...in a way consistent with how excel itself treats this?


1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team November 23, 2022 01:52 PM UTC

Hi Bryan,


Syncfusion Flutter XlsIO do not have support for applying outside borders to a range as requested. As of now, borders must be applied individually to meet your needs. 


Regards,

Keerthi.


Loader.
Up arrow icon