BorderLines Left and Top not shown for border cells

Posted by: Jose.Aguirre on 25 January 2021, 12:02 am EST

  • Posted 25 January 2021, 12:02 am EST

    I created my own project from your sample Spread WPF Explorer a did the following changes:

    this.gcSpreadSheet1.Workbook.VerticalScrollBarVisibility = ScrollBarVisibility.Hidden;
    this.gcSpreadSheet1.Workbook.HorizontalScrollBarVisibility = ScrollBarVisibility.Hidden;
    this.gcSpreadSheet1.TabStripVisibility = Visibility.Collapsed;

                sheet.ColumnHeader.IsVisible = false;
    sheet.RowHeader.IsVisible = false;

    After selecting cells within the 3 rows and 3 columns, I set the border style and applied. The result is in the attached picture. As you can see, there are missing the border style shown for cells A1,A2,A3 (left borders) and A1,B1,C1 (top borders).

    This issue is of high value for our customers as they want to display the border styles as they have set. Please help!

  • Replied 27 January 2021, 9:47 pm EST

    The spreadsheet control is designed to emulate Excel. When you assign border for a cell, next to the row header/ column header then border will not apply on the line which is shared by any header.
    You can check same behavior with MS Excel.
    If you try to set double border then only single line will be display.

    Hence, this is design behavior of spreadsheet.

  • Replied 28 January 2021, 6:55 pm EST

    we could live with the view not showing the left/top borders but the final result (on paper print or pdf) should be correct. But it is not!

    Below is the result when printing to pdf (note the very thin left/top lines):

    Below is the result when printing to paper printer (note that left/top lines are missing totally):

    And below is the result when printing similar edited cells to paper from Excel (note that the result is correct):

    Please fix this bug. Thanks!
  • Replied 31 January 2021, 3:15 pm EST

    We are able to replicate the print issue and hence we are escalating the same to the concerned team as a bug request.

    We will update you as soon as we hear anything from our concerned team.

    Tracking Id : SPNET-15151 (for internal use only)

Need extra support?

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

Learn More

Forum Channels