This is a migrated thread and some comments may be shown as answers.

Disable ScrollBar in all sheets of RadSpreadSheet

1 Answer 142 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Dexter
Top achievements
Rank 1
Dexter asked on 04 Dec 2014, 05:48 AM
Hello, I would like to enquire on a solution to the problem as per title. This is my code currently:
for (int i = 0; i < maximumSheet; i++)
            {
                sheet1211.ActiveWorksheet = worksheets[i];
                double scaledWidth = (0.85 / 1366.00) * SystemInformation.VirtualScreen.Width;
                double scaledHeight = (0.85 / 768.00) * SystemInformation.VirtualScreen.Height;
                sheet1211.ActiveSheetEditor.ScaleFactor = new Size(scaledWidth, scaledHeight);
                sheet1211.ActiveSheetEditor.ScrollBarsProvider.HorizontalScrollBar.Visibility = Visibility.Collapsed;
                sheet1211.ActiveSheetEditor.ScrollBarsProvider.VerticalScrollBar.Visibility = Visibility.Collapsed;
            }

The ScaleFactors work across all sheets, but the ScrollBar didn't work for any of the sheets.
Doing just sheet1211.ActiveWorksheet = worksheets[0] and set the ScrollBars visibility works, but that's only 1 sheet, and furthermore if I change to the next sheet and back to worksheet[0] again in runtime by interface, the scrollbars will appear again.

So how do I set the visibility across all sheets just like how I set the ScaleFactor?

Thanks for your attention.

1 Answer, 1 is accepted

Sort by
0
Dexter
Top achievements
Rank 1
answered on 18 Dec 2014, 01:26 AM
Hi, still finding the solution for this.
Tags
Spreadsheet
Asked by
Dexter
Top achievements
Rank 1
Answers by
Dexter
Top achievements
Rank 1
Share this question
or