Width of Row Headings column, Filter button distorted, Navigating cells issue and Footer row

[sankarkumar23]

Few questions..

1. How to reduce the width of the Row Headings column (sequence number field)?
2. For some reason the filter button is off. I am using Telerik Blazor and it appears the CSS has been clashed.. Is there a way to ensure blazorsheet's filter button is not overridden? (See the screenshot for the issue)
3. When navigating cells using the arrow keys, the entire screen shifts up and down if a scroll bar is present. Could we modify this behavior so the screen only scrolls when the selected cell moves beyond the screen boundary, similar to Excel? On the index page (Home) from the link below, select the merged cell (Blazor DataSheet) and use the down arrow—you'll notice the selected cell quickly becomes hidden as you scroll down.
   https://anmcgrath.github.io/BlazorDatasheet/
4. Footer row like in grid controls.. I understand this is a spreadsheet.. but can we build some thing like footer to show the aggregates? I know we can show the aggregates with a formula at end of the rows but user has to scroll down to see the aggregates.
5. Is Sheet.ScreenUpdating = false; property removed.. the examples has it.. Isn't this no longer required?

[anmcgrath]

Hi @sankarkumar23

Thanks for the questions.

1. You can use Sheet.Rows.HeadingWidth = ...
2. I'm not 100% sure, I'm not familiar with the Telerik controls but the button in the column headers uses the .dropper class. Can you use the dev tools to see where it may be conflicting and I can follow up?
3. Yes this is something I have been planning on doing. I want to make the tab and arrow key events caught by the sheet so that the browser default actions (e.g scrolling) aren't performed when the sheet is active.
4. I'm not sure about this one as it's pretty specific functionality that spreadsheets generally don't have. I am planning on adding sticky rows/columns, it may be possible to include this sort of thing when I do so.
5. ScreenUpdating should improve the performance of running command groups.. I think it is still necessary especially internally.

[anmcgrath]

Are you using the nuget package? It's a little out of date from the GitHub repo so that might be it

[sankarkumar23]

Yes.. something with the package.. .dropper css is also missing.. it is present in BlazorDatasheet.bundle.scp.css, but this file itself is missing from the browser sources. I am using nuget package.. I do not see the any releases or packages in github repo. Do I need to create the package with the latest code on my local and install it? Please advise

Edit: I have taken the latest from Github and still do not see these properties. I searched the whole github repo I could not find any property with name HeadingsWidth

[anmcgrath]

This shows where the heading width property is.

I'll update the nuget package(s) soon with the latest changes.

[sankarkumar23]

Did you get a chance to update the nuget packages?

[anmcgrath]

Yes to 0.4 today. Hopefully this should work for you