Export (0) Print
Expand All

Ewa.EwaControl.add_gridSynchronized(function)

Last modified: June 13, 2011

Applies to: apps for SharePoint | SharePoint Server 2010

In this article
Return Value
Remarks
Example

Adds an event handler to the gridSynchronized event.

Ewa.EwaControl.add_gridSynchronized(function);

function

The event handler to subscribe to the event.

The EwaControl.add_gridSynchronized method subscribes an event handler to the gridSynchronized event.

Note Note

The grid is the construct that Excel Services uses to display the viewable area of the Worksheet within the Excel Web Access Web Part.

The gridSynchronized event is raised when the grid is finished rendering, when the workbook is loaded or reloaded, or when grid blocks are updated. The event is also raised the first time that the event handler is subscribed to (the grid will have finished rendering before this).

When the specified event handler for the gridSynchronized event is invoked, it is invoked with a single argument of type Ewa.WorkbookEventArgs. The Ewa.WorkbookEventArgs object contains information about the Workbook associated with the gridSynchronized event.

The following code example subscribes an event handler to the gridSynchronized event. The code also shows how to use the Ewa.WorkbookEventArgs to get information about the associated Workbook.

<script type="text/javascript">

var ewa = null;

// Add event handler for onload.
if (window.attachEvent)
{
    window.attachEvent("onload", ewaOnPageLoad);
}

// Add event handler for applicationReady event.
function ewaOnPageLoad()
{
    if (typeof (Ewa) != "undefined")
    {
        Ewa.EwaControl.add_applicationReady(ewaApplicationReady);
    }
    else
    {
        alert("Error - the EWA JS is not loaded.");
    }
}

function ewaApplicationReady()
{
    ewa = Ewa.EwaControl.getInstances().getItem(0);

    // Add event handler for gridSynchronized event.
    ewa.add_gridSynchronized(gridSync);
}

// Handle gridSynchronized event.
function gridSync(args)
{
    alert(args.getWorkbook().getActiveSelection().getAddressA1());
}
</script>

Show:
© 2015 Microsoft