Difference between revisions of "Spreadsheet Tricks"

From TeleCafeWiki
Jump to navigation Jump to search
(Remove comments on Google Spreadsheet tricks.)
(Removed EditGrid & Pirate Pad embeds. Added section: Quick Edit Sheets)
Line 15: Line 15:
 
* [http://productforums.google.com/forum/#!msg/docs/HHDMCcfSvEM/rrh9iv5XdPYJ Share spreadsheet with link to a sheet/cell]
 
* [http://productforums.google.com/forum/#!msg/docs/HHDMCcfSvEM/rrh9iv5XdPYJ Share spreadsheet with link to a sheet/cell]
  
=== Embed EditGrid Spreadsheet ===
+
== Quick Edit Sheets ==
<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%">&nbsp;</iframe></html>
+
* [https://ethersheet.org/ Ethersheet]
; Sources
+
: Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also [https://github.com/ethersheet-collective/EtherSheet download the code on GitHub].
* [https://wiki.editgrid.com/display/helpcentre/Publish+a+cell+or+region Publish a cell or region]
 
  
=== Embed PiratePad (or EtherPad) ===
+
* [http://www.editgrid.com/ EditGrid]
<html><iframe style="border:1px solid gray; height:500px; width:700px"
+
: Unfortunately, EditGrid's service is ending May 1, 2014.<ref>[http://www.editgrid.com/ EditGrid service is ending May 1, 2014]</ref>
    src="http://piratepad.net/yqpFWafTKt?fullScreen=1"></iframe></html>
+
 
 +
=== Other Edit Pads (Non-Spreadsheet) ===
 +
* [http://etherpad.org/ Etherpad.org]
 +
* [http://piratepad.nl/ PiratePad.nl]
 +
* [http://piratepad.net/front-page/ Piratepad.net]
 +
* [https://www.piratepad.ca/ PiratePad.ca]
 +
 
 +
== References ==
 +
{{Reflist}}

Revision as of 19:02, 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

Quick Edit Sheets

Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also download the code on GitHub.
Unfortunately, EditGrid's service is ending May 1, 2014.[1]

Other Edit Pads (Non-Spreadsheet)

References