Export: style are getting changed

Posted by: k.vijayakumar.mca on 10 October 2017, 10:36 pm EST

    • Post Options:
    • Link

    Posted 10 October 2017, 10:36 pm 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);


    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.

  • Posted 15 October 2017, 10:09 pm EST


    I am not able to replicate this issue using SpreadJS 10.2.3. Please refer to the attached sample. I exported the Spread.Sheets to Excel and found the border is not set to dash/dotted.

    Please check the sample and let me know in case the issue still persists.

    Thanks, Deepak SharmaSpreadJSBorderStyle.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels