Export: style are getting changed

Posted by: k.vijayakumar.mca on 11 October 2017, 7:36 am EST

  • Posted 11 October 2017, 7:36 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.
  • Marked as Answer

    Replied 16 October 2017, 7:09 am EST

    Hello,

    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