Google Docs and Spreadsheets: Difference between revisions
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
== Copy & Paste == | == Copy & Paste == | ||
{{#widget:Iframe | {{#widget:Iframe | ||
|url=https://docs.google.com/spreadsheet/ | |url=https://docs.google.com/spreadsheet/pub?key=0AuFlnVY9TNrsdDJodlRYRG1zWUY4dFd4SktiZzVyYlE&single=true&gid=0&range=A1%3AG7&output=html | ||
|width=100% | |width=100% | ||
|height= | |height=AUTO | ||
|border=1 | |border=1 | ||
}} | }} | ||
[https://docs.google.com/spreadsheet/ccc?key=0AuFlnVY9TNrsdDJodlRYRG1zWUY4dFd4SktiZzVyYlE&usp=sharing 線上編輯] | |||
* Microsoft Excel --> Google Spreadsheet: | * Microsoft Excel --> Google Spreadsheet: | ||
** columns & rows: Copy & Paste is ok | ** columns & rows: Copy & Paste is ok | ||
Revision as of 09:44, 24 September 2013
Copy & Paste
- Microsoft Excel --> Google Spreadsheet:
- columns & rows: Copy & Paste is ok
- Plain text --> Google Spreadsheet: ok
- columns: Tab separated columns --> Google Spreadsheet: ok
- rows: Enter separated rows --> Google Spreadsheet: ok
- Plain text --> Microsoft Excel: ok
- columns: Tab separated columns --> Microsoft Excel: ok
- rows: Enter separated rows --> Microsoft Excel: ok
- Microsoft Excel --> Table of Google Document:
- columns & rows: Copy & Paste is ok
- Plain text --> Table of Google Document: fail
Suggest you copy to Microsoft Excel first and then copy paste to Google Document from Microsoft Excel.
- columns: Tab separated columns --> Table of Google Document: fail
- rows: Enter separated rows --> Table of Google Document: fail
- Plain text --> Microsoft Excel: ok
- columns: Tab separated columns --> Microsoft Excel: ok
- rows: Enter separated rows --> Microsoft Excel: ok
- How-to Create and Copy a Table in Google Mail (Gmail) from Excel - YouTube
Google spreadsheet
利用Google spreadsheet的函式，分析及統計可複選的問卷題目結果。
MovableType
MT 3.x
check Post via Google Docs
MT 2.x
- API: MovableType API
- URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi
- If you met the HTTP 503 code(Service Unavailable), you can switch the URL from domain name to IP address.
- Blog ID/Title
- Blog ID is not work!
- Blog title: It's Case-sensitive and was not support Chinese.