Borders are getting distorted when open excel through spreadsheet

Borders are getting distorted when open excel through spreadsheet

Posted by: krishna.vajja on 4 August 2020, 4:45 pm EST

• 

  krishna.vajja

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 August 2020, 4:45 pm EST

  Hi,

  The spread application distorts the original excel datasheet. This seems to include borders, text, and cell sizing. The appearance of the spreadsheet should remain the same between excel and spreadsheet software, but it does not. This is a big issue since we have a large catalogue of excel datasheets that cannot be properly imported into the spreadsheet.

  While importing one excel template, some cell’s borders are not showing in the grapecity spread sheet designer and even the gridline between the consecutive cell is missing for this, but similar cells in the same column are not showing this issue.

  Please have a look into this issue.

  Regards,
  
  Krishna.201328725428542-10000-197.zip[img]https://gccontent.blob.core.windows.net/forum-uploads/file-0f12bfdd-06a0-4b0f-9747-e776f3b744df.JPG[/img][img]https://gccontent.blob.core.windows.net/forum-uploads/file-b0e7c792-0c05-4b1e-a529-c678949d935a.JPG[/img]

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2020, 8:47 pm EST

  Hi Krishna,

  We are sorry but we are unable to replicate the issue at our end using the latest SJS version 13.2.0. We used the following designer demo to test the excel file:
  
  https://www.grapecity.com/spreadjs/designer/content/index.html
  
  Could you please let us know about the exact spread version you are using, so that we may test on the same version too

  Regards

• 

  krishna.vajja

  • Post Options:
  • Link
    Copy

  Posted 11 August 2020, 6:22 pm EST

  Hi Tomer,

  Thanks for the quick reply.

  We have created a video by exporting excel to spread designer and still able to reproduce the issue.

  Spread version and details are included in the video, please have a look and help us in solving the issue.

  Thanks,
  
  Krishna.
  
  Cell_Border_Issue.zip

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 16 August 2020, 11:26 pm EST

  Hi Krishna,

  Thank you for the video, I can observe the border issue and hence, have forwarded it to the development team for fix [ID: 10920].
  
  We’ll update you as soon as it is fixed.

  Regards,

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 29 August 2020, 6:46 am EST

  Hi Krishna,

  Cell AM41 has value as space (" "). Because of different text painting, Spread paint it with a little wider than Excel. The width of column AM is not enough to show the space (and text padding) fully, so it’ll overflow the next cell.
  
  You can try the following code after open the XLSX file to see the painting result if column AM is painted fully without overflow.```
  
  fpSpread1.ActiveSheet.Columns[38].Width = fpSpread1.ActiveSheet.GetPreferredColumnWidth(38);