Understanding the scrollbar in ComplyXL for viewing and comparing spreadsheet changes

I thought I'd try to give as much detailed information about how ComplyXL works. I've already shown the graphical views within ComplyXL and how detailed a report you can get with a couple of clicks. Today, I thought I'd focus on the scroll.

The scroll does more than allow the display to be scrolled up and down in ComplyXL spreadsheet comparison.

Background map

The background to the scroll bar is a map of the rows of the worksheets. Each row containing one or more differences is represented by an orange line in the scroll bar background.

If rows contain cells but there are no errors the row will be represented by a pale green color. If rows do not contain values they will be represented by a white line.

As with all scroll bars, the background can be clicked on to scroll the display window. A click above the thumb will move scroll up while a click below the thumb will move it down. Each click will move the scroll bar display up or down by one page.

Thumb

The scroll bar thumb (represented by the light blue area) indicates the relative position of the current display in the whole workbook. The size of the thumb indicates how much of the workbook is represented in the current display.

The thumb is also translucent so that the background can be seen through the thumb at all times.

Scroll buttons

The scroll buttons at the top and bottom of the scroll bar scroll the display up or down by one cell.

The map presented in the background is useful as it allows you to see where differences exist relative to the scroll bar thumb and where to scroll to review the differences.

Keyboard navigation

The scrolling behavior of the display can be controlled from the keyboard. The up and down arrow keys will scroll the display by one cell. The page up and page down keys will scroll the display by one page.