Version

Configuring igSpreadsheet

Introduction

This topic explains how to configure Ignite UI for jQuery® Spreadsheet control.

In this topic

This topic contains the following sections:

Required background

To understand this topic you need to be familiar with the concept and topics related to the Infragistics JavaScript Excel Library.

Configuring Navigation

The igSpreadsheet supports navigation of the active cell through the cells of the active pane of the currently selected worksheet. The user may change the active cell using the keyboard or mouse and use the horizontal and vertical scroll bars to change the visible columns and rows of the active sheet pane.

In addition to the normal navigation behavior, the igSpreadsheet control supports one more navigation mode:

  • End Mode - in this mode the arrow keys are used to navigate adjacent cells with data.

    The table below lists the configurable navigation behaviors of the igSpreadsheet control.

    Configurable behavior Behavior details Configuration properties
    End Mode Enable or disable end mode navigation. isInEndMode

Configuring Selection

You can control whether the existing selection is replaced or altered depending on the modifier keys (Shift and/or Control) pressed by the user.

To switch between the Spreadsheet's selection modes (normal, extendSelection and addToSelection) programmatically, use the selectionMode property.

The following table maps the desired configuration to the property settings that manage it.

In order to: Use this property: And set it to:
Set Normal mode selectionMode normal
Set extendSelection mode selectionMode extendSelection
Set addToSelection mode selectionMode addToSelection

Configuring Worksheets

You can configure several worksheet aspects using properties defined directly on the igSpreadsheet control (listed in the table below). Keep in mind, these properties are convenient when you want to update several worksheets, because they will affect all worksheets selected by the user.

The following table explains briefly the configurable aspects of the worksheets and maps them to the properties that configure them.

Configurable aspect Details Properties/Methods
Gridlines This option shows or hides the lines that separate the columns and rows. areGridlinesVisible
Headers This option shows or hides the columns' and rows' headers. areHeadersVisible
Zoom Level This option controls the magnification of the worksheet. zoomLevel

Related Links

View on GitHub