Spreadsheet horizontal scrollbar not adjusted when Toolbar and SheetBar to false

1 Answer 122 Views
ScrollView Spreadsheet
serge
Top achievements
Rank 2
Bronze
Iron
Iron
serge asked on 12 May 2021, 10:01 AM | edited on 12 May 2021, 10:18 AM

When the toolbar and sheetbar are invisible, the bottom horizontal scrolbar is not ajusted (is a little bit above it should be)

@(Html.Kendo()
    .Spreadsheet()
    .Name("spreadsheet")
    .HtmlAttributes(new {style = "width:100%"})
    .Toolbar(false)
    .Sheetsbar(false)

I mean, esthetically, if we suppose that the vertical and horizontal bars should have the same distance to the external border.

For the vertical scrolbar that distance is zero. Should be the same for the horizontal then.

picture:

detailed view:

or add a similar margin to the vertical one:


1 Answer, 1 is accepted

Sort by
1
Accepted
Aleksandar
Telerik team
answered on 17 May 2021, 06:30 AM

Hi Serge,

You are indeed correct and this is an unexpected behavior. I have therefore logged an issue on your behalf:

https://feedback.telerik.com/kendo-jquery-ui/1519823-when-the-sheetsbar-is-hidden-the-horizontal-scrollbar-is-not-adjusted-to-the-bottom-of-the-widget

When hiding the Sheetsbar you can add the suggested styling so the scrollbar is adjusted to the bottom of the widget:

<style>
    .k-spreadsheet-sheets-bar {
      padding: 0;
      border-style: none;
    }
</style>

I hope this approach works for your scenario.

I have also updated your Telerik points, as a token of gratitude for helping us improve our product.

Regards,
Aleksandar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

serge
Top achievements
Rank 2
Bronze
Iron
Iron
commented on 17 May 2021, 12:00 PM

that is not enought, there is a blank space between spreadsheet-pane and the spreadsheet-fixed-container
Aleksandar
Telerik team
commented on 20 May 2021, 08:38 AM

Do you mean the Spreadsheet containers are not expanded correctly? In general, the Spreadsheet performs internal calculations for wrapping the containers and after applying the CSS suggested above it looks like the styling is correct on my end - example. I have tested this in Chrome and Firefox. Is this approach not working for you? 

serge
Top achievements
Rank 2
Bronze
Iron
Iron
commented on 20 May 2021, 11:30 AM

now, the problem is when we want to display the toolbar and sheetbar, we have no padding... this should be fixed, if possible
Aleksandar
Telerik team
commented on 25 May 2021, 07:13 AM

You can dynamically apply the styling to the Spreadsheet widgets that do not have a Toolbar, for example:

$('.k-spreadsheet').each(function(idx,elm){
        var spread = $(elm).getKendoSpreadsheet();
        if(!spread.options.toolbar){
          $(elm).find('.k-spreadsheet-sheets-bar').css({'padding':0,'border-style':'none'})
        }
      })
Tags
ScrollView Spreadsheet
Asked by
serge
Top achievements
Rank 2
Bronze
Iron
Iron
Answers by
Aleksandar
Telerik team
Share this question
or