Borders are getting distorted when open excel through spreadsheet.

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

  • 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
  • Replied 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
  • Replied 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
  • Replied 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,
  • Marked as Answer

    Replied 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);
    Regards,
Need extra support?

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

Learn More

Forum Channels