Export: style are getting changed

Export: style are getting changed

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

• 

  k.vijayakumar.mca

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 15 October 2017, 10:09 pm 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