Difference between revisions of "Spreadsheet Tricks"

From TeleCafeWiki
Jump to navigation Jump to search
(Comment out buggy widgets.)
(Remove comments on Google Spreadsheet tricks.)
Line 1: Line 1:
 
{{RightTOC}} <!-- See: Manual:$wgRawHtml -->
 
{{RightTOC}} <!-- See: Manual:$wgRawHtml -->
 
=== Array Formula In Google Spreadsheet ===
 
=== Array Formula In Google Spreadsheet ===
11:26, 19 January 2014 (PST): Commenting out until bugfix is found.
+
<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html><br />
<!-- <html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html> -->
 
  
 
== Embedding Spreadsheets & Parts of Spreadsheets ==
 
== Embedding Spreadsheets & Parts of Spreadsheets ==
Line 10: Line 9:
  
 
=== Embed Google Spreadsheet ===
 
=== Embed Google Spreadsheet ===
11:26, 19 January 2014 (PST): Commenting out until bugfix is found.
+
<html><iframe width='500' height='350' frameborder='0' src='https://docs.google.com/spreadsheet/ccc?key=0Aumujjc9cTZhdE92TExvcjU5NVZBbFk2Ul82dFI1ZUE&single=true&gid=0&range=J2%3AQ12&output=html&widget=true'></iframe></html>
<!-- <html><iframe width='500' height='350' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Aumujjc9cTZhdE92TExvcjU5NVZBbFk2Ul82dFI1ZUE&single=true&gid=0&range=J2%3AQ12&output=html&widget=true'></iframe></html> -->
 
 
; Sources
 
; Sources
 
* [https://sites.google.com/a/googleapps.com/sitesbp/site-development/tips-tricks/inserting-portions-of-a-google-spreadsheet-into-a-google-sites-page Inserting Portions of a Google Spreadsheet into a Google Sites Page]
 
* [https://sites.google.com/a/googleapps.com/sitesbp/site-development/tips-tricks/inserting-portions-of-a-google-spreadsheet-into-a-google-sites-page Inserting Portions of a Google Spreadsheet into a Google Sites Page]

Revision as of 19:25, 4 February 2014

Array Formula In Google Spreadsheet

<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html>

Embedding Spreadsheets & Parts of Spreadsheets

Embed SkyDrive Spreadsheet

<html><iframe width="650" height="450" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=0D58D956AB4BC9E0&resid=D58D956AB4BC9E0%21117&authkey=AH7Glp3oB3WJ4Ag&em=2&AllowTyping=True&wdDownloadButton=True"></iframe></html>
iFrame code for the spreadsheet on SkyDrive

Embed Google Spreadsheet

<html><iframe width='500' height='350' frameborder='0' src='https://docs.google.com/spreadsheet/ccc?key=0Aumujjc9cTZhdE92TExvcjU5NVZBbFk2Ul82dFI1ZUE&single=true&gid=0&range=J2%3AQ12&output=html&widget=true'></iframe></html>

Sources
See Also

Embed EditGrid Spreadsheet

<html><iframe title="An EditGrid spreadsheet created by evolvnet/djmyers" longdesc="http://www.editgrid.com/evolvnet/djmyers/ups_-_usps_show_color_coded_rates" name="gridContainer" frameborder="0" src="http://www.editgrid.com/publish/html/evolvnet/djmyers/136965004/J1:Q12?plain_table_mode=1&bgcolor=%23ffffff&fgcolor=%23000000&version=2&frame_style=height%3A219px%3Bwidth%3A100%25" style="height:219px;width:100%"> </iframe></html>

Sources

Embed PiratePad (or EtherPad)

<html><iframe style="border:1px solid gray; height:500px; width:700px"

   src="http://piratepad.net/yqpFWafTKt?fullScreen=1"></iframe></html>