Scrollbar Options

You can hide or show the vertical or horizontal scroll bar using showVerticalScrollbar or showHorizontalScrollbar properties, respectively.

You can use the options.scrollbarMaxAlign property to specify whether to align the scroll bar with the last row and column of the active sheet. You can use the options.scrollbarShowMax property to specify whether the displayed scroll bars are based on the total number of columns and rows in the sheet.

You can specify whether to ignore hidden rows or columns with the options.scrollIgnoreHidden property. This applies to columns or rows with zero width or height, columns or rows hidden with the visible method, collapsed and grouped columns or rows, or filtered out rows.

Using Code

The following example hides the vertical and horizontal scroll bars.

spread.options.showHorizontalScrollbar = false;
spread.options.showVerticalScrollbar = false;