Posted 10 October 2017, 10:36 pm EST - Updated 11 January 2024, 5:42 am EST
HI Team,
while exporting formatted sheet of spread, the grid lines(borders) are changing to dotted. I debugged and my observation is “getCell” is the culprit.
To format we used below line of code.
var cell = exportSheet.getCell(i, 0);
cell.font(‘bold’);
cell.hAlign…
How and where can i overwrite the style?
I tried below ways but taking time for 10k records
exportSheet.getRange(-1, -1, -1, -1, GC.Spread.Sheets.SheetArea.viewport).setBorder(new GC.Spread.Sheets.LineBorder(‘#C0C0C0’, GC.Spread.Sheets.LineStyle.thin), {all: true}, 3);
or
cell.borderLeft(new GC.Spread.Sheets.LineBorder(‘#C0C0C0’, GC.Spread.Sheets.LineStyle.thin)).borderRight(new GC.Spread.Sheets.LineBorder(‘#C0C0C0’, GC.Spread.Sheets.LineStyle.thin)).borderTop(new GC.Spread.Sheets.LineBorder(‘#C0C0C0’, GC.Spread.Sheets.LineStyle.thin)).borderBottom(new GC.Spread.Sheets.LineBorder(‘#C0C0C0’, GC.Spread.Sheets.LineStyle.thin));
Please suggest.