Widget:Google Spreadsheet

This template creates the citation references for a Google Spreadsheet. It is intended to be used as a companion with Widget:Google Spreadsheet.

Google Drive does not automatically display a chart image when viewing a wiki page. Selecting a different sheet then back again, will force the chart image to be displayed.

This template adds a note to document the above work-around.

Usage

Use this template with Widget:Google Spreadsheet.

Parameters:

• key

For example, a Google spreadsheet of the following form:

{{#widget:Google Spreadsheet
|key=0AueLhNpKZa4XdGJwNkdwdmthVXk2TjExOVd5eFUzMUE
|width=500
|height=300
}}

Insert the key as: {{Spreadsheet|key=0AueLhNpKZa4XdGJwNkdwdmthVXk2TjExOVd5eFUzMUE}}

To produce:

Combine with widget

Use this template with Widget:Google Spreadsheet to allow readers access to the spreadsheet:

{|
|-
|{{#widget:Google Spreadsheet
|key=0AueLhNpKZa4XdGJwNkdwdmthVXk2TjExOVd5eFUzMUE
|width=750
|height=450}}<br>
{{spreadsheet|key=0AueLhNpKZa4XdGJwNkdwdmthVXk2TjExOVd5eFUzMUE}}
|}

Results in: