Hello, I would like to enquire on a solution to the problem as per title. This is my code currently:
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.
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.