Permanently protected template

Template:Spreadsheet

From Bogleheads
Jump to navigation Jump to search

(View Google Spreadsheet in browser, then File --> Download as to download the file.)
Note: If the spreadsheet is blank, select a different sheet, then back to that sheet. The image will be refreshed.

Template documentation[view] [edit] [history] [purge]

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:

(View Google Spreadsheet in browser, then File --> Download as to download the file.)
Note: If the spreadsheet is blank, select a different sheet, then back to that sheet. The image will be refreshed.

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:


(View Google Spreadsheet in browser, then File --> Download as to download the file.)
Note: If the spreadsheet is blank, select a different sheet, then back to that sheet. The image will be refreshed.